INFO361 - Relational Databases with MS SQL Server
View Academic Calendar
This course is a study of the principles of relational databases, the ANSI standard Structured Query Language (SQL), and the Microsoft Transact-SQL in the context of Microsoft SQL Server. Students will create, alter, and drop tables; create, alter, and drop constraints; create, alter, and drop views; and create, tune, and drop indexes. They will also build transactions, triggers, Transact-SQL queries, and stored-procedures. They will review triggers to implement data integrity and business rules. They will use DTS packages and transformations, the Enterprise Manager, Query Analyzer, and Database Configuration interfaces. They will also create and manage databases, database devices, backups, and restores; import/export data; and schedule automated tasks. Students must have access to Microsoft SQL Server 2000, 2005, or the Express Edition (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.
Prerequisites
N/A
Corequisites
N/A
Schedule of Classes
| 10/31/11 - 03/25/12 |
04/02/12 - 05/27/12 |
Spring 2012 Session B - 8 Week session |
| 12/26/11 - 05/27/12 |
06/04/12 - 07/29/12 |
Spring 2012 Session D - 8 Week session |
Course Materials
| Book Title: |
Stateside & Canadian Students: The e-book is available via the Online Library and the access information is provided in the classroom. If you wish to purchase the hard copy text, you may do so through the bookseller of your choice.
|
| ISBN: |
Online Library E-book Note
|
| Publication Info: |
N/A
|
| Author: |
N/A
|
| Unit Cost: |
N/A
|
| |
| Book Title: |
Professional Microsoft SQL Server 2008 - e-book available in the APUS Online Library
|
| ISBN: |
0470257024
|
| Publication Info: |
Wiley
|
| Author: |
Vieira, Robert
|
| Unit Cost: |
$34.50
|
| |
| Book Title: |
Students must have access to required software. APUS does not supply this software.
|
| ISBN: |
Software Note
|
| Publication Info: |
N/A
|
| Author: |
N/A
|
| Unit Cost: |
N/A
|
| |
