# SQL Server Certification (Self-Paced)

Canonical URL: <https://training.sdfm.org/courses/sql-server-certification-self-paced>

## Overview

Build your SQL Server skills at your own pace with this comprehensive self-paced course, designed to prepare you for SQL Server certification. Start with foundational concepts, including core database structures and the differences between SQL types, then progress through intermediate and advanced techniques to gain a solid understanding of querying and database management.

As you advance, you’ll master joins, data types, aggregate functions, and date/time operations to analyze and organize complex datasets. Learn to write sophisticated queries using subqueries, CASE expressions, views, functions, and stored procedures. By the end of the course, you’ll have the skills needed for roles in data analysis, data science, and database management, with a certificate of completion to showcase your expertise.

## What you'll learn

- Understand fundamental database concepts, including tables, rows, columns, and various SQL types
- Explore data types, comparison operators, and case sensitivity to write precise, controlled queries
- Use aggregate functions like SUM, COUNT, AVG, MAX, and MIN to summarize and analyze data
- Apply date functions to extract, format, and compare dates for time-based analysis
- Implement conditional logic with CASE and IIF statements and manipulate text using string functions such as SUBSTRING, CHARINDEX, and UPPER
- Create and query views, user-defined functions, and stored procedures to modularize and streamline your SQL code

## Curriculum
1. **SQL Level I (Self-Paced)**
2. **SQL Level II (Self-Paced)**
3. **SQL Level III (Self-Paced)**

## Instructors

### Bruce Gay — Instructor

Bruce is an engaging trainers and program manager who brings 25+ years practical experience to deliver effective and experiential training to students. Able to engage adult learners with a range of backgrounds and professional experiences. Successful at building effective stakeholder relationships and coordinating multi-disciplinary teams for solution delivery.

Bruce has over 25 years of project and program management experience across multiple industries. He has a Masters degree from The George Washington University and a B.A. from the University of North Carolina Chapel Hill. 

Bruce currently runs his own freelance training and consulting business, helping project managers and team leaders improve their business skills, become better leaders, and achieve professional greatness. 

Bruce is a well-received speaker in the areas of design thinking, project management, cross-team collaboration, and AI tools for projects, and has presented at regional and international conferences.

## Pricing

**Tuition:** $1699