Practice SQL JOINS with 20 Query Challenges
3.7 (28 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.
433 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Practice SQL JOINS with 20 Query Challenges to your Wishlist.

Add to Wishlist

Practice SQL JOINS with 20 Query Challenges

Learn how to use SQL JOINS with this set of 20 practice problems. This is the natural followup to our 10 Queries course.
3.7 (28 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.
433 students enrolled
Last updated 8/2017
English
Price: $100
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Solve 20 intermediate-level query challenges that all incorporate JOINS
  • Make JOINS of up to 4 or 5 tables in the same query
  • Know when to use LEFT and RIGHT JOINS, vs INNER JOINS
  • Know how to add aliases to all of their JOINS
View Curriculum
Requirements
  • No software is required
  • You should have taken our "Learn SQL Fundamentals Through 10 Pratice Problems" course, or have a working knowledge of SQL
  • General knowledge of JOINS
Description

Ready for more SQL practice?

"Practice SQL JOINS With 20 Query Challenges" is the next step in your journey to master SQL.

In our first course, "Learn SQL Fundamentals With 10 Practice Problems", we covered the basics of making a query, filtering, joins, and subqueries. It was a great start, but you are going to need more if you really want to get a job in SQL.

In this course, we focus specifically on taking your skill with making JOINS to the next level! Each problem will require you to form a JOIN, and sometimes you'll have to 4-5 JOINS to get the right answer. But don't worry, as always, you can check out our video explanations if you get stuck.

Just like our intro course, 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.

Who is the target audience?
  • People who have taken our "Learn SQL Fundamentals Through 10 Pratice Problems" course
  • People who want to improve their understanding of JOINS
  • People who need more SQL practice problems
  • People who want a job in SQL
  • People who want to learn SQL to get a raise
  • People who want to learn SQL to get a promotion
Compare to Other Courses
Curriculum For This Course
23 Lectures
02:14:47
+
Challenges
23 Lectures 02:14:47

How to access the course
00:17



Challenge #3
14:41

Challenge #4
06:19

Challenge #5
05:22

Challenge #6
05:31

Challenge #7
08:45

Challenge #8
07:44

Challenge #9
05:38

Challenge #10
05:40

Challenge #11
04:55

Challenge #12
05:02

Challenge #13
06:53

Challenge #14
06:01

Challenge #15
04:55

Challenge #16
06:06

Challenge #17
05:40

Challenge #18
02:25

Challenge #19
04:59

Challenge #20
07:09

20 Queries Wrap Up
01:11
About the Instructor
Taylor Chiu
4.5 Average rating
309 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
309 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.