SQL Server Bootcamp (Self-Paced)

Self-paced online training with expert support 3 modules

In this self-paced SQL Server Bootcamp, you'll learn how to extract valuable insights from databases by writing SQL queries, filtering data, and joining tables. This comprehensive course covers SQL fundamentals and shows you how to apply these skills to different database systems.

$975 18 clock hours Live Support Start anytime

This course includes

  • 18 hours of project-based training from experts
  • Software Access
  • Answers from real instructors
  • Proprietary workbooks included
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion

In this self-paced SQL Server Bootcamp, you'll learn how to turn raw data into valuable insights by writing SQL queries. Starting with the basics of viewing tables, columns, and rows, you'll progress to filtering, grouping, and extracting the specific data you need. You'll also learn how to combine information from multiple tables using JOIN statements, and explore more advanced techniques like aggregate functions, subqueries, and working with parameters in functions, as well as implementing stored procedures.

This course provides hands-on practice using Microsoft SQL Server and the free SQL Server Management Studio (SSMS) app to explore databases and run queries. While focused on SQL Server, the concepts you’ll learn are transferable to other SQL variations like PostgreSQL, MySQL, and Microsoft Access, with only minor syntax differences. Combining our Level 1, 2, and 3 SQL classes into a single comprehensive bootcamp, this course is perfect for anyone looking to work with data in fields like business analysis, data science, and web development, where SQL skills are essential for making data-driven decisions.

Read more

Courses in this Package

This is the recommended order, but some courses may be taken in a different order. See the FAQ for more details.

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

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