← Back

# SQL Zero to Hero

##### A comprehensive SQL course for absolute beginners. Start with the basics and progress to intermediate/advanced topics like window functions, CTEs and complex joins.

Free
Beginner

Estimated time to complete: 4 hours

### Learning outcomes

- Understand SQL's main use cases and identify where to use it
- Know how to create, alter, clone and drop tables
- Know how to query tables, retrieving data based on filters and other logic
- Know how to join tables
- Know how to write window functions for advanced data manipulation

### Course outline

Learn how to calculate the minimum and maximum values of a column

Introduction to the course and your instructor

Learn how to rename columns and specify their order.

Learn how to use the + operator and the SUM function in SQL

Learn about the basic functions and use cases of SQL.

Learn how to count the number of values in a column, including how to use DISTINCT and IFNULL

Learn how to rename columns and specify their order

Understand the concept of dialects in SQL

Learn how to specify the number of rows you retrieve in your query

Learn how to sort/order the rows in your tables

Introduces the concept of filtering in SQL and shows how to use the WHERE keyword to filter rows in our tables

Learn how to calculate the average value of a column in SQL

Learn how to use INNER JOIN to select rows which appear in all tables in the join

Learn how to use IN and NOT IN to filter data tables

Learn how to use wildcards to filter data tables

Learn how to combine filters in a WHERE clause

Learn how to perform multiplication in SQL

Introduction to math and data analysis in SQL

Learn how to perform subtraction using the - operator.

Learn how to divide columns in SQL and use the % operator and NULLIF function

Learn how to round numbers in SQL

A brief overview of additional mathematical functions like ABS(), LOG(), and SIN()

Learn how to perform aggregate calculations with GROUP BY

Learn a shorter way to write GROUP BY clauses

Learn how to filter aggregated data with HAVING

Learn how to use LEFT JOIN to connect two tables

Learn about the concept of relational databases and joins