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
$677.00
Below is one offering of this course for the Winter 2019 term.
Tue Jan 08 - Tue Mar 26 12 Weeks
| Dates | Days | Times | Locations |
| Jan 08 - Mar 26 | Tue | 18:00 - 21:00 | DTC Rm. 370 |
| Jan 08 - Mar 26 | Online |
Marin Kostadinovic
$677.00
This course offering is in progress. Please check back next term, 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 2019 term.
Tue Apr 16 - Tue Jul 02 12 Weeks
| Dates | Days | Times | Locations |
| Apr 16 - Jul 02 | Tue | 18:00 - 21:00 | DTC Rm. 370 |
| Apr 16 - Jul 02 | Online |
Marin Kostadinovic
TBD – see Learning Outcomes in the interim
$677.00
This course offering is full. Please check back next term, subscribe to receive email updates or contact us with your comments or questions.
Full
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 2019 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 | |
Books for Spring/Summer 2019 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 | |
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.