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:
Total Hours: 45
Lecture Hours: 45
This course is offered online:
ICT 214 Database Design
- Term Project Overview
- Review of Relational design
- SQL Advanced Queries
- Insert, Update and Delete
- SQL Data Integrity, Constraints and Rules
- Stored Procedure and Triggers
- Transaction Management and Concurrency
- Backup and Recovery
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
Final Exam: 30 %
Midterm Exam: 20 %
Assignments: 10 %
Project: 20 %
Participation: 20 %
Percentage of Individual Work:
Course Offered in Other Programs:
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;
Optional Text: Rob, Coronel, Database systems Design, Implementation, and Management, Thompson Publishing. Latest edition.
Optional - N/A, Required text/materials: to be determined.