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 will 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.

It is recommended that you complete CCTB200 Microsoft SQL Level II, equivalent courses, or have practical experience prior to enrolling.

Upcoming Offerings

This course is part of these programs or course groups:

Database Administrator


Additional Resources

Stay up to date with NAIT Corporate & Continuing Education! Share your name and email to be added to our mailing list.

Sign up

Delivery Methods

  • Face to Face: Where: In-person meetings. When: Course is scheduled at a specific time for students to attend. Face-to-face instruction at all class meetings. Location may be on campus or at a worksite.
  • Blended: Where: Mixture of in-person & online components. When: Course is scheduled at a specific time for students to attend. Combination of face-to-face and online components at specific times. Some online components may be accessed online anytime.
  • Hyflex: Where: Choice to attend in-person or online meetings. When: Course is scheduled at a specific time for students to attend. For each class, students choose to attend in-person with the instructor or online at a specific time.
  • Remote Live Delivery: Where: Online with instructor. When: Course is scheduled at a specific time for students to attend. Instruction is delivered at set times online. Students do not come to campus.
  • Remote On-Demand Delivery: Where: Online anytime. When: No set class meetings. Coursework is accessed on-demand and online. While there are no set class meetings, there may be set due dates and deadlines for some activities. Students may interact with peers through virtual tools.
  • Remote Independent: Where: Online anytime. When: No set class meetings. Coursework is accessed on-demand and online, with no instructor support. While students choose when to do coursework, there may be set due dates and deadlines. 
  • Work Placement: Where: In-person meetings. When: Work is scheduled at a specific time for students to attend. Onsite work integrated learning. Location at a worksite.
Shopping Cart Quick View
Open Shopping Cart