SQL Certification Program
- 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
In our SQL Certification Program, you’ll learn to write SQL queries, extract and analyze data, and generate insights from relational databases. This hands-on training uses PostgreSQL and the DBeaver app, but the skills apply to other platforms like SQL Server, MySQL, and Oracle SQL.
This program includes:
- Our SQL Bootcamp (18 hours total)
- Six (6) hours of private tutoring (two 3-hour sessions)
- The Oracle Database SQL Certified Associate exam, with a free retake included
- Guidance on PostgreSQL-to-Oracle differences during private training
- Access to additional study materials for exam preparation
- Option to replace the exam with one additional hour of private tutoring
Please note that this course teaches PostgreSQL, which is similar to Oracle SQL. Differences can be reviewed during the private training sessions to help you prepare for the certification exam.
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
Curriculum
What you'll learn
- Explore information stored in a database (tables, columns, rows, and more) 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 information you need
- Advanced techniques such as subqueries, string functions, and IF‑ELSE logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
Course outline
-
SQL Bootcamp 18 hours
Learn to extract information 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.
- 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
What's included
- Free course retake within one year to refresh the material and gain practice.
- Course workbook
- 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
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Thu
18:00–21:00 · America/New_York (EDT/EST)
-
–
In-person or live online
Sun
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Thu
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Tue, Wed
10:00–17:00 · America/New_York (EST)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program 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
- $1,699
- Course length
- 24 hours
- Schedule
- On your schedule
In our SQL Certification Program, you’ll learn to write SQL queries, extract and analyze data, and generate insights from relational databases. This hands-on training uses PostgreSQL and the DBeaver app, but the skills apply to other platforms like SQL Server, MySQL, and Oracle SQL. This program includes:
- Our SQL Bootcamp (18 hours total)
- Six (6) hours of private tutoring (two 3-hour sessions)
- The Oracle Database SQL Certified Associate exam, with a free retake included
- Guidance on PostgreSQL-to-Oracle differences during private training
- Access to additional study materials for exam preparation
- Option to replace the exam with one additional hour of private tutoring
Please note that this course teaches PostgreSQL, which is similar to Oracle SQL. Differences can be reviewed during the private training sessions to help you prepare for the certification exam.
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, and more) 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 information you need
- Learn advanced techniques such as 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 course outline
-
SQL Course Online (Self-Paced) 18 hours
Learn to extract information 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.
- 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
What's included with self-paced
- Course workbook
- 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