Courses Infomation

Practice SQL JOINS with 20 Query Challenges

**More information:

Description

Filesize : 495.64 MB

What you’ll 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

Course content
Expand 23 lectures02:14:47
–Challenges
02:14:47
Welcome to 20 Queries!
Preview
01:01
How to access the course
00:17
Challenge #1
Preview
05:48
Challenge #2
Preview
12:45
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
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 this course is for:

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

NLP online course

So what is NLP?
NLP stands for Neuro-Linguistic Programming. Neuro refers to your neurology;
Linguistic refers to language; programming refers to how that neural language functions.
In other words, learning NLP is like learning the language of your own mind!

NLP is the study of excellent communication–both with yourself, and with others.
It was developed by modeling excellent communicators and therapists who got results with their clients.
NLP is a set of tools and techniques, but it is so much more than that.
It is an attitude and a methodology of knowing how to achieve your goals and get results

Salepage : Practice SQL JOINS with 20 Query Challenges