# SQL Server Certification Program

Canonical URL: <https://www.creativelive.com/classes/sql-server-certification-program>

## Overview

This course provides comprehensive training in SQL Server, with the goal of helping students earn their certification upon completing the program. The curriculum covers basic, intermediate, and advanced SQL techniques. Students begin by learning core database concepts and the differences between major types of SQL, as well as their ideal use cases.

Intermediate and advanced training covers analysis techniques, including joins, data types, aggregate functions, and date and time operations to uncover deeper insights and organize complex datasets. Students will learn to write sophisticated queries and apply techniques like subqueries, CASE expressions, views, functions, and stored procedures. Together, these are key skills for roles in data analysis, data science, and database management.

This course is designed to ensure that students, regardless of their skill level, are prepared to work with SQL Server in a professional capacity upon completion. Each student will receive a certificate of completion upon graduation and will have the opportunity to work alongside certified trainers and experts as part of the live course structure.

## What you'll learn

- Understand core database concepts, including tables, rows, columns, and different types of SQL
- Explore data types, comparison operators, and case sensitivity to refine queries with greater control
- Perform calculations with aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Implement conditional logic with CASE and IIF statements to dynamically transform query results and manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and others
- Build and query views, user-defined functions, and stored procedures to modularize your SQL code

## Curriculum
1. **SQL Level 1**
2. **SQL Level 2**
3. **SQL Level 3**

## Schedule
- Jul 27, 2026 – Jul 29, 2026 — Live Online
- Sep 22, 2026 – Sep 24, 2026 — Live Online
- Nov 2, 2026 – Nov 4, 2026 — Live Online

## Pricing

**Tuition:** $1699