Course Overview
This hands-on course follows on from COMP 1630 or COMP 2629. Students who understand database design and how to configure a MS Windows PC are introduced to the basic tasks that an Administrator performs to manage Microsoft cloud server products, specifically MS SQL Server and MS Windows Server. COMP 3682 details the different roles and types of servers used on premises and the cloud server environment with Microsoft Azure. Labs and exercises focus on Microsoft Server Administration to create and manage users, groups, shares, and file permissions. Role Based Access Control (RBAC) best practices will be used. Students will install, configure, and architect both a Microsoft Windows Server and a Microsoft SQL Server in a Cloud environment. Topics include how to deploy and manage Active Directory Domain Services (AD DS), plan and implement Group and local Security Policies; industry standard strategies for managing storage, planning for server back-ups, troubleshooting, monitoring, and managing a server with built-in tools. Server security and recovery plans with compliance strategies for a Microsoft Server on the cloud will be discussed. COMP 3682 is a required course in the Applied Database Administration and Design (ADAD), Applied Network Administration and Design (ANAD) Associate Certificates, and is an elective in the Computer Systems Technology (CST FLEX) Diploma. Please Note: The Spring/Summer 2026 section is compressed over 6 weeks, with 2 classes per week and twice the amount of homework per week as the 12-week section. Upon completion, successful students will be able to create and manage user accounts, use built-in troubleshooting tools, monitor performance, and implement a security and recovery plan for Microsoft Window Server and Microsoft SQL Server in a cloud environment.
Credits
4.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Describe the different roles and types of a server.
- Define different server environments on the cloud with Microsoft Azure.
- Install, configure, and architect a Server in an On-Premises and Cloud environment.
- Describe physical database design considerations for MS SQL Server.
- Explain mirroring, log shipping, high availability groups and replication.
- Create and manage MS SQL databases, transaction logs and database snapshots.
- Implement security for logins, databases, and objects for MS SQL Server.
- Deploy and manage Active Directory Domain Services (AD DS) in both on-premises and Microsoft Azure cloud environments, including identity integration; create and manage users, groups, shares, and file permissions with Role Based Access Control (RBAC) in a Microsoft Server environment.
- Plan and implement Group Policies and Local Security Policies.
- Plan and implement the following on MS Windows Server: Dynamic Host Configuration Protocol (DHCP) services; Remote Desktop Services (RDS) and Virtual Private Networks (VPN); Print Servers; Roaming Profiles.
- Manage storage and file services, including planning and performing backup and recovery strategies with built-in Microsoft Server tools for high availability.
- Manage Microsoft Server troubleshooting and monitoring strategy with built-in tools across on-premises and Microsoft Azure cloud environments, applying security best practices for cloud server environments.
- Use best practices and industry standards for Microsoft Server security and governance.
Effective as of Spring/Summer 2026
Related Programs
Microsoft Cloud Server Administration (COMP 3682) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Database Administration and Design
Associate Certificate Part-time
- Applied Network Administration and Design
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.