- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
This hands-on course was replaced by COMP 3682 Microsoft Server Administration as of April 2025. Students who have successfully completed COMP 1630 and already have an understanding data modeling, relational database design and SQL, will focus on designing and administering MS SQL Server databases. In-depth exercises and labs focus on creating, deploying, optimizing, and maintaining MS SQL Server databases from an administrator's perspective. COMP 3680 provides a more detailed examination of database architecture, installing and configuring MS SQL Server. There will be discussions of physical database design and creation, Role Based Access Control (RBAC) plus best practise in maintenance and security for high availability database solutions. COMP 3680 topics include how to plan and implement Group and local Security Policies; industry standard strategies and planning for server back-ups, troubleshooting, monitoring, and managing a server with Microsoft's built-in tools. Server security and recovery plans with compliance strategies for a Microsoft Server will be discussed. There is also a related course that would benefit server administrators; COMP 3771–MS PowerShell Scripting. Upon completion, successful students will be able to create and manage MS SQL databases and user accounts, use built-in troubleshooting tools, monitor performance. Please note: COMP 3682 has replaced three smaller courses COMP 3677, COMP 3680 and COMP 3681.
Domestic fees
$379.64
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Install and Configure MS SQL Server.
- Use MS SQL Server graphical and command line tools.
- Explain the role of MS SQL Server in application design and the enterprise.
- Describe different implementations of MS SQL Server on Microsoft Azure.
- Explain physical database design considerations.
- Explain mirroring, log shipping, high availability groups and replication.
- Create and manage databases, transaction logs and database snapshots.
- Implement security for logins, databases and objects.
- Plan, create and perform backup and recovery strategies for high availability.
- Explain MS SQL Server Best Practices for: Data Classification and Security, Optimizing Query Performance, Monitoring SQL Server performance, Task Automation and Troubleshooting.
Effective as of Spring/Summer 2024
Course Offerings
Winter 2025
Below is one offering of COMP 3680 for the Winter 2025 term.
CRN 92509
Dates
Feb 27 - Apr 03 In Progress
- CRN 92509
- $379.64 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Feb 27 - Apr 03 | Thu | 18:00 - 21:00 | Online |
Duration
6 weeks
Instructor
Edison Sie
Course outline
Important information
- Internet delivery format.
- Departmental approval needed
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- Please email cstflex@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. This is a web-based course with synchronous class times. Course is 18 hours synchronous online classes. You should prepare to spend 3 hours on homework for every 1 hour of class time. Depending on the student, this course may require an average total time commitment of 12+ hours per week; 3 hours of synchronous class time and 9+ hours per week for homework. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Students will be provided with a limited amount of server and data access outside of class each week for the course duration. Late registration is not permitted.
Status
In Progress
This course offering is in progress. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.
Programs and courses are subject to change without notice.