Skip to main content

Microsoft SQL Server Administration COMP 4677

Computer Systems Course

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. Please note: ​COMP 4677 will be offered for the last time in the Spring 2023 term. ​

Prerequisite(s)

Credits

4.0

Cost

$706.54

Course offerings

Winter 2023

Below is one offering of COMP 4677 for the Winter 2023 term.

CRN 76435

Duration

Tue Jan 10 - Tue Mar 28 (12 weeks)

  • 12 weeks
  • CRN 76435
  • $706.54
Class meeting times
Dates Days Times Locations
Jan 10 - Mar 28 Tue 18:00 - 21:00 Online
Jan 10 - Mar 28 N/A N/A Online
Instructor

Marin Kostadinovic

Course outline

View

Cost

$706.54

Important information
  1. Internet delivery format.
  2. Departmental approval needed
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  4. Please email cstpts@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 48 hours - 36 hours synchronous online classes and 12 hours asynchronous activities/labs. This class meets once per week for 3 hours online and requires an additional 1 hour per week asynchronously. 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.

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

  1. Applied Database Administration and Design
    Associate Certificate Part-time
  2. Computer Systems
    Diploma Part-time

Contact Us

If you have a question or comment about this course, please complete and submit the form below.

  • 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.
  • This field is for validation purposes and should be left unchanged.

Subscribe

Interested in being notified about future offerings of Microsoft SQL Server Administration (COMP 4677)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course 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 V5A 3H2, email: privacy@bcit.ca.