B.C.'s Energy College


Apply Now
ICT 216 - Database Management
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.

Credits: 3

Hours: 45 (Lecture Hours)

Total Weeks: 15

This course is offered online: Yes

Pre-Requisites: ICT 214 Database Design

Non-Course Pre-Requisites: None

Co-Requisites: None

Course Content:
Review Relational Design
SQL Advanced Queries
Scripting, batches
DDL - SQL Data Integrity, Constraints and Rules using scripts
Programmability
Stored Procedure and Triggers
Transaction Management and Concurrency
Database Administration and Security
Backup and Recovery
Database Performance Tuning and Query Optimization

Learning Outcomes:
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.
Home   |   About NLC   |   Admissions   |   Programs   |   Services   |   Student Life   |   News & Events   |   Contact Us
Northern Lights Facebook Fan Page Northern Lights Twitter Page Northern Lights YouTube Page