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

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

Start/End Date

Jan 13, 2021 - Apr 13, 2021

Hours

24

Price

$325.00 CAD

Start/End Date

Feb 10, 2021 - May 10, 2021

Hours

24

Price

$325.00 CAD

Start/End Date

Mar 10, 2021 - Jun 10, 2021

Hours

24

Price

$325.00 CAD

Start/End Date

Apr 14, 2021 - Jul 14, 2021

Hours

24

Price

$325.00 CAD

  • If you are currently studying in a post-secondary program at BVC, please register for your courses via mybvc to ensure your enrolments and fees are processed appropriately.
  • Cart total based on domestic tuition rates. For information about International Tuition rates please see Fee Information
  • If you anticipate applying for a student loan, your payment will be refunded to you based on your loan award once your funding has been received by BVC.

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