Course Description

Unlock diverse career paths in data management. A functional understanding of transactional databases opens doors to diverse career opportunities, enabling you to excel in various industries related to data management, analytics and database administration.

This 36-hour virtual instructor-led course thoroughly introduces transactional databases, covering key elements and processes. It explores relational database terminology and design objectives, teaching basic T-SQL queries on Microsoft SQL Server and delving into Azure Cloud Data Solutions. You'll learn to build Azure SQL databases, perform functions in both relational and non-relational databases, and identify common data workloads. Upon completing the course, you'll confidently describe relational database concepts, construct Azure SQL databases, and proficiently manage diverse data tasks within the Azure environment.

Note: Registration for this course closes two days before the course starts.

Learner Outcomes

Upon successful completion of this course, you'll be able to:

  • describe the terminology and design objectives of relational databases
  • build Azure SQL database using provided files
  • perform various functions within a relational database in Azure
  • perform various functions within a non-relational database in Azure.

You’ll demonstrate your skill and knowledge acquisition by completing coursework and both during and after class time.

To request a course outline, contact ConEdAdvising@sait.ca.

Earn a SAIT micro-credential

This course qualifies for the SAITMicro badge. Students who successfully complete this course with a final grade of A- or higher will earn a micro-credential and receive a shareable digital badge.
Learn more.


Prior data analysis or database administration experience is not required.


There are no prerequisites for this course.

Applies Towards the Following Certificates

Enrol Now - Select a section to enrol in
Section Title
Data Concepts
Lecture - Online Synchronous
T, Th
6:00PM to 9:00PM
Oct 15, 2024 to Nov 21, 2024
Schedule and Location
Contact Hours
Delivery Options
Course Fee(s)
Training Fee non-credit $705.00
Section Notes


This course will be delivered virtually using MS Teams or Zoom and Brightspace(D2L). Virtual sessions will be held on Tuesdays and Thursdays starting October 15, 2024 and ending November 21, 2024, from 6:00 pm - 9:00 pm.

We encourage you to use your webcam and microphone to contribute to a more collaborative learning experience.

Required Software/Technology/Textbooks/Supplies:

Included and access provided: 

  • Student version of Microsoft 365 and Brightspace(D2L) online learning platform
  • Zoom/Teams virtual communication/collaboration app

You’ll need to supply:

  • Internet access and a computer system with a functional webcam and microphone that meets minimum technical requirements to use Brightspace(D2L)
  • Required textbooks: 
    • Database Design for Mere Mortals: 25th Anniversary Edition, Michael J. Hernandez 

    Publisher ‏ : ‎Addison-Wesley Professional; 4th edition (Dec 17, 2020) 
    Language ‏ : ‎English 
    ISBN-10 ‏ : ‎0136788041 
    ISBN-13 ‏ : ‎978-0136788041 

    • T-SQL Fundamentals, Itzik Ben-Gan 

    Publisher ‏ : Microsoft Press; 3rd edition (Aug 3, 2016)  
    Language ‏ : ‎English  
    ISBN-10 ‏ : ‎9781509302000
    ISBN-13 ‏ : ‎978-1509302000 

On Course Start Date:

  • Ensure your computer, mic and webcam function properly.
  • Follow instructions to log in to Microsoft 365 and check your MS Outlook inbox for any course-related emails from your instructor. Click on the Brightspace (D2L) icon/link to access online course content and further instructions to get started. You’ll be provided with instructions in your course on which app, Zoom or MS Teams, you’ll be using to access virtual sessions.

If you have any questions, contact ConEdAdvising@sait.ca.

Required fields are indicated by .