Welcome to the new NAIT.ca! We encourage you to explore the site and provide your feedback.

Continuing Education

CCTB300 - Microsoft SQL Server Level III

Course Code

A unique identifier used at NAIT for this specific course.

Campus

The location where your NAIT courses will be held.

Course Overview

Expand your marketable SQL Server skills beyond basic database knowledge by exploring SQL’s role in an enterprise solution. Uncover essential topics and techniques like upsizing a Microsoft Access Database to SQL Server, working with SQL Reporting services and Visual Studio to create and publish reports on the Web, and using Analysis Services and Visual Studio to build a data cube for multidimensional analysis. Work with Microsoft SQL Replication Services and explore high-availability using SQL Server Always On Availability Groups within a Windows Failover Cluster.

With the skills you gain in this course, you’ll be able to work with SQL Server Filegroups, table compression, partitioning and database snapshots; and collect and analyze SQL Server performance data by using Windows Performance Monitor.

Recommended: CCTB200 Microsoft SQL Level II, equivalent courses, or practical experience.

Upcoming Offerings

Filter by Terms:
Section Start/End Schedule
A01 Nov. 06 - Nov. 07, 2019 Wed, Thu
Hours Delivery Fees
14 hours Day $550
Meeting Times:
  • Nov. 6 & 7 - Wednesday, Thursday: 8:00 AM - 3:50 PM

Section Start/End Schedule
E01 Nov. 15 - Nov. 17, 2019 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $550
Meeting Times:
  • Nov. 15 - Friday: 6:00 PM - 9:50 PM
  • Nov. 16 - Saturday: 8:00 AM - 3:50 PM
  • Nov. 17 - Sunday: 8:00 AM - 11:50 AM

Section Start/End Schedule
A01 Feb. 05 - Feb. 06, 2020 Wed, Thu
Hours Delivery Fees
14 hours Day $550
Meeting Times:
  • Feb. 5 & 6 - Wednesday, Thursday: 8:00 AM - 3:50 PM

Section Start/End Schedule
E01 Mar. 27 - Mar. 29, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $550
Meeting Times:
  • Mar. 27 - Friday: 6:00 PM - 9:50 PM
  • Mar. 28 - Saturday: 8:00 AM - 3:50 PM
  • Mar. 29 - Sunday: 8:00 AM - 11:50 AM

Section Start/End Schedule
A01 May. 13 - May. 14, 2020 Wed, Thu
Hours Delivery Fees
14 hours Day $550
Meeting Times:
  • May. 13 & 14 - Wednesday, Thursday: 8:00 AM - 3:50 PM

Section Start/End Schedule
E01 Jun. 12 - Jun. 14, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $550
Meeting Times:
  • Jun. 12 - Friday: 6:00 PM - 9:50 PM
  • Jun. 13 - Saturday: 8:00 AM - 3:50 PM
  • Jun. 14 - Sunday: 8:00 AM - 11:50 AM

*Day delivery ranges between 8 AM - 5 PM.
**Evening delivery ranges between 5 PM - 10 PM.