SQL Bootcamp (NYC or Online)
- Difficulty
- Beginner
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
Turn the information in databases into valuable insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you'll learn how to write queries to extract the specific information you need.
In this hands-on course, you'll learn PostgreSQL and the free DBeaver app to explore databases and execute SQL queries. The concepts you'll learn apply to other versions of SQL (such as Microsoft SQL Server and MySQL) with minor syntax differences. Learn how to filter and group data, combine information from multiple tables using JOIN statements, and apply advanced techniques like aggregate functions and subqueries.
Who this course is for
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
Topics included
Curriculum
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 the database
- Combine information from multiple tables using JOIN statements
- Filter data, group it, and sort it to extract the specific information you need
- Master advanced techniques, including subqueries, string functions, and IF‑Else logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
Course syllabus
Foundations of SQL & Databases
SQL Fundamental Concepts
- What is SQL & why is it used?
- Flavors of SQL: Postgres vs SQL Server, etc.
- Database Tables, Rows, & Columns
- Using ER (Entity Relationship) Diagrams to visual what’s in a database
Exploring Databases & Writing SQL Statements (using the free DBeaver app)
- Connecting to a Database
- Database Navigator
- SQL Query Editor
- Using Code Hints
- Viewing the Results of your SQL query
- Setting Preferences
Writing SQL Queries
Writing SELECT Statements
- Syntax of a SELECT statement
- Selecting all columns or specific columns from a table
- Limiting the number of results using LIMIT
- Ordering the results using ORDER BY
- Returning only DISTINCT records (eliminating duplicates)
Filtering Results
- Data Types (Strings vs Numbers)
- Comparison Operators: equal to, greater or less than, not equal to, etc.
- Filtering results using WHERE, AND, OR, IN, and NOT
- Pattern Matching: Wildcard Filters
- Case Sensitivity
Using Joins to Combine Data from Multiple Tables
Understanding Table Relationships
- What are Primary vs Primary Keys
- Database Relations: One-to-One, One-to-Many, & Many-to-Many
Inner Joins
- The difference between Inner & Outer Joins
- Inner Joins
- Column & Table Aliases
Outer Joins & Finding NULLs
- Left Join
- Right Join
- Full Join
- Find NULL values
Manipulating, Aggregating, & Filtering Data
Using CAST to Change Data Types
- Why and how to use CAST to make a data type fit your query’s needs
Aggregate Functions
- Using Aggregate Functions to perform common statistical calculations
- Using SUM, COUNT, AVG, MAX & MIN
Working with Dates & Time
- Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
- Formatting dates, including the day of the week (Sunday, Monday, etc.)
- Calculating the difference between 2 dates
Grouping Data & Filtering Grouped Data
Grouping Data with Aggregate Functions
- Using GROUP BY to organize results into categories
- Applying Aggregate Functions to groups
Filtering Grouped Data with HAVING
- Using HAVING to filter the results of a GROUP BY
- HAVING vs WHERE
Advanced Query Techniques
Subqueries
- Subqueries: Queries within queries
- Single-Value vs Multi-Value vs Table-Value Subqueries
Aggregate Window Functions
- Using OVER and PARTITION BY to apply Aggregate Functions
Conditionals with CASE
- Adding If-Else Logic with CASE
- Simple CASE vs Searched CASE
String Functions
- Manipulating text using string functions
- Using SUBSTRING, SPLIT_PART, UPPER, etc.
Self Join
- How a Self Join is different from other types of joins
- Using a Self Join
Views & User-Defined Functions
Views
- What are Views?
- The Advantages & Disadvantages of using Views
- How to Use & Query a View
Materialized Views
- The difference between regular Views and Materialized Views
User-Defined Functions
- Using Scalar-Value (Single-Value) Functions
- Using Table-Value Functions
What's included
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 18:00 · America/New_York (EDT/EST); final session ends at 21:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
-
–
In-person or live online
Starts at 18:00 · America/New_York (EST); final session ends at 21:00 EST
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST/EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 18:00 · America/New_York (EDT); final session ends at 21:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EDT); final session ends at 17:00 EDT
-
–
In-person or live online
Starts at 10:00 · America/New_York (EST); final session ends at 17:00 EST
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $975
- Course length
- 18 hours
- Schedule
- On your schedule
Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want.
Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions, subqueries, and how to use functions with parameters.
In this hands-on course, you’ll learn PostgreSQL and the free DBeaver app to explore the database and execute SQL queries you write. The concepts you’ll learn on PostgreSQL can be applied to other flavors of SQL (such as Microsoft SQL Server, MySQL, etc.) with minor syntax differences.
Why Learn SQL?
With SQL, you can answer questions from information stored in a database (the ultimate system of storing data for most companies). As nearly every industry is becoming more data-driven, having this skill will give you a larger role in decision-making wherever you work.
SQL is vital to anyone in business or any job that involves working with data: business analysts, data analysts, data scientists, web developers, business people, and many others.
Who the self-paced course is for
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
Self-paced curriculum
What you'll learn self-paced
- 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
- Learn advanced techniques like subqueries, string functions, and IF‑ELSE logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
Self-paced syllabus
Foundations of SQL & Databases
SQL Fundamental Concepts
- What is SQL & why is it used?
- Flavors of SQL: Postgres vs SQL Server, etc.
- Database Tables, Rows, & Columns
- Using ER (Entity Relationship) Diagrams to visual what’s in a database
Exploring Databases & Writing SQL Statements (using the free DBeaver app)
- Connecting to a Database
- Database Navigator
- SQL Query Editor
- Using Code Hints
- Viewing the Results of your SQL query
- Setting Preferences
Writing SQL Queries
Writing SELECT Statements
- Syntax of a SELECT statement
- Selecting all columns or specific columns from a table
- Limiting the number of results using LIMIT
- Ordering the results using ORDER BY
- Returning only DISTINCT records (eliminating duplicates)
Filtering Results
- Data Types (Strings vs Numbers)
- Comparison Operators: equal to, greater or less than, not equal to, etc.
- Filtering results using WHERE, AND, OR, IN, and NOT
- Pattern Matching: Wildcard Filters
- Case Sensitivity
Using Joins to Combine Data from Multiple Tables
Understanding Table Relationships
- What are Primary vs Primary Keys
- Database Relations: One-to-One, One-to-Many, & Many-to-Many
Inner Joins
- The difference between Inner & Outer Joins
- Inner Joins
- Column & Table Aliases
Outer Joins & Finding NULLs
- Left Join
- Right Join
- Full Join
- Find NULL values
Manipulating, Aggregating, & Filtering Data
Using CAST to Change Data Types
- Why and how to use CAST to make a data type fit your query’s needs
Aggregate Functions
- Using Aggregate Functions to perform common statistical calculations
- Using SUM, COUNT, AVG, MAX & MIN
Working with Dates & Time
- Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.)
- Formatting dates, including the day of the week (Sunday, Monday, etc.)
- Calculating the difference between 2 dates
Grouping Data & Filtering Grouped Data
Grouping Data with Aggregate Functions
- Using GROUP BY to organize results into categories
- Applying Aggregate Functions to groups
Filtering Grouped Data with HAVING
- Using HAVING to filter the results of a GROUP BY
- HAVING vs WHERE
Advanced Query Techniques
Subqueries
- Subqueries: Queries within queries
- Single-Value vs Multi-Value vs Table-Value Subqueries
Aggregate Window Functions
- Using OVER and PARTITION BY to apply Aggregate Functions
Conditionals with CASE
- Adding If-Else Logic with CASE
- Simple CASE vs Searched CASE
String Functions
- Manipulating text using string functions
- Using SUBSTRING, SPLIT_PART, UPPER, etc.
Self Join
- How a Self Join is different from other types of joins
- Using a Self Join
Views & User-Defined Functions
Views
- What are Views?
- The Advantages & Disadvantages of using Views
- How to Use & Query a View
Materialized Views
- The difference between regular Views and Materialized Views
User-Defined Functions
- Using Scalar-Value (Single-Value) Functions
- Using Table-Value Functions
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
SQL Course Online (Self-Paced)
-
Benefits of Learning SQL
Lesson 1: Setting Up the Work Environment
Download the PDF workbook and class files, and install the free dBeaver Community Edition to practice SQL querying without modifying databases.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Connecting to Our Database
Lesson 1: Setting Up the Work Environment
14:06
Set up a database connection in dBeaver using the provided credentials, test connectivity, and review available tables.
View enrollment options at Noble Desktop -
Getting Started & Your First Query
Lesson 2: Let's Start Learning SQL Code
7:29
Navigate databases in dBeaver by adjusting preferences, exploring schemas, and running practice queries to build familiarity.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning the SQL Language
Lesson 2: Let's Start Learning SQL Code
14:10
Review SQL syntax through slides, live demos, and exercises focused on SELECT, FROM, ORDER BY, DISTINCT, execution order, and result limits.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise PostgreSQL
Lesson 2: Let's Start Learning SQL Code
18:29
Connect to the correct database environment and complete Exercise 1C by writing and executing SQL queries.
View enrollment options at Noble Desktop -
Enrollment required
Solution PostgreSQL Challenge
Lesson 2: Let's Start Learning SQL Code
15:11
Query users and orders tables to view, filter, sort, and remove duplicate records.
View enrollment options at Noble Desktop -
Data Types and Filtering Results
Lesson 3: Working with Characters & Numbers
4:44
Differentiate database data types to query text and numeric values correctly, applying quotes and comparison logic appropriately.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Coding Exercise Filtering with WHERE
Lesson 3: Working with Characters & Numbers
5:34
Define the active data source to enable code hints when querying product data based on price conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution Filtering with WHERE
Lesson 3: Working with Characters & Numbers
22:42
Refine queries to filter specific records, sort results, perform calculations, handle data types accurately, and eliminate duplicates.
View enrollment options at Noble Desktop -
Pattern Matching
Lesson 4: Using SQL Wildcards
4:46
Apply wildcard characters such as percent signs and underscores with LIKE and ILIKE to identify data patterns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combining Filters and Aliases
Lesson 4: Using SQL Wildcards
4:32
Combine conditions using AND, OR, and NOT, perform calculations, and assign column aliases for clearer result sets.
View enrollment options at Noble Desktop -
Enrollment required
Coding Exercise Like and Wildcards
Lesson 4: Using SQL Wildcards
12:31
Practice filtering records using LIKE, ILIKE, and NOT to control query results precisely.
View enrollment options at Noble Desktop -
Enrollment required
Solution Like and Wildcards
Lesson 4: Using SQL Wildcards
23:49
Explore table structures and ER diagrams to understand relationships and safely query data such as email domains or state-based orders.
View enrollment options at Noble Desktop -
Database Terminology and Primary & Foreign Keys
Lesson 5: Indentifying Rows & Connecting Tables
6:44
Connect related tables by identifying primary and foreign keys to manage relationships and avoid duplication.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Joins Combining Data from Multiple Tables
Lesson 5: Indentifying Rows & Connecting Tables
12:28
Perform inner joins by matching common columns and using table aliases to simplify query syntax.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
18:40
Reinforce inner join logic by combining tables, filtering shared data, and presenting unified results.
View enrollment options at Noble Desktop -
Enrollment required
Solution Inner Join
Lesson 5: Indentifying Rows & Connecting Tables
10:36
Join users, orders, and line items to identify high-value purchases and return distinct customer details.
View enrollment options at Noble Desktop -
Inner vs. Outer Joins
Lesson 6: Inner vs. Outer Joins
9:45
Compare inner joins with left, right, and full outer joins to understand how non-matching rows are handled.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
23:37
Open the designated file, review warm-up exercises, and complete challenge problems to reinforce learning.
View enrollment options at Noble Desktop -
Enrollment required
Solution Outer Join and NULL
Lesson 6: Inner vs. Outer Joins
34:12
Analyze database relationships to uncover insights such as unsold products or specific purchasing behaviors, then export results as CSV files.
View enrollment options at Noble Desktop -
Cast
Lesson 7: Changing Data Types
7:07
Convert data types within queries using CAST without altering the underlying database structure.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Aggregate Functions
Lesson 7: Changing Data Types
6:33
Apply aggregate functions to calculate totals, counts, minimums, maximums, and averages for analysis.
View enrollment options at Noble Desktop -
Enrollment required
Exercise Aggregate Function and ROUND
Lesson 7: Changing Data Types
27:56
Manipulate aggregated results using rounding functions and column aliases for readable output.
View enrollment options at Noble Desktop -
Enrollment required
Solution Aggregate Function and ROUND
Lesson 7: Changing Data Types
19:00
Build aggregate queries incrementally, validating intermediate results before final execution.
View enrollment options at Noble Desktop -
Date Functions
Lesson 8: Working with Dates
2:20
Work with date and time functions to retrieve current timestamps, extract components, and convert data types.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Exercise 2.0 Date Functions
Lesson 8: Working with Dates
19:52
Extract, format, filter, and convert date values using date_part, to_char, CAST, and range-based conditions.
View enrollment options at Noble Desktop -
Enrollment required
Solution 2.0 Date Functions
Lesson 8: Working with Dates
17:40
Analyze account creation data to determine user age, creation year, weekend sign-ups, and date-range activity.
View enrollment options at Noble Desktop -
Grouping Data
Lesson 9: Organizing Statistical Results Into Categories
8:18
Group records using GROUP BY to apply aggregate functions across defined categories.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Subqueries
Lesson 10: Subqueries
27:41
Nest subqueries within main queries to process intermediate results before final selection.
View enrollment options at Noble Desktop -
Enrollment required
Solution Subqueries
Lesson 10: Subqueries
24:51
Prefer joins over subqueries when appropriate to improve clarity and performance.
View enrollment options at Noble Desktop -
Enrollment required
Aggregate Window Functions
Lesson 11: Aggregate Window Functions
23:01
Use window functions to add aggregate insights while preserving row-level detail.
View enrollment options at Noble Desktop -
Enrollment required
Solution WIndow Functions
Lesson 11: Aggregate Window Functions
9:34
Apply PARTITION BY within window functions to analyze grouped metrics without collapsing results.
View enrollment options at Noble Desktop -
Enrollment required
Conditionals
Lesson 12: Conditionals
18:26
Create conditional logic with CASE statements to classify, transform, or correct query output.
View enrollment options at Noble Desktop -
Enrollment required
CASE Exercise
Lesson 12: Conditionals
14:36
Categorize data into regions or groups, calculate order counts, and manage joins for broader analysis.
View enrollment options at Noble Desktop -
Enrollment required
Views
Lesson 13: Views
18:50
Save reusable queries as views to simplify access, enhance security, and streamline workflows.
View enrollment options at Noble Desktop -
Enrollment required
Views Solution
Lesson 13: Views
0:46
Summarize and filter user spending patterns using flexible query criteria.
View enrollment options at Noble Desktop -
String Functions
Lesson 14: String Functions
4:34
Manipulate text data with string functions to change case, extract substrings, split values, and evaluate length.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Learning Resources
Lesson 15: Additional Resources
3:24
Reinforce skills through external SQL resources, practice platforms, cheat sheets, and coding challenges.
View enrollment options at Noble Desktop -
Enrollment required
Finding Datasets
Lesson 15: Additional Resources
2:04
Source datasets from Kaggle and convert them into usable databases with guided setup support.
View enrollment options at Noble Desktop -
AI and SQL
Lesson 16: AI and SQL
11:06
Use AI tools such as ChatGPT to explain, refine, and generate SQL queries while validating results independently.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Challenge AI and SQL
Lesson 16: AI and SQL
5:13
Generate SQL queries from database visuals using tools like Chat2BT, specifying structure and dialect requirements.
View enrollment options at Noble Desktop -
Enrollment required
Solution AI and SQL
Lesson 16: AI and SQL
14:13
Apply best practices for using AI-generated SQL by providing clear requirements, verifying accuracy, and learning from explanations.
View enrollment options at Noble Desktop