Intuitive SQL For Data Analytics - Tutorial

Learn SQL for analytics. Learn both the theory and the practice so you can confidently solve hard SQL challenges on your own. No previous experience required and you'll do everything in your browser using BigQuery.

Created by @vladdata741

⭐️ Contents ⭐️
⌨️ (00:00:00) Introduction
⌨️ (00:04:42) Syllabus & resources
⌨️ (00:09:04) Meet SQL!
⌨️ (00:10:30) Types of SQL statements
⌨️ (00:12:20) Why BigQuery
⌨️ (00:13:27) How to setup Google Cloud
⌨️ (00:17:02) How to avoid Google Cloud charges
⌨️ (00:22:11) Introduction to our data
⌨️ (00:23:16) How data is organized in BigQuery
⌨️ (00:26:53) Loading our data in BigQuery
⌨️ (00:30:09) The BigQuery Interface
⌨️ (00:37:54) Running our first query
⌨️ (00:46:20) How SQL organizes data
⌨️ (00:54:32) The SQL statement
⌨️ (00:56:05) The three orders of SQL operations
⌨️ (01:00:05) The logical order of SQL operations
⌨️ (01:03:28) Introduction to basics
⌨️ (01:04:10) SELECT and FROM
⌨️ (01:08:22) Transform columns with SELECT
⌨️ (01:19:32) The order of arithmetic operations
⌨️ (01:24:03) The WHERE filter
⌨️ (01:31:28) Boolean algebra
⌨️ (01:48:07) DISTINCT
⌨️ (01:52:04) Create BigQuery tables from queries
⌨️ (01:57:38) UNION 1
⌨️ (02:05:15) UNION 2
⌨️ (02:11:57) UNION 3
⌨️ (02:19:58) UNION 4
⌨️ (02:22:41) ORDER BY
⌨️ (02:28:52) LIMIT
⌨️ (02:34:06) CASE
⌨️ (02:52:29) Simple aggregations
⌨️ (03:06:59) Subqueries 1
⌨️ (03:16:28) Subqueries 2
⌨️ (03:25:46) Subqueries 3
⌨️ (03:29:43) Nested queries
⌨️ (03:40:11) Common table expressions 1
⌨️ (03:48:12) Common table expressions 2
⌨️ (03:53:08) Common table expressions 3
⌨️ (03:59:18) Joins
⌨️ (05:15:39) GROUP BY And Aggregations
⌨️ (06:04:11) Window Functions
⌨️ (07:09:50) Putting It All Together
⌨️ (07:15:56) Let's Solve A Hard SQL Challenge!
⌨️ (07:33:54) PostgreSQL Exercises - Introduction
⌨️ (07:42:00) PostgreSQL Exercises - Basic
⌨️ (08:10:33) PostgreSQL Exercises - Joins and Subqueries
⌨️ (08:56:45) PostgreSQL Exercises - Aggregations Pt. 1
⌨️ (09:57:51) PostgreSQL Exercises - Aggregations Pt. 2
⌨️ (10:57:51) PostgreSQL Exercises - Conclusion

🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan
👾 Oscar Rahnama

--

[vladdata]

Hope you enjoy the course. Subscribe to my channel and let me know what I should cover next!

[darasat]

Doesn't matter if you are begginer or advanced in SQL language, this course is very clear and useful.
Thank you!

[bharathnaveen]

Tysm for this vlad; I'm a noob at SQL; I will surely use this as a way to skill myself in SQL.
Book mark: 48:00
Book mark 2: 1:14:00

[ramesettyramya]

This is my first ever comment that ive written in youtube. I'm thankful to you for explaining so clearly without skipping anything, im in the half way of the course but im loving every bit of it, thank you thank you so much

[AkshitaDhyani-mdpq]

This is the best tutorial ever.
I was not able to stop myself from commenting. Thank you so much :)

[jtguitar]

oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!

[giveaway]

Completed 7:16:00 finally, Its exercise time now! I just loved the explanations, weekend well spent! thank you so much for just pouring pure knowledge.

[arin]

As a fresher who want to start her career in Data Analytics, this video is really recommended instead of SQL crash course

[georgechen]

This is an incredibly well made course on SQL! I'm a beginner to SQL and I've been trying a bunch of different courses including paid courses from Coursera but none explains the concepts as well as this one.

[sanjushreepradeepkumar]

I've seen so many vids on SQL ...I'd say this is the best that covers all models of topics and the most understandable vid on

[KoldFiyure]

This was awesome. I have been using SQL for 10 years and I played this all the way through just to see if I would learn something new. And I certainly did. I am still trying to have a really strong problem-solving mindset for SQL employment tests. This helped me a lot. I am going off to watch him solve more PG problems.

[lesguessing]

Fantastic, thorough, and yet interesting course. I especially like the notion of "Order of Operations" which I don't think I've heard about anywhere else, even though I've been playing with learning SQL for awhile. Big thanks. Well done.

[rpa_class]

I m in my halfway finished this course..i really enjoyed it ..one of the best course..very very clear very well explained ..not even paid versions clear the concepts i got from this course ..thank you so much sir 🎉

[pratyushsingh]

I loved it there are granular details which have been covered so well and explained so beautifully, which is hard to find in any other SQL crash course or lecture over the internet.
Thanks Vlad!

[drendelous]

Vlad explains stuff so well
finally a proper tutorial and not a show off with comments

[VirtualVibist-ulwd]

You are so brillaint. There are more teachers who know how to teach but very few have the knowledge about how to make them understanding the concepts. You are so good at explaining the concepts with the best accuracy and its truely awesome to learn from you. Thanks to the God (or Universe or whatever you believe) for giving you this much of clarity in teaching. All the very best to all your upcoming works.

[lisdexia]

I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'

[prajwalmp]

Taught in the simplest way, loved it.

[dancyvybes]

This course is GOLD. As simple as that. Thank You so much

[likithasiriguppa]

The way this Master is explaining is forcing me to comment on this video..

Best SQL Course that I have ever seen. This gonna be one of the best ways of investing my time which gonna give best returns 😊.