Build advanced SQL capabilities by mastering outer joins for complete data retrieval, discovering and managing NULL values, calculating statistics with aggregate functions, filtering grouped data using HAVING, converting data types with CAST, and manipulating date and time information effectively.
This intermediate SQL course strengthens your foundational SQL abilities, enabling you to join multiple tables, apply sophisticated filters, organize data into meaningful groups, and conduct detailed analytical queries on databases.
You'll develop proficiency with outer joins that retrieve all matching records, and techniques for identifying and handling NULL values strategically. You'll master the practice of aggregating data using statistical functions to calculate totals, averages, and other metrics. Database operations frequently demand changing one data type to another (through CAST conversions) to meet specific analytical objectives, and you'll become comfortable transforming date and time values for temporal analysis.
After completing this intermediate hands-on course, you'll command numerous SQL techniques for extracting, filtering, grouping, and analyzing the exact information you need. This transforms raw database content into strategic insights that drive business decisions.
Prerequisite:
SQL proficiency equivalent to our SQL Level 1 course is required, including basic query construction, filtering fundamentals (WHERE, LIKE, and wildcards), and standard inner JOINs.
Key Outcomes and Learning Objectives:
- Master Outer Joins and locate NULL data
- Group data and perform common statistical calculations using Aggregate Functions
- Filter grouped data with HAVING
- Use CAST to make a data type fit your query's needs
- Work with dates and time
Course Curriculum and Detailed Topics:
- Inner vs Outer JOIN
- Outer Joins and Finding NULLs
- Manipulating, Aggregating, and Filtering Data
- Using CAST to Change Data Types
- Aggregate Functions
- Working with Dates and Time
- Grouping Data and Filtering Grouped Data
- Grouping Data with Aggregate Functions
- Filtering Grouped Data with HAVING
Click HERE to download the complete Syllabus
Learn more about SQL Level II at NYIM Training
