- International Fees
International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Course details
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.
Credits
1.5
Domestic fees
$379.00
Course offerings
Spring/Summer 2024
Below is one offering of COMP 3680 for the Spring/Summer 2024 term.
CRN 69520
Duration
Thu Jun 27 - Thu Aug 01 (6 weeks)
- 6 weeks
- CRN 69520
- Domestic fees $379.00International fees are typically three times the amount of domestic fees.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jun 27 - Aug 01 | Thu | 18:00 - 21:00 | Online |
Instructor
Edison Sie
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Domestic fees
$379.00
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 three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
-
This is a web-based course with synchronous class times. Course is 18 hours synchronous online classes. Participants must provide their own current model PC device with microphone and video camera. A minimum of an i5 or equivalent processor, 8 GB of RAM, 256 GB storage and high-speed internet access are required. 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
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
Contact Us
If you have a question or comment about this course, please complete and submit the form below.
Subscribe
Interested in being notified about future offerings of Microsoft SQL Server Administration Part 2 (COMP 3680)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.