Strengthen your SQL abilities by learning outer joins for comprehensive data retrieval, techniques for identifying and working with NULL values, statistical calculations through aggregate functions, advanced filtering using HAVING clauses, data type conversion with CAST, and practical date and time operations.
This intermediate SQL course enhances your foundational SQL knowledge, building competence in joining tables, filtering results, grouping data, and performing sophisticated data analysis.
You'll learn how to perform outer joins that capture all records from specified tables, and you'll develop strategies for finding and handling NULL data values. You'll master the process of grouping your data and computing common statistical metrics using aggregate functions. Database work frequently requires converting data from one type to another (using CAST conversions) to meet your analytical requirements, and you must become skilled in formatting and transforming date and time information for your queries.
Upon finishing this intermediate hands-on course, you'll possess a comprehensive toolkit of SQL techniques for extracting, filtering, grouping, and analyzing the specific data you require from databases. This empowers you to transform raw database information into meaningful business insights.
Prerequisite Requirement
SQL experience equivalent to our SQL Level 1 course is required, including foundational querying, filtering fundamentals (WHERE, LIKE, and wildcards), and inner JOIN operations.
Key Learning Outcomes
- Master Outer Joins and locate NULL values in your datasets
- Organize data by groups and calculate common statistics
- Use Aggregate Functions for data summarization
- Filter grouped data with HAVING conditions
- Apply CAST functions to modify data types for query compatibility
- Work effectively with dates, times, and temporal data
Core Topics and Detailed Course Outline
- Inner vs Outer JOIN Operations
- Understanding Outer Joins and Finding NULLs in Results
- Manipulating, Aggregating, and Filtering Data
- Using CAST to Modify and Convert Data Types
- Working with Aggregate Functions for Statistics
- Working with Dates and Time Information
- Grouping Data and Filtering Grouped Data
- Grouping Data with Aggregate Functions for Summaries
- Filtering Grouped Data with HAVING Conditions
Developing Advanced SQL Skills: Creating Subqueries and Conditional Logic
SQL Level 2 delves into the advanced functions and features that make SQL more powerful and easier to use. This course emphasizes practical techniques to group and filter your data, introduces temporal operations with dates and times, and explores many more capabilities.
Like all SQL courses in our program, SQL Level 2 is structured as a project-based, hands-on learning experience. Through practical exercises and projects completed throughout SQL Level 2, students develop a deeper understanding and reinforce learning through application.
Upon course completion, you'll be able to accomplish the following tasks and operations:
- Organize and summarize data using Aggregate Functions for statistical calculations
- Apply HAVING conditions to filter grouped data results
- Use CAST functions to adapt data types to meet query requirements
- Perform temporal operations with dates and time values
- Execute Advanced Joins such as Self Join and Union operations
Learn more about SQL Server Level II at NYIM Training.
