Loading...

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.

Notes

Prior data analysis or database administration experience is not required.

Prerequisites

There are no prerequisites for this course.

Applies Towards the Following Certificates

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

Schedule:  

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 
    https://amzn.to/3wNFEQd 

    • T-SQL Fundamentals, Itzik Ben-Gan 

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

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 .