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.
ICT 214 - Database Design
For current information and details on transfer credit for this and other courses, check the BC Transfer web site at http://bctransferguide.ca/.
Upon successful completion of this course, students will be able to:
Required Materials/Texts: see Course Textbooks page.
Percentage grades will be converted to letter grades at the home institution.
|1||Review Relational Design|
|2||SQL Advanced Queries|
|4||DDL - SQL Data Integrity, Constraints and Rules using scripts|
|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|
|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.|