Key Information
SQL Bootcamp
SQL Level 2
SQL Server Bootcamp
$975 18 Hours
$350 6.75 Hours
$975 20 Hours
Learn More
Learn More
Learn More
Download Syllabus
Download Syllabus
Overview
Learn to extract info from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You’ll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL
Build on your knowledge of SQL fundamentals and enhance your skills to filter, group, and analyze data in this intermediate SQL course.
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results so you can turn data into actionable insights.
Prerequisite
Open to Beginners
SQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, and wildcards), and inner/outer JOINs.
Open to Beginners
Location
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Schedule
Next start date: December 5–21, Mondays & Wednesdays, 6–9pm
Other scheduling options Weeknights or weekdays
View full schedule
Next start date: December 14, Wednesday, 9:30–5:15pm
Other scheduling options Weekdays, weeknights, or weekends
View full schedule
Next start date: Dec 13–15, Weekdays
Other scheduling options: Weekdays, weeknights, or weekends
View full schedule
Certification
Receive a Certificate of Completion
Receive a Certificate of Completion
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Courses Included (Certificates & packages only)
N/A
N/A
  • 6.75 HoursSQL Level 1
  • 6.75 HoursSQL Level 2
  • 6.75 HoursSQL Level 3
Payment Plan See our payment plan FAQ for more details
Financing See our Leif FAQ for more details
Target Audience
  • Leaders interested in making better data-driven decisions and “knowing the numbers”
  • Analysts looking to deepen their skillset beyond Excel and Tableau
  • Developers who want to be more comfortable working with databases
Anyone
Anyone
What You’ll Learn
  • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app)
  • Write SQL queries to retrieve data from tables in a database
  • Combine information from multiple tables with JOIN statements
  • Filter data, group it, and sort it to extract the specific info you need
  • Advanced techniques like Subqueries, String Functions, and IF‑Else logic with CASE
  • When to use Views and User-Defined Functions instead of directly querying tables
  • Group data and perform common statistical calculations using Aggregate Functions
  • Filter grouped data with HAVING
  • Use CAST to make a data type fit your query’s needs
  • Work with dates and time
  • Advanced Joins such as Self Join and Union
  • Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)
  • Write SQL queries to retrieve data from tables in a database
  • Combine information from multiple tables with JOIN statements
  • Filter data, group it, and sort it to extract the specific info you need
  • Advanced techniques like Subqueries, String Functions, IF‑Else logic with CASE, and Variables
  • When to use Views, User-Defined Functions, and Stored Procedures instead of directly querying tables