Learn SQL Fundamentals Through 10 Practice Problems
4.6 (266 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
10,971 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL Fundamentals Through 10 Practice Problems to your Wishlist.

Add to Wishlist

Learn SQL Fundamentals Through 10 Practice Problems

Need additional practice to improve your SQL skills? This course takes you step-by-step through 10 SQL queries.
4.6 (266 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
10,971 students enrolled
Last updated 8/2017
English
English [Auto-generated]
Current price: $12 Original price: $50 Discount: 76% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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()
View Curriculum
Requirements
  • No software is required
  • General familiarity with SQL is helpful
  • Knowledge of SELECT, FROM, and WHERE clauses
  • Knowledge of subqueries
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 is the target audience?
  • 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
Compare to Other Databases Courses
Curriculum For This Course
12 Lectures
01:06:48
+
10 Queries Course
12 Lectures 01:06:48

Here's how to access the course
00:17



Challenge #3
10:39

Challenge #4
04:58

Challenge #5
04:01

Challenge #6
07:10

Challenge #7
01:58

Challenge #8
10:14

Challenge #9
07:09

Challenge #10
06:57
About the Instructor
Taylor Chiu
4.5 Average rating
310 Reviews
11,089 Students
3 Courses
SQL Database Engineer, Web Designer, Instructor

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.

Thomas Fowles
4.5 Average rating
310 Reviews
11,089 Students
3 Courses
Business Intelligence Developer & SQL Educator

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.