B.C.'s Energy College


Apply Now
top menu Current Students Prospective Students Community Faculty & Staff
ICT 216 - Database Management
Course Details
Course Code:
ICT 216

Credits:
3

Calendar Description:
In this course students will be using a Microsoft Structured Query Language(SQL) Server. This database is used by a large business base in a variety of industries. Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database systems. It is used at different levels and with various goals. Students who already understand relational database design and SQL are provided with an in-depth understanding of designing, implementing, and configuring a MS SQL Server. Topics include SQL Server architecture, DDL and DML (CREATE, SELECT, INSERT, UPDATE, JOIN, etc.), importing/exporting data, security, transactions, optimization, and replication. Upon successful completion, students will be able to perform complex queries, use the transact SQL language, administer system access and end-users, plan back-ups, and carry out disaster recovery policies. This course helps prepare students to write the MS SQL Server implementation and design certification exam.

Date First Offered:
2010-01-01

Hours:
Total Hours: 45
Lecture Hours: 45


Total Weeks:
10

This course is offered online:
Yes

Pre-Requisites:
ICT 214 Database Design

Non-Course Pre-Requisites:
None

Co-Requisites:
None

Rearticulation Submission:
No

Course Content:
- Term Project Overview
- Review of Relational design
- SQL Advanced Queries
- Insert, Update and Delete
- SQL Data Integrity, Constraints and Rules
- Programmability
- Stored Procedure and Triggers
- Transaction Management and Concurrency
- Backup and Recovery

Learning Outcomes:
Upon successful completion of this course, students will be able 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 backups and carry out a disaster recovery

Grading System:
Letters

Passing Grade:
C (60%)

Grading Weight:
Final Exam: 30 %
Midterm Exam: 20 %
Assignments: 10 %
Project: 20 %
Participation: 20 %

Percentage of Individual Work:
100

Course Offered in Other Programs:
No

Additional Comments:
Attendance: As this is an on-line course, attendance requires participation in the course, not time in a classroom. However, students must ensure that they complete their required participation in online discussions and other similar assignments. Online meeting/discussion forums times may be arranged in conjunction with the students availability.

Missed Exams: Quizzes and periodic tests must be written when scheduled for the class. This policy may be modified should the student submit written documentation, acceptable to the instructor, supporting a valid reason for missing the quiz or test (i.e. family or personal emergency, etc.). If an approved alternate quiz or test is not available or cannot be scheduled, the weighting of the final exam may be adjusted to compensate at the discretion of the instructor. The student will not successfully complete the course without passing the final exam and completing at least 50% of scheduled quizzes and tests.

The letter grade will be determined by the college at which you are registered.

Late assignments: Late assignments will not be marked without the student having made prior arrangements with the instructor.

Policies and Procedures: Students registered in the Northern Collaborative Information Technology Program are guided by the policies and procedures of their registering college. You are encourage to review the policy definitions and guidelines of the college at which you are registered. You can view these policies and procedures by visiting your college's website or by contacting the Program Coordinator.

Plagiarism Guidelines: The instructor will advise the student in writing if plagiarism is suspected; a copy of this letter should be sent to the coordinator at the registering college;

Supplies:
Optional Text: Rob, Coronel, Database systems Design, Implementation, and Management, Thompson Publishing. Latest edition.

Text Books:
Optional - N/A, Required text/materials: to be determined.
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