Learn SQL Fundamentals Through 10 Practice Problems – Course Description
Have you ever felt like you would get SQL for good, if you could just practice it more? While learning SQL, I’ve felt this way on many occasions. The only problem is, there aren’t that many problems out there for practicing. It seems like the only place to get a large amount of query practice in is at a job, but how are you supposed to get that job if you don’t know your SQL?
This course aims to solve that problem by exposing you to the volume of practice you need to become proficient. In it, we cover 10 different SQL challenges in depth, showing you the thinking that goes into finding the right answers, as well as common mistakes and how to avoid them.
There are two parts to this course – the videos, and the actual hands-on practice. The Udemy course only gets you access to the video overview of each query challenge – to actually try your hand at the query challenges, you need to sign up on our website (this is free, we show you how to do it in the first lecture). Once you finish a challenge (or if you get stuck), check back on the Udemy videos to see how we did it.
This is an basic level course for people who already have a general understanding of how SQL works. Now don’t let that scare you away if you are a gung-ho beginner – just know that if that is you, you are going to have to learn quick and be willing to search terms if you don’t recognize them.
What are the requirements?
- No software is required
- General familiarity with SQL is helpful
- Knowledge of SELECT, FROM, and WHERE clauses
- Knowledge of subqueries
What am I going to get from this course?
- Over 12 lectures and 1 hour of content!
- Use SELECT, FROM, and WHERE clauses to perform queries
- Analyze database schemas to find the right tables and columns for any query
- Use “less than” and “greater than” signs (< and >) to filter their data
- Use the DISTINCT keyword to eliminate duplicates
- Use the AND keyword to append multiple filters in the WHERE clause
- Use the IN operator for filtering results
- Make basic subqueries
- Use the GROUP BY and HAVING statements to filter data by groups
- Use basic functions like MAX(), MIN(), COUNT(), and AVG()