Share Description
In this course you will learn :
- How to write basic SQL commands such as SELECT, FROM, and WHERE.
- Understand how to use logical operators in SQL.
- Discover how to use INNER JOINS to combine data from multiple tables.
- LEFT JOINS are used to combine data from multiple tables.
- How to write common SQL aggregations such as COUNT, SUM, MIN, and MAX.
- How to write CASE and DATE functions, as well as how to deal with NULL values.
- How to write subqueries to run multiple queries concurrently.
- How to use temp tables to access a table with multiple queries.
- Discover how to clean data using SQL.
- To handle more analysis tasks, learn to use window functions.
Syllabus :
- SQL Basics
- SQL Joins
- SQL Aggregations
- Subqueries and Temp Tables
- SQL Data Cleaning
- Window Functions
