20 Queries SUBQUERIES

[aretr]

$100 | Created by Taylor Chiu, Thomas Fowles | Video: h264 1280x720 | Audio: AAC 48KHz 2ch | Duration: 02:11 H/M | Lec: 22 | 447 MB Language: English | Sub: English [Auto-generated]

Master subqueries through our set of 20 practice challenges

What you'll learn
Create subqueries that utilize aggregate functions
Create derived tables
Use multiple subqueries in the SELECT clause
Use JOINS and subqueries in the same query

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 subqueries

Description
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.

Who this course is for?
People who have taken our "Learn SQL Fundamentals Through 10 Pratice Problems" course
People who want to feel comfortable with making subqueries
People who need more practice with SQL problems
People looking to get a job that uses SQL
People who want to learn SQL to get a raise
People who want to learn SQL to get a promotion
Homepage

Code:

https://www.udemy.com/course/20-queries-subqueries/

Screenshots



DOWNLOAD

Code:

http://nitroflare.com/view/86FC228FBEFB13A/bpvaq.20.Queries..SUBQUERIES.rar

Code:

https://rapidgator.net/file/82b13c36d10113fc6e3ecdb1c1192b6a/bpvaq.20.Queries..SUBQUERIES.rar