Microsoft SQL Server Administration COMP 4677

Computer Systems Course

Notices

Registration news

Registration is currently open for the Fall 2023 term.

The sneak preview for the Winter 2024 term starts Fri October 20, 2023 at 8:30 am (PDT).

Students may register for Winter 2024 term courses online or by phone starting Wed October 25, 2023 at 9:00 am (PDT).

Additional Information

Please check the classroom locations listing on the first day of your course.
Find out if you qualify for financial aid.
BCIT’s English Language Proficiency Standard for Flexible Learning (Part-time Studies) is English 12.
Find out about payment options at BCIT.

International Fees: International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.

Course details

Following on from COMP 1630, students who already understand data modeling, relational database design and SQL are provided with an in-depth understanding of designing MS SQL Server 2016 databases. This hand-on course is SQL Server 2016 specific, so those who have taken MS SQL 2000/2005/2008/2012 will also benefit and be able to better plan migration to SQL Server 2016. Topics include: architecture, installing and configuring SQL Server, physical database design, creation, maintenance, security, and high availability solutions. Exercises and labs focus on creating, deploying, optimizing and maintaining enterprise SQL Server 2016 databases to help students obtain an understanding from a database administrator perspective. Successful participants will learn to install and configure SQL Server 2016, to plan and set policies for system access, end-users, back-ups, disaster recovery, and to troubleshoot and to manage database security.

Prerequisite(s)

60% in COMP 1630

Credits

4.0

Not offered this term: This course is not offered this term. Please check back next term or subscribe to receive notifications of future course offerings and other opportunities to learn more about this course and related programs.

Learning Outcomes

Upon successful completion of this course, the student will be able to:

Use MS SQL Server 2016 graphical and command line tools.
Install and Configure MS SQL Server 2016.
Enumerate MS SQL Server 2016 new features.
Explain physical database design considerations.
Create and perform backup and recovery strategies.
Use high availability and disaster recovery options in MS SQL Server.
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.
Explore performance tuning strategies.
Enumerate steps in troubleshooting database problems.

Effective as of Fall 2017

Related Programs

Microsoft SQL Server Administration (COMP 4677) is offered as a part of the following programs:

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.

Name * Required
Email * Required
Phone * Required
Questions or Comments * Required
Confirm you are not a robot
Privacy Notice: The information you provide will be used to respond to your request for BCIT program information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5G 3H2, email: privacy@bcit.ca.
Email
This field is for validation purposes and should be left unchanged.

Programs and courses are subject to change without notice.