Free online SQL course
New to Tech? Learn SQL for Free – No Experience Needed!
Curious about data? Thinking about a career in tech? SQL is one of the easiest and most useful skills you can learn to get started.
Our free beginner-friendly SQL course will walk you through the basics step by step – no prior experience required. You’ll learn how to work with data, write simple queries, and understand the language behind databases used by companies everywhere.
You can find the links to each page below. If you are completely new to SQL then we suggest you work through each tutorial in order. If you already have some knowledge then you can skip the tutorials you already know. Each of the tutorials is accompanied by a video tutorial. For more advanced topics then we recommend the complete course in SQL.
Course topics
- 1 - Don’t get left behind, learn SQL for beginners
- 2 - How to write NOT EQUAL in SQL
- 3 - Top SQL data types you need to understand
- 4 - How to convert data types in SQL
- 5 - How to write SQL CASE and IF statements and which Is best
- 6 - How to Use the SQL REPLACE Function
- 7 - Is SQL SUBSTRING the Most Useful SQL Function
- 8 - How to use GETDATE in SQL
- 9 - How to work out date differences in SQL with datediff
- 10 - SQL date formats and how to understand them
- 11 - How to write subqueries in SQL and why you shouldn’t
- 12 - How to group by in SQL
- 13 - Why SQL HAVING Is Different from WHERE
- 14 - Why you need to know SQL join types
- 15 - Why understanding the SQL inner join is essential for the analyst
- 16 - Why You Need SQL LEFT OUTER JOINS
- 17 - What Is the Point of the SQL RIGHT OUTER JOIN?
- 18 - How to write SQL CROSS JOINs and why they are so dangerous
- 19 - How to Write Multiple Joins in SQL
- 20 - How to Insert Data into a Database with SQL
- 21 - How to Update Data Using SQL
- 22 - How to Delete a Record in SQL
- 23 - Is SQL TRUNCATE More Powerful than DELETE ?