- 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 along with COMP 3677 has replaced COMP 4677. COMP 3680 is the second part of series in Microsoft Server Administration courses. 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. This hands-on course is MS SQL Server 2019 specific, so those who have taken MS SQL 2012/2016 may benefit to better plan migration to SQL Server versions and the Microsoft Azure environment. There will be a brief review of COMP 3677, before in-depth exercises and labs that 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 in-depth discussions of physical database design and creation, Role Based Access Control (RBAC) plus best practise in maintenance and security for high availability database solutions. Please Note: Attendance, participation in class and the BCIT Learning Hub are required. Students may have an average total time commitment of 12+ total hours each week; 3 hours of synchronous class time and 9+ hours of homework, reading and research each week. 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. COMP 3677 and COMP 3680 are required in the Applied Database Administration and Design (ADAD) Associate Certificate, and electives in the Computer Systems Technology (CST FLEX) Diploma. Those students with a networking background may also want to consider COMP 3681 Microsoft Windows Server Administration. 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.
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
Related Programs
Microsoft SQL Server Administration Part 2 (COMP 3680) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs with a co-op option.
School of Computing and Academic Studies
- Applied Database Administration and Design
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
Course Offerings
Fall 2024
Below is one offering of COMP 3680 for the Fall 2024 term.
CRN 51089
Dates
Thu Oct 31 - Thu Dec 05
- 6 weeks
- CRN 51089
- Domestic fees $379.64
Status
In Progress and Full
This course offering is in progress and full. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Oct 31 - Dec 05 | Thu | 18:00 - 21:00 | Online |
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.
Winter 2025
Below is one offering of COMP 3680 for the Winter 2025 term.
CRN 92509
Dates
Thu Feb 27 - Thu Apr 03
- 6 weeks
- CRN 92509
- Domestic fees $379.64
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Feb 27 - Apr 03 | Thu | 18:00 - 21:00 | Online |
Instructor
Edison Sie
Course outline
Course outline TBD — see Learning Outcomes in the interim.
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.
Programs and courses are subject to change without notice.