SQL Server Level II (Live Online)

Expand your SQL skills by learning how to use Outer Joins, find NULL data, group data with aggregate functions, filter groups with HAVING, work with dates/time, and more.In this intermediate SQL course, you’ll build on your knowledge of SQL fundamentals, enhancing your skills to join, filter, group, and analyze data.You’ll learn how to use Outer Joins and find NULL data. Group data and perform common statistical calculations using aggregate functions. Working with data requires the ability to change the data type when it’s not what you need (using CAST), and to be able to work with and format date and time information. By the end of this intermediate hands-on course, you’ll know more SQL techniques to extract and analyze the specific data you want from the database. This will enable you to more easily turn raw data into actionable insights.This course has a prerequisiteSQL proficiency equivalent to our SQL Level 1 course is required, including basic querying, fundamentals of filtering (WHERE, LIKE, and wildcards), and inner JOINs.What You’ll Learn at a GlanceLearn to use Outer Joins and find NULL dataGroup data and perform common statistical calculations using Aggregate FunctionsFilter grouped data with HAVINGUse CAST to make a data type fit your query’s needsWork with dates and timeCourse SyllabusInner vs Outer JOINOuter Joins & Finding NULLsManipulating, Aggregating, & Filtering DataUsing CAST to Change Data TypesAggregate FunctionsWorking with Dates & TimeGrouping Data & Filtering Grouped DataGrouping Data with Aggregate FunctionsFiltering Grouped Data with HAVINGClick HERE for the SyllabusLearn more about SQL Level II at NYIM Training