Skip to main content
International Fees

International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.

Course details

​This hands-on course has replaced COMP 4678 as of September 2023 and follows on from COMP 1630 and COMP 2364. Students who already understand relational database design, SQL programming and MS Excel are introduced SQL Server Development. SQL Server Development begins with a brief overview cloud computing using the MS Azure ecosystem and MS SQL Server tools. There also will be a brief review of the relational database modelling, Entity Relationship Design (ERD) and normalization topics from COMP 1630. COMP 3678 topics include SQL server data types, the use of Data Definition Language (DDL), and how to write MS SQL queries using Data Manipulation Language (DML). Labs and exercises show how to use SQL Server tools and techniques to optimize SQL queries Transact-SQL (T-SQL) runtime errors. Students will use T-SQL to develop and manage the data layer for software applications, working with relational and portable data from multiple sources in MS SQL Server. Participants will see the basic differences between on premises Database Management Systems (DBMS) and a cloud Database setup. Tasks to Extract, Transform, and Load (ETL) data, MS SQL Server Database operations will also be discussed. ​COMP 3678 is an elective in the Applied Database Administration and Design (ADAD) Associate Certificate, the Applied Data Analytics Certificate (ADAC) and Computer Systems Technology (CST FLEX) Diploma. Successful participants will be able to: manage data from multiple sources, create scripts and database objects using T-SQL. This course will be offered starting April 2024.​

Prerequisite(s)

Credits

4.0

Domestic fees

$582.30 - $623.16 See individual course offerings below for actual costs.

Course offerings

Winter 2024

Below is one offering of COMP 3678 for the Winter 2024 term.

CRN 91642

Duration

Sat Jan 13 - Sat Apr 13 (12 weeks)

  • 12 weeks
  • CRN 91642
  • Domestic fees $623.16
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Jan 13 - Apr 13 Sat 13:00 - 16:00 Burnaby
Jan 13 - Apr 13 N/A N/A Online
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$623.16

Important information
  1. Departmental approval needed
  2. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  3. Please email cstflex@bcit.ca for Departmental approval. Include your Student number (A0#) and COMP__ and preferred CRN __ and Program Declaration____. Course is 48 hours - 36 hours on campus and 12 hours asynchronous activities/labs. The class meets once per week for 3 hours on campus and requires an additional 1 hour per week asynchronously. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Most students should also plan for 9+ hours reading and homework each week, for a total commitment of 13 hours per week. With class time, this course is a total time commitment of 150 hours. Some students may need to spend more time on homework and assignments. This is a BYOD (bring your own device) course, students must provide their own current model laptop with an i5 or higher equivalent processor, 8 GB of RAM minimum, and 256 GB minimum storage. High-speed internet access is needed for online sections and for homework. Please note: BCIT does not provide technical support for student's hardware or operating systems. Late registration is not permitted. No class February 17 (Family Day) and March 30 (Easter).
Status

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings, subscribe to receive email updates or contact us with your comments or questions.

Spring/Summer 2024

Below is one offering of COMP 3678 for the Spring/Summer 2024 term.

CRN 69292

Duration

Sat Apr 27 - Sat Jul 27 (12 weeks)

  • 12 weeks
  • CRN 69292
  • Domestic fees $582.30
    International fees are typically three times the amount of domestic fees.
Class meeting times
Dates Days Times Locations
Apr 27 - Jul 27 Sat 13:00 - 16:00 Online
Apr 27 - Jul 27 N/A N/A Online
Instructor

Alaa Alakari

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Domestic fees

$582.30

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. International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
  5. Please email cstflex@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. Participation online via the BCIT Learning Hub and attendance are mandatory during scheduled class hours plus online activities for a minimum of 4 hours per week. Most students should also plan for 9+ hours reading and homework each week, for a total commitment of 13 hours per week. With class time, this course is a total time commitment of 150 hours. Some students may need to spend more time on homework and assignments. Late registration is not permitted. No class May 18 (Victoria Day) and June 29 (Canada Day).
Status

Learning Outcomes

Upon successful completion of this course, the student will be able to:

  • Explain the features, architecture, and security fundamentals of MS SQL Server.
  • Detail various SQL server data types (Main data types, Complex data types, Object, Geospatial, etc.
  • Use Data Definition Language (DDL) to create and alter database tables and schema.
  • Write MS SQL queries using Data Manipulation Language (DML) to retrieve, filter, sort, and aggregate data from SQL Server databases.
  • Employ SQL Server tools and techniques to optimize SQL queries (Indexes, Filtering, Joins).
  • Write procedural code in Transact-SQL (T-SQL) to develop and manage the data layer for software applications.
  • Demonstrate various tools and methods to track, debug, and rectify T-SQL runtime errors (@ERROR etc.).
  • Describe high-level overview of MS SQL Server Database Administration, security, backup, and restore operations
  • Detail the basic tasks needed to Extract, Transform, and Load data (ETL).
  • Use MS SQL Server tools to import and export data portable formats (XML/CSV/JSON).
  • Discuss future trends in database development including: Big Data, Data Streaming, and real time Data Analytics.

Effective as of Fall 2023

Related Programs

SQL Server Development (COMP 3678) 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 SQL Server Development (COMP 3678)? 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.