Overview

Unlock diverse career paths in data management. A functional understanding of transactional databases enables you to excel in data management, analytics and database administration in many different industries.

This course provides a thorough introduction to transactional databases, covering key elements and processes. We explore relational database terminology and design objectives, teach basic T-SQL queries on Microsoft SQL Server and delve 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.

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 the 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 skills and knowledge by completing coursework during and after class time.

Upcoming dates

Select an available section and add it to your cart. When you're ready, proceed to check out to sign into your student account and complete your registration.

Don't have a student account? Let's set one up!

Registration for this course closes two days prior to the start date.

After you've completed this course

Upon successful completion of this non-credit course, you can self-print your unofficial completion document from your Continuing Education student account.

Micro-Credential

Aligned to current industry standards, SAIT’s micro-credentials develop practical, real-world skills and include competency-based testing. Earning a SAIT micro-credential demonstrates to employers you have the required competencies — both skills and knowledge — to get the job done.

Micro-credential Badge

Students who successfully complete this course with a final grade of A- (80%) or higher will earn a micro-credential and receive a shareable digital badge.

Costs

Textbook and reading list

You are required to purchase reading materials for this course. Visit SAIT’s Bookstore's website to purchase the following.

  • Database Design for Mere Mortals: 25th Anniversary Edition, Michael J. Hernandez | Publisher: ‎Addison-Wesley Professional; 4th edition (Dec 17, 2020) 
  • T-SQL Fundamentals, Itzik Ben-Gan | Publisher: Microsoft Press; 3rd edition (Aug 3, 2016)  

Technology

To be successful in this course, you’ll need:

A functional webcam and microphone are recommended to allow for a more collaborative learning experience.

Aldred building

Financial support

Financial opportunities are available to help pay for your course fees. Learn more about how to reduce your education or training costs with available awards, bursaries, loans and grants including the Canada Alberta Job Grant. 

Applicable certificates

This course applies to the following certificate programs:

Certification type
Certificate Certificate of Achievement

Train your team

Interested in group training opportunities for this course? Tell us about your organization's needs, and one of our training consultants will contact you within one business day.

Oki, Âba wathtech, Danit'ada, Tawnshi, Hello.

SAIT is located on the traditional territories of the Niitsitapi (Blackfoot) and the people of Treaty 7 which includes the Siksika, the Piikani, the Kainai, the Tsuut’ina and the Îyârhe Nakoda of Bearspaw, Chiniki and Goodstoney.

We are situated in an area the Blackfoot tribes traditionally called Moh’kinsstis, where the Bow River meets the Elbow River. We now call it the city of Calgary, which is also home to the Métis Nation of Alberta.