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 and implementing MS SQL 2016 Server databases advanced T-SQL and scripting methods. There is an overview of BI tools (MS SQL Server Reporting Services, MS SQL Server Integration Services) and comparisons between different editions of MS SQL Server. Topics include: architecture, new SQL 2016 components, T-SQL review, new T-SQL constructs for SQL Server 2016, programmable objects, security for the database developer and performance tuning procedures. Exercises and labs help students obtain a thorough understanding of Microsoft SQL Server 2016 from a database developer perspective, with a focus on how to create views, stored procedures and triggers. Successful participants will be able use procedural code in TSQL and .NET to develop and manage the data layer for software applications. Please note: COMP 4678 will be offered in the winter (January) and fall (September) terms.
COMP 1630 or equivalent knowledge.
Below is one offering of this course for the Fall 2020 term.
Thu Sep 17 - Thu Dec 03 12 Weeks
|Sep 17 - Dec 03||Thu||18:00 - 21:00||DTC Online Delivery|
|Sep 17 - Dec 03||Online Online Delivery|
TBD – see Learning Outcomes in the interim
Effective as of Fall 2017
COMP 4678 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 Fall 2020 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-761 Querying Data W. Transact-Sql|
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 4678 - Microsoft SQL Server 2016 Development? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.