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: 3)
Total Weeks: 15
ICT 214 Database Design
- Review Relational Design
- SQL Advanced Queries
- Scripting, batches
- 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%)
Percentage of Individual Work: 100
Textbooks are subject to change. Please contact the bookstore at your local campus for current book lists.