On this page:
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.
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 course, you'll be able to self-print a proof of 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.
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:
- Access to your own computer or laptop with standard hardware/software requirements.
- Internet access
A functional webcam and microphone are recommended to allow for a more collaborative learning experience.
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 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.