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.
CST Certificate Program Admission, ICT 214 – Database Design
Database Systems, Design, Implementation, and Management – Coronel/Morris/Rob, Latest Edition, Course Technologies