| Term: | Fall 2008 |
| Total Hours: | 48.0 |
| Course Credits: | 4.0 |
Students who already understand MS SQL Server 2005 Server Administration are provided with a detailed understanding of the design and implementation of enterprise scale SQL Server 2005 databases. Topics in this hands-on course is SQL Server 2005 specific, and include: architecture, new SQL 2005 components, T-SQL review, new T-SQL constructs for SQL Server 2005, programmable objects, and security for developer. There is an overview of BI tools (SQL Server Reporting Services, SQL Server Integration Services) and comparisons between different editions of SQL Server. This Development course is built on top of the prior Administration course, COMP 4677. These two courses together will help you prepare for the new Microsoft certification exams (MCTS SQL Server 2005 and MCITP DBA) and obtain a thorough understanding of MS SQL from both a developer and administrator perspective. This course also prepares for the follow-on course, COMP 4679 -MS SQL Server Reporting tools. Successful participants in this course will learn to create procedural code in T-SQL and .NET, to create views, stored procedures and triggers, to develop XML-based applications with integrated managed code and to use performance tuning procedures. Prerequisites: COMP 4677 or COMP 4663
The following statements are in accordance with BCIT Policy 5002 - Student Regulations. Please refer to
BCIT policies at:
www.bcit.ca/about/administration/policies.shtml
Attendance: In case of illness or other unavoidable cause of absence, the Student must communicate as soon as possible with his/her instructor or Program Head or Chief Instructor, indicating the reason for the absence. Prolonged illness of three or more consecutive days must have a BCIT medical certificate sent to the department, substantiating the absence. Excessive absence may result in failure or immediate withdrawal from the course or program.
Academic Misconduct: Violations of academic integrity, including dishonesty in assignments, examinations, or other academic performances are prohibited and will be handled in accordance with the 'Violations of Standards of Conduct' section of Policy 5002
Attempts: Students must successfully complete a course within a maximum of three attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts will not be eligible to graduate from their respective program. Please note some programs within the School of Health Sciences allow fewer attempts on some courses. Please check your program's web page for any additional details.
School of Computing and Academic Studies