← 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