- 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.
Credits
4.0
Domestic fees
$582.30
Course offerings
Spring/Summer 2024
Below is one offering of COMP 3678 for the Spring/Summer 2024 term.
CRN 69292
Duration
Sat May 04 - Sat Jul 27 (12 weeks)
- 12 weeks
- CRN 69292
- Domestic fees $582.30International fees are typically three times the amount of domestic fees.
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
May 04 - Jul 27 | Sat | 13:00 - 16:00 | Online |
May 04 - Jul 27 | N/A | N/A | Online |
Instructor
Alaa Alakari
Course outline
Domestic fees
$582.30
Important information
- Internet delivery format.
- Departmental approval needed
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
-
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. Participants must provide their own current model PC device with microphone and video camera. A minimum of an i5 or equivalent processor, 8 GB of RAM, 256 GB storage and high-speed internet access are required. Students will be provided with a limited amount of server and data access outside of class each week for the course duration. Late registration is not permitted. Class in session May 18. No class June 29.
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:
- 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 with a co-op option.
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
Contact Us
If you have a question or comment about this course, please complete and submit the form below.
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.
Programs and courses are subject to change without notice.