ICT 216 Database Management Systems

Credits: 3

Course Content:
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.

Course Format:

  • Approximately 45 hours to complete and scheduled over a 15-week period.

Course Prerequisites:
ICT 214 - Database Design

Transfer Credits:
For current information and details on transfer credit for this and other courses, check the BC Transfer web site at http://bctransferguide.ca/.

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 and apply indexes.
  • Manage backups.
  • Database Performance Tuning and Optimization

Required Materials/Texts: see Course Textbooks page.

Evaluation Profile:

Assignments/Exercises
10-20%
Quizzes/Exams
20-30%
Projects (2)
30-40%
Final Exam
20-30%
TOTAL 100%

Grading Profile:
Percentage grades will be converted to letter grades at the home institution.

Syllabus:

Module
Topics
1 Review Relational Design
2 SQL Advanced Queries
3 Scripting, batches
4 DDL - SQL Data Integrity, Constraints and Rules using scripts
5 Programmability
6 Stored Procedure and Triggers
7 Transaction Management and Concurrency
8 Database Administration and Security
9 Backup and Recovery
10 Database Performance Tuning and Query Optimization

Operational Details:

College Policies: Academic Appeals (including appeal of final grades), Student Conduct, Cheating and Plagiarism, Academic Probation and other educational issues are those of the institution where the student is registered.
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.
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 department, supporting a valid reason for missing the quiz or test (i.e. family or personal emergency, etc.).
Late Assignments: Late assignments will not be marked without the student having made prior arrangements with the instructor.
Cheating/Plagiarism: Plagiarism is the presentation of another person's words, ideas, interpretations, insights, or order of points as one's own. All work submitted must be the student's own words and content, and not written by a tutor or friend. If external sources are used for an essay or assignment, they must be documented to avoid plagiarism.