Key Information
SQL Bootcamp
SQL Level 2
SQL Server Bootcamp
$975 18 Hours
$325 8 Hours
$915 24 Hours
Learn More
Learn More
Learn More
Download Syllabus
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: July 18–20, Monday to Wednesday, 10–5pm
Other scheduling options Weekdays, weeknights, or weekends
View full schedule
Next start date: July 19 & 21, Tuesday & Thursday, 6–9:20pm
Other scheduling options Weeknights, weekends, or weekdays
View full schedule
Next start date: Jul 12–28, Weeknights
Other scheduling options: Weeknights, weekends, or weekdays
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
  • 8 HoursSQL Level 1
  • 8 HoursSQL Level 2
  • 8 HoursSQL Level 3
Discounts See our discounts policies for more details
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
Payment Plan See our payment plan FAQ for more details
12-Month Financing See our Climb Credit 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 Joins and Unions
  • 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