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:
- Organize and summarize data using Aggregate Functions for statistical work
- Filter grouped data with HAVING conditions
- Use CAST to adapt data types to meet your query specifications
- Work with dates and times for temporal operations
- Execute Advanced Joins such as Self Join and Union
Learn more about SQL Server Level II at NYIM Training.
