Skip to main content

Microsoft SQL Server 2016 Development COMP 4678

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 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 for the last time in the spring (April) 2023 term.​

Prerequisite(s)

Credits

4.0

Cost

$707.62

Course offerings

Spring/Summer 2023

Below is one offering of COMP 4678 for the Spring/Summer 2023 term.

CRN 68761

Duration

Wed Apr 12 - Wed Jun 28 (12 weeks)

  • 12 weeks
  • CRN 68761
  • $707.62
Class meeting times
Dates Days Times Locations
Apr 12 - Jun 28 Wed 18:00 - 21:00 Online
Apr 12 - Jun 28 N/A N/A Online
Instructor

Marin Kostadinovic

Course outline

View

Cost

$707.62

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 tools.
  • Enumerate MS SQL Server 2016 features and components.
  • Create databases, tables, indexes using T-SQL and Management Studio.
  • Describe MS SQL Server 2016 security architecture.
  • Utilize MS SQL 2016 tools and components.
  • Create and alter database table definitions using DDL.
  • Write T-SQL queries.
  • Handle Transact-SQL runtime errors.
  • Develop functions and procedures in .NET CLR.
  • Create views, stored procedures, triggers in Transact-SQL.
  • Manipulate XML data with MS SQL 2016.
  • Use MS SQL Server 2016 Geospatial data types.
  • Integrate managed code with MS SQL Server 2016.
  • Describe performance tuning procedures in MS SQL Server 2016.

Effective as of Fall 2017

Related Programs

Microsoft SQL Server 2016 Development (COMP 4678) is offered as a part of the following programs:

School of Computing and Academic Studies

  1. Applied Data Analytics
    Certificate Part-time
  2. Applied Database Administration and Design
    Associate Certificate Part-time
  3. 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 2016 Development (COMP 4678)? 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.