Course Description

This course prepares you to take the Microsoft Technology Associate (MTA) exam: Database Fundamentals. This course introduces the fundamentals and core concepts of database development and administration, including the creation of database objects, manipulation of data, data storage, database security, backup, and recovery.

Topics:

Core database concepts
Structured Query Language (SQL)
Database objects
Stored procedures and functions
Core relational database management system concepts
Normalization and indexes
Tables and views
Database security
Data manipulation and data definition languages
Database backup and restore

Required Learning Resources:

Learning resources will be available in the course modules in Desire2Learn (D2L) on the course start date. SQL Server Express and SQL Server Management Studio will need to be installed for this course at no additional cost.

Course Offerings


Any-time Online

A course delivery mode where learning activity takes place at times and locations of the learners own choosing through the use of online communications technologies. Learners are NOT required to participate in any scheduled learning activities, but scheduled exams may be required.

Start/End Date

Sep 9, 2020 - Dec 9, 2020

Hours

24

Price

$325.00 CAD

Start/End Date

Oct 14, 2020 - Jan 14, 2021

Hours

24

Price

$325.00 CAD

Start/End Date

Nov 18, 2020 - Feb 18, 2021

Hours

24

Price

$325.00 CAD

Start/End Date

Dec 9, 2020 - Mar 9, 2021

Hours

24

Price

$325.00 CAD

Your cart is currently empty.

Browse Available Courses

We use cookies to ensure that we give you the best experience on our website. Learn more in our privacy policy