SQL II

Take your SQL skills further with advanced queries, joins, and subqueries.

SQL II is designed for professionals who already understand SQL fundamentals and want to build more advanced querying skills. This hands-on course focuses on advanced features and clauses of the SELECT statement, helping participants write more powerful queries and work more confidently in relational database environments.

Participants will explore multiple types of joins, correlated subqueries, self joins, and techniques for writing SQL that generates SQL. This course is a strong next step for learners who have completed SQL I or have equivalent experience and want to deepen their ability to retrieve, combine, and analyze data.

Deeper Query Skills

Move beyond basic SELECT statements and learn how to write more advanced queries that retrieve, combine, and organize data more effectively.

Hands-On Learning Environment

Participants will use lab computers with the required software already loaded, allowing them to focus on advanced SQL practice without needing to bring their own device.

Cross-Platform Relevance

The skills covered in SQL II are useful across many relational database environments, including Oracle, SQL Server, Access, and others.

Schedule

November 16–19, 2026
9:00 a.m.–12:00 p.m.

Cost

Course Fee: $650

Your total course fee includes: 

• In-person instruction
• Use of lab computers with pre-loaded software
• Course materials
• Parking

Prerequisites

Participants should have completed SQL I and have Windows experience, or have equivalent experience.

What’s included

Your total course fee includes:

• In-person instruction
• Use of lab computers with required software already loaded
• Course materials
• Parking

What to expect

Participants can expect a hands-on course focused on advanced SQL query writing and relational database applications.

During this course, participants will:

• Strengthen their ability to write SQL SELECT statements
• Use inner joins, natural joins, cross joins, outer joins, and self joins
• Work with basic and correlated subqueries
• Explore SQL statements that create SQL
• Learn how advanced query techniques can support reporting and analysis
• Apply SQL concepts in practical database scenarios

Course content

Topics covered in this course include:

• Basic joins and subqueries
• Inner joins
• Natural joins
• Cross joins
• Correlated subqueries
• Outer joins
• Self joins
• SQL generating SQL

Who should attend

This course is ideal for:

• SQL I graduates
• Professionals with basic SQL experience
• Analysts who need to write more advanced queries
• Employees who work with relational databases
• IT, reporting, finance, operations, and business intelligence professionals
• Anyone who wants to improve accuracy and efficiency when retrieving data

What you’ll learn

Upon successful completion of this course, participants will be able to:

• Write SQL SELECT statements using correlated subqueries
• Write SQL SELECT statements using inner joins, natural joins, cross joins, outer joins, and self joins
• Write SQL SELECT statements that create SQL
• Apply advanced query techniques in relational database environments
• Use SQL more effectively for reporting, analysis, and business decision-making

FAQ

Do I need to take SQL I first?

SQL I or equivalent experience is recommended. Participants should understand basic SQL concepts before enrolling in SQL II.

Do I need to bring my own laptop?

No. Participants will use lab computers during class. The required software will already be loaded.

Do I need to install anything before class?

No. This in-person course uses lab computers with the required software already installed.

How is SQL II different from SQL I?

SQL I focuses on foundational SQL statements and basic querying. SQL II goes deeper into advanced SELECT statements, joins, correlated subqueries, and SQL generating SQL.

Is this course hands-on?

Yes. Participants should expect guided practice and applied exercises focused on advanced SQL features.

Are materials and parking included?

Yes. Course materials and parking are provided as part of the total course fee.

Ready to advance your SQL skills?

Build on your SQL foundation and learn advanced query techniques that can help you work more effectively with relational databases.