Learn SQL Fundamentals Through 10 Practice Problems (Udemy.com)

Need additional practice to improve your SQL skills? This course takes you step-by-step through 10 SQL queries.

( 49 Reviews )

Created by: Taylor Chiu

Produced in 2017

What you will learn

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()

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 94 / 100

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. Who this course is for:

People who have a general foundation in SQL, and are looking for more practice problems to further hone their skills
SQL newbies who can learn on the fly (i.e. - Google anything they don't understand)
NOT for newbies who don't learn well on their own. If that's you, we have another beginner course that would be a better introductory course

Time: 1h

Instructor Details

Taylor Chiu

4.7 Rating
49 Reviews

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.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.7

49 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Rekha

Even though I understood the concepts theoretically and felt that I knew it but after solving few queries I got a real picture of where I stand.
Without solving queries by ourselves learning SQL is incomplete.The more we practice we understand it better.
I request the instructors to introduce more hands on exercises.
I have already brought hands on sub queries and Joins from them,will start solving those soon.
Wherever I got struck while doing hands on queries I got very clear explanation about how we should analyse and solve it .Thanks to both the instructors.
Please create more videos.You both are awesome.

By Ryan Blomquist

It's a good course, and teaches differently from the lecture corses on Udemy. I do wish there were a brief (~2 minute) lead-ins on the front of each of the lectures about the query before jumping straight into solving it for the viewer.

By Patrick Wunderlich

Great practice with many different types of SQL questions. I will be starting the JOINS course soon.

By Melissa Yip

Thoroughly enjoyed the course. The explanations are clear and video quality is excellent. Definitely recommend!

By Sona Svihelova

Hello, thanks for help with SQL. One needs to get some guided practice and there are not many options when one doesnt work with it at work.

By Virgilio Balagao

I have enjoyed their solution. I have learned a lot on this and it's worth the time. Thank you for this course.

By Landon Stott

I really appreciate that you guys took the time to make these practice videos! It was the perfect answer to my dilemma.
I do wish that you explained more of the 'why' behind the solutions to the queries, rather than just running through them. I also wish that you used the formatting that is taught in most SQL courses/books, like capitalizing keywords and indenting sub-queries, etc. Looking forward to more updates in the future.

By Kevork Zenopyan

Very Good Course for people with some knowledge. Not for beginners.

By Collin Grabeel

I'm impressed with the functionality and the course material, and I'm eager to learn more.

By Jaira May Guizon

I have studied SQL back in college and this helped me refresh my memory (and actually added to my knowledge)

By Osmany Esquivel

This is a great way to practice your SQL skills. The instructor does a great job explaining the queries as well.

By Eric Dionne

This course is a great way to practice your SQL skills. You wouldn't want to start with this one if you're just learning SQL, but if you have some SQL knowledge, it helps solidify those skills and give you a better understanding of how to approach problems on your own.