Skip to main content

Explore Problems

Certifications Quiz Pricing

⌘K

Foundations - SQL

Course Contents

Course Introduction

Course Resources

Course Roadmap & Structure

What is SQL and What are Databases?

Types of Databases

Environment Setup: SQL Server, SSMS and Databases

What is SQL Query

Components of SQL

Coding Order vs Execution Order

Intro - What is Data Filtering

Comparison Operators

BETWEEN Operator

Intro - What is Data Combining

RIGHT ANTI JOIN

Choosing the Right JOIN

Multiple Table JOINS

Introduction to SET Operators

Set Rules & Syntax

Use Case – Combining Information

Use Case – Delta Detection

SET Operators Summary

Intro - What is Data Transformation

Number Functions

What is Date & Time

Overview of Date & Time Functions

DAY, MONTH, YEAR

Use Cases – Date Extraction

Comparing Extract Functions

Introduction to Formatting & Casting

Date & Time Summary

Date & Time Scripts

Introduction to NULLs

COALESCE vs ISNULL

Handling NULLs – Data Aggregation

Handling NULLs – Mathematical Operations

Handling NULLs – Joining Data

Handling NULLs – Sorting Data

IS NULL & IS NOT NULL

NULL vs Empty vs Blank

Handling NULLs – Data Policies

Introduction to CASE Statements

Use Case – Categorizing Data

Use Case – Mapping Values

Use Case – Handling NULLs

CASE Statement Summary

ISDATE

Validate dates in dirty data with SQL ISDATE — its SQL Server syntax, date validation in SQLite, building an ISDATE equivalent, counting and filtering invalid dates, safe date operations and a quality report.

Loading...

Loading content...