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 in the winter (January) and spring (April) terms.
COMP 1630 or equivalent knowledge.
4.0
$704.28
Below is one offering of this course for the Winter 2021 term.
Tue Jan 12 - Tue Mar 30 12 Weeks
| Dates | Days | Times | Locations |
| Jan 12 - Mar 30 | Tue | 18:00 - 21:00 |
Online Delivery See Notes below |
| Jan 12 - Mar 30 |
Online Delivery See Notes below |
Marin Kostadinovic
$704.28
This course offering is in progress. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.
In Progress
Below is one offering of this course for the Spring/Summer 2021 term.
Tue Apr 13 - Tue Jun 29 12 Weeks
| Dates | Days | Times | Locations |
| Apr 13 - Jun 29 | Tue | 18:00 - 21:00 |
Online Delivery See Notes below |
| Apr 13 - Jun 29 |
Online Delivery See Notes below |
Marin Kostadinovic
TBD – see Learning Outcomes in the interim
$704.28
A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.
}17 seats available as of Feb 26, 2021 12:00 am (PST). Of these 17, 11 are currently reserved for domestic students only. Availability may change at any time.
Upon successful completion of this course, the student will be able to:
Effective as of Fall 2017
COMP 4677 is offered as a part of the following programs:
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Winter 2021 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
| Exam Ref 70-764 Admin Sql Database Infrastructure | |
|---|---|
| Author | Isakov |
| Publisher | Ms |
| Copyright | 2018 |
| Binding | Paperback |
| ISBN | 978-1-50930-383-0 |
| Price | $43.50 |
| Required | |
| Exam Ref 70-765 Provisioning Sql Databases | |
|---|---|
| Author | D'antoni |
| Publisher | Ms |
| Copyright | 2018 |
| Binding | Paperback |
| ISBN | 978-1-50930-381-6 |
| Price | $43.50 |
| Required | |
No information on books is currently available for Spring/Summer 2021 offerings of this course.
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 4677 - Microsoft SQL Server Administration? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.