Ready for more SQL practice?
"20 Queries - SUBQUERIES" is the next step in your journey to master SQL.
Our first two courses, "HANDS-ON SQL" and "10 Queries" covered basic SQL statements, with a brief introduction into advanced topics like joins and subqueries. Then we worked on getting you comfortable with complex joins in our "20 Queries - JOINS" course.
Now it's time to do the same with subqueries!
Like in "20 Queries - JOINS", this course is a set of 20 practice challenges, ranging from very simple to advanced-level subqueries. You'll learn how to use subqueries in the SELECT clause, to use them to create derived tables, to use them with aggregates, and much more!
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 intermediate level course for people who already have a basic 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.
Hi there, my name is Taylor Chiu of LearnToSQL. Ever feel like you want to know more about coding or other tech stuff, but can't because you aren't good at it, or can't speak the lingo? If so, I've been in your shoes, and I know how to get past that sticking point. I'm more naturally a business and sports guy, but made the transition into my current job of database engineer (where I've been for the last 2 years) because I wanted to expand my horizons. It hasn't been an easy process, but it has been very rewarding.
The thing is, anyone can get good at tech, you just have to be persistent. And it doesn't hurt to have someone who can speak to you in a way you understand, until you're able to understand the ins-and-outs technically. That's what I want to provide for you.
Passionate business intelligence developer with 3 years experience solving enterprise data problems. Expert-level proficiency with major database systems such as Microsoft SQL Server, Oracle, and MySQL. Proficient with common database tools such as SAP Data Services, Tableau, and SSIS.
Co-founder or SQL Prep, which aims to educate the workforce and build data literacy within companies.