Continuing Education

CCTB100 - Microsoft SQL Server Level I

Course Code

A unique identifier used at NAIT for this specific course.

Campus

The location where your NAIT courses will be held.

Course Overview

Gain hands-on experience working with the world's most widely used database management system, Microsoft's SQL Server. Upon successful completion of this course you will be able to perform administration tasks in a Microsoft SQL Server.

Microsoft SQL Server is used to store and retrieve data requested by other applications. With the skills gained in this course, you will be able to install, configure, and maintain an SQL Server instance, identify key components of the SQL Server, create databases and tables, and complete administration tasks with the SQL Server Management Studio. You will also be able to import and export data in flat-file format, work with scripts, backup and restore SQL Server databases, and use Microsoft Access to interact with an SQL database.

It is recommended that you be familiar with the administration of a Windows server environment. Experience with other database systems is beneficial but not required.

Upcoming Offerings

This course is part of these programs or course groups:

Business Intelligence & Data Engineering

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