Course Overview
This hands-on course helps students progress from writing SQL queries to developing, debugging, and optimizing cloud-ready SQL Server solutions. Building on COMP 1630 and COMP 2364, participants will apply database design, SQL programming, and MS Excel skills in a modern cloud-based SQL Server development. COMP 3678 introduces cloud computing concepts in the Microsoft Azure ecosystem and the tools used to build and manage MS SQL Server solutions. Students review relational database modelling, Entity Relationship Design (ERD), and normalization, then apply these foundations to SQL Server development tasks. They work with SQL Server data types, Data Definition Language (DDL), Data Manipulation Language (DML), and T-SQL to create database structures, retrieve and transform data, and support application data layers. Labs emphasize query optimization, indexing, joins, filtering, debugging, and resolving Transact-SQL (T-SQL) runtime errors. Students use SQL Server tools and AI-assisted workflows to generate, test, troubleshoot, document, and refine practical database solutions. Participants develop scripts and database objects that support application development, reporting, and data management using relational and portable data from multiple sources. They compare on-premises and cloud database environments and examine SQL Server administration, security, backup, restore, operations, and Extract, Transform, and Load (ETL) processes. COMP 3678 is an elective in the Applied Database Administration and Design (ADAD) Associate Certificate, Applied Data Analytics Certificate (ADAC), and Computer Systems Technology (CST FLEX) Diploma. Upon completion, successful students will be able to manage data from multiple sources, create T-SQL scripts and database objects, and use AI-assisted workflows to develop, debug, and optimize SQL Server tasks. This course is offered in the Winter (January) and Spring/Summer (May) terms.
Credits
4.0
Domestic fees
$606.84
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Explain SQL Server features, architecture, security, and administration in on-premises and cloud environments.
- Select appropriate SQL Server data types, including standard, complex, object, and geospatial types.
- Use DDL and DML to create, manage, retrieve, filter, aggregate, and transform SQL Server data.
- Optimize and debug queries using indexing, joins, execution analysis, SQL Server tools, and AI-assisted workflows.
- Develop procedural T-SQL code for database logic, data processing, and application data layers.
- Design ETL processes to import, transform, export, and manage data across sources and formats.
- Apply AI-assisted workflows to generate, test, document, debug, and tune SQL Server tasks.
Effective as of Winter 2027
Related Programs
SQL Server Cloud Development with AI (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
Course Offerings
Winter 2027
Below is one offering of COMP 3678 for the Winter 2027 term.
CRN 91642
Dates
Jan 09 - Apr 10 Loading
- CRN 91642
- $606.84 Domestic fees
Class meeting times
Duration
12 weeks
Instructor
Alaa Alakari
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Registration requirements
Departmental approval is required to register for this course offering. You must have approval from the department to register. Students accepted into a program can register directly.
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- 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. Please Note: Attendance, participation in class and the BCIT Learning Hub are mandatory. You should prepare to spend 2-3 hours on homework for every 1 hour of class time. Depending on the student, this course may require an average total time commitment of 13-16+ hours per week; 3 hours of synchronous class, 1-hour asynchronous time plus 9-12+ hours per week for homework. Late registration is not permitted. BCIT Computing is primarily a Microsoft Windows environment. Students must provide their own current model Windows-compatible PC with microphone and video camera. i5 or higher equivalent processor, with 8 GB of RAM minimum, and 256 GB minimum storage. Highspeed internet access is needed for online sections and for homework. Mac users must have the ability to manage and support their iOS computer. They may need to create a virtual Windows environment using Parallels or VMWare Fusion. COMP instructors may not be able to assist Mac users with software compatibility issues. BCIT does not provide access to Parallels or support for students to use a Mac to run Windows. Students will be provided with a limited amount of server and data access outside of class each week for the course duration. No class February 13 (Family Day) and March 27 (Easter).
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
No approval yet? Request approval You must have approval from the department to register. Students accepted into a program can register directly.
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.