Overview

Expand your SQL capabilities by mastering outer joins for complete data retrieval, finding and managing NULL data, using aggregate functions for statistical analysis, filtering grouped results with HAVING clauses, converting data types with CAST, and working effectively with date and time information.

Course Focus and Learning Path:

In this intermediate SQL course, you'll build upon your foundational SQL knowledge, developing advanced competencies in joining tables, filtering results, grouping data, and performing complex data analysis on real-world datasets.

You'll learn to perform outer joins that capture data from multiple tables more comprehensively, and you'll develop techniques for identifying and handling NULL values effectively. You'll master data grouping and compute common statistical calculations using aggregate functions. Working with databases frequently requires converting information from one data type to another (using CAST statements) to align with your analytical needs, and you'll become proficient in manipulating date and time values in various formats for temporal analysis.

Upon completing this intermediate hands-on course, you'll have developed numerous SQL techniques for extracting, filtering, grouping, and analyzing the specific information you need from databases. This capability enables you to convert unstructured database records into strategic business insights.

Required Background:

SQL proficiency equivalent to our SQL Level 1 course is required, including foundational querying, filtering fundamentals (WHERE, LIKE, and wildcards), and standard inner JOINs.

What You'll Learn:

Execute Outer Join operations and discover NULL data in your results
Organize data into groups and perform common statistical calculations using
Aggregate Functions
Filter grouped results with HAVING clauses
Use CAST to convert data types to fit your query specifications
Work with dates and time information effectively

Complete Course Syllabus:

Inner vs Outer JOIN Comparison
- Outer Joins; Finding NULLs in Data
Manipulating, Aggregating, and Filtering Data
- Using CAST to Change Data Types
- Aggregate Functions for Summaries
- Working with Dates and Time
Grouping Data and Filtering Grouped Data
- Grouping Data with Aggregate Functions
- Filtering Grouped Data with HAVING

Advanced SQL Functions for Subqueries and Logic Statements

SQL Level 2 explores the functions and features that make SQL more practical and powerful. Master techniques to group and filter data, develop working knowledge of dates and times, and discover additional capabilities that expand your SQL toolkit.

Following the pattern of our other SQL courses, SQL Level 2 employs project-based, hands-on instruction. Activities and projects completed in SQL Level 2 help participants retain concepts and strengthen practical application skills through real-world exercises.

At the end of this course, you'll be able to: