In this course we will be using MS SSQL Server. This database is used by a large business base in all variety of industries. Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. This course is designed for students who already understand relational database design and have a basic understanding of SQL. This course will further provide students with an in-depth understanding of designing, implementing, and configuring MS SQL Server.
Topics include SQL Server architecture, use of indexes, DDL and DML, security, transactions, optimization, and replication. Upon successful completion, students will be able to perform complex queries, use the transact SQL language, create stored procedures and triggers, administer system access and end-users, plan back-ups.
This course helps prepare students to write the MS SQL Server implementation and design certification exam.
The course will include Aboriginal cultural knowledge appropriate to the discipline and inclusive of the many communities the course is meant to serve. Industry Leaders like, Phil Sorgen, the past president of Microsoft Canada have stated that engagement of Aboriginal People of Canada into the ICT sector is critical to the country’s ongoing competitive position. Faculty are encouraged to engage Elders to find ways for the course to include cultural knowledge keeping in mind that each course is delivered across multiple traditional territories.
Hours: 45 (Lecture Hours)
Total Weeks: 15
This course is offered online: Yes
Pre-Requisites: ICT 214 Database Design
Non-Course Pre-Requisites: None
Review Relational Design
SQL Advanced Queries
DDL - SQL Data Integrity, Constraints and Rules using scripts
Stored Procedure and Triggers
Transaction Management and Concurrency
Database Administration and Security
Backup and Recovery
Database Performance Tuning and Query Optimization
Upon successful completion of this course the student has reliably demonstrated the ability to:
- Create and manage databases, tables, and transaction logs
- Enforce data integrity using constraints, defaults, and rules
- Plan for appropriate use of database objects
- Create and maintain indexes
- Write complex queries that retrieve and modify data
- Write queries that summarize data
- Manage locking options and transactions to ensure data concurrency and recoverability
- Create views of data
- Design and create stored procedures
- Design and create triggers
- Manage system access
- Manage and apply indexes
- Manage backups
- Database Performance Tuning and Optimization
Grading System: Letters
Passing Grade: D (50%)
Text Books: Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.