Course Overview
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.
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
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:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Applied Data Analytics
Certificate Part-time
- Applied Database Administration and Design
Associate Certificate Part-time
- Computer Systems
Diploma Part-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.