SQL Server Certification (Self-Paced)

Self-paced online training with expert support 3 modules

Advance your SQL Server skills from beginner to expert. Learn database management, querying, and data analysis techniques through practical instruction from certified professionals.

$1,699 24 clock hours Live Support Start anytime

This course includes

  • 24 hours of project-based training from experts
  • Software Access
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion

This course is self-paced. For live online or in-person instruction, take the SQL Server Certification Program.

This comprehensive SQL Server course is designed to prepare students for professional certification while building a strong foundation in database management and data analysis. The curriculum covers basic, intermediate, and advanced SQL techniques, beginning with core database concepts and the distinctions between major SQL types and their ideal use cases.

As students progress, they’ll explore advanced analysis methods such as working with joins, data types, aggregate functions, and date/time operations to extract meaningful insights from complex datasets. The course also covers writing sophisticated queries and using advanced features such as subqueries, CASE expressions, views, functions, and stored procedures.

Read more

Courses in this Package

This is the recommended order, but some courses may be taken in a different order.

Download Syllabus PDF

Unit 1 6 Hours

SQL Level I (Self-Paced)
  • Understand core database concepts, including tables, rows, columns, and different types of SQL
  • Connect to databases and navigate SQL Server Management Studio using tools like Object Explorer and Query Editor
  • Write SELECT statements to retrieve data, specify columns, sort results, and remove duplicates
  • Use WHERE, AND, OR, IN, and NOT clauses to filter data and apply pattern matching with wildcard characters
  • Explore data types, comparison operators, and case sensitivity to refine queries with greater control
  • Learn to join tables using INNER JOIN and understand relational database concepts through ER diagrams and table aliases

Unit 2 6 Hours

SQL Level II (Self-Paced)

This intermediate SQL course expands your ability to analyze and manipulate data through advanced querying techniques. Learn to work with joins, data types, aggregate functions, and date/time operations to uncover deeper insights and organize complex datasets.

  • Compare INNER and OUTER JOIN types and use LEFT, RIGHT, and FULL JOINs to combine data across tables
  • Identify and work with NULL values to ensure complete and accurate data analysis
  • Use the CAST function to convert data types and make your queries more flexible 
  • 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
  • Group results using GROUP BY and filter grouped data using the HAVING clause for advanced segmentation

Unit 3 6 Hours

SQL Level III (Self-Paced)
  • Write subqueries to create layered queries using single-value, multi-value, and table-value structures
  • Use window functions with OVER and PARTITION BY to apply aggregate logic across rows without grouping
  • Implement conditional logic with CASE and IIF statements to dynamically transform query results
  • Manipulate text data using string functions like SUBSTRING, CHARINDEX, UPPER, and more
  • Apply self-joins to compare records within the same table and understand their structure and use cases
  • Build and query views, user-defined functions, and stored procedures to modularize your SQL code
Yelp Facebook LinkedIn YouTube Twitter Instagram