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.
Course resources: miniature-icon-2cc.notion.sit...
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
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

[@vladdata741]

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

[@teachersdelight6996]

You rock. Thank you, Subscribing right away.

[@vladdata741]

@@teachersdelight6996 ❤

[@rpa_class2020]

Already subscribed sir ..if possible pls power bi 🙏

[@FM-Vox]

This is exactly what I needed! Thank you 🙏

[@GoodGameShishou]

I really liked the way you describe every concept in detail making it easier to understand and remember. 🫡👌🏿

[@darasat]

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

[@vladdata741]

❤

[@rpa_class2020]

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 🎉

[@vladdata741]

That's awesome. Comments like this make my day ❤

[@giveaway4002]

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.

[@vladdata741]

♥

[@jt3guitar]

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

[@vladdata741]

Thank you! 😊

[@bharathnaveen8870]

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

[@vladdata741]

You won't be a noob for long! :)

[@sumanuphuket]

Enjoying it, thanks Lots of Love

[@TheWefikus]

thanks bro - excellent course, exactly what I need for my job!

[@giveaway4002]

awesome awesome course. i reserved my weekend only for this!

[@lisdexia1]

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

[@vladdata741]

Yep, SQL is pretty great

[@longrolstral]

Thank you Vlad. This is a great tutorial. I've taken a course before on Udemy, and this one introduces a lot of new concepts.

[@ramesettyramya4528]

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

[@vladdata741]

Amazing, thank you ❤

[@nadetdevfullstack7041]

Excellent. Thanks.

[@Apenschi]

Good course! Thanks for providing it for free!!!

[@mannykhan7752]

Thank you thank you thank for this amazing video

[@sundayoloruntoba9915]

Great explanation. Thanks

[@platinum11110]

Great! Thank you!

[@jeffjeff4831]

Thanks for this.

[@vladdata741]

My pleasure, hope you like it! Vlad

[@hemanththegamer1901]

❤❤

[@askholia]

This is exactly what I needed.

[@vladdata741]

Awesome to hear!

[@ministerbo3025]

Thanks for this and all that you do on this channel. I am dedicated to life long learning and courses like this is simply outstanding. Wow - what valuable information shared and done in a way that encourage learning. 😊❤💯💥💅 East Coast Sr.🌴

[@vladdata741]

Nice, keep on learning!

[@datacreative]

Fantastic course!!!

[@vladdata741]

♥

[@TheNoodleMint]

Thank you.

[@vladdata741]

My pleasure!

[@frankzelazko]

Thank you

[@vladdata741]

Enjoy the course!

[@jhormanalcantaramedina6392]

Thankkk youuu🙌🏻🙏🙏

[@vladdata741]

Enjoy!

[@matteomcguinness3929]

Nice just what I was looking for🎉

[@ickebins6948]

Sure...

[@jhormanalcantaramedina6392]

X2

[@vladdata741]

Awesome, hope you like the course!

[@keithle_]

Hope you will open a free data engineering course (from A to Z) Vlad soon since you're DE yourself

[@vladdata741]

I'd love to do that 😊

[@Lucifer0872]

i wan thinking about this today only

[@vladdata741]

Nice!

[@dennellewalton5843]

Great course! I have one question - I know you said Alias and Select occur at the same time but doesn't Alias occur after Select since you need something to already exist in order to change it?

[@vladdata741]

Yes, but I see alias as more of a component of select rather than a separate step

[@nikhuge6580]

nice course

[@vladdata741]

Thank you, hope it helps!

[@deepaksoni5684]

Lucid way of teaching

[@vladdata741]

♥

[@nocopyrightgameplaystockvi231]

This is a google bigQuery tutorial? Nice thanks x100.

[@vladdata741]

Hey there! It's an intro to BigQuery but mainly focused on SQL fundamentals. I chose BigQuery because it's easy to use.

[@nocopyrightgameplaystockvi231]

@@vladdata741 thanks. I also wanted to use BigQuery but this looks like a good starter point. Thanks again.

[@moisesespiritosanto2195]

Hi, I'm from São Paulo! Yeah excellent! ABRAÇO!

[@vladdata741]

Tomara que você curta o curso! Vlad

[@lettileite]

Eu de Florianópolis. Assistindo de Auckland, New Zealand. When I heard your accent I was sure you were from Brazil 😅. Thank you very much ❤🎉❤🎉

[@vladdata741]

​@@lettileiteI'm Romanian, sometimes we sound weirdly similar to Portuguese! 😀

[@lettileite]

😂 Sorry about that. Just got to the sing in part 😁. Subscribed to your channel. Thank you again 🎉

[@DiegoSita]

@@vladdata741 Amazing tutorial, man. Greetings from Brazil.

[@apamwamba]

SQL Joins visualizer is cool any link?

[@vladdata741]

sql-joins.leopard.in.ua/

[@vncoolestguy]

is there a 1080p version ?

[@vladdata741]

This is the best I have now. I'm still learning the ropes on video making!

[@sarmhn123]

@@vladdata741 This is perfectly fine. Good enough Video & Audio. Thank you.

[@PANDURANG99]

is there any certifications?

[@vladdata741]

No, unfortunately. But I'll probably do it for my next course!

[@PANDURANG99]

@@vladdata741 I hope, that I will complete in 1 month 😅

[@Apenschi]

1:57 Don't use CREATE OR REPLACE! It is dangerous. Use DROP CASCADING and then CREATE. For that reason many DBMS doesn't even support OR REPLACE for tables. For tutorials you should stick to SQL that is supported by the main players like Oracle and SQL Server! Thanks!

[@vladdata741]

Hey there. BigQuery doesn't have DROP CASCADING because it has no concept of table dependencies. If you dropped a table by mistake, most tables support time travel, i.e. you can go back in time to a previous state within 7 days. Finally, if you want to work in analytics, it's more likely that you will work with BigQuery rather than Oracle or SQL Server.

[@Apenschi]

@@vladdata741 Ok. Thanks!

[@bluehat974]

Why not using DuckDB directly in Python or in browser?

[@vladdata741]

You can use whatever you want to follow along. I thought bigquery would be easiest for people who never touched programming. And it has a nice interface.

[@vladdata741]

And if you want to work in analytics, having knowledge of a data warehouse like BigQuery is a bonus. Two birds with one stone.

[@nocopyrightgameplaystockvi231]

BigQuery is actually used by companies, 60% of the time.

[@ashishsahu8065]

hi can you please share the dataset ?

[@vladdata741]

You can find on the course page miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab

[@syedmuhammadahmed885]

do we get a certification if we do on there website or something guys just give a yes or no

[@vladdata741]

No certification

[@nocopyrightgameplaystockvi231]

Where is the zip file 🌚🙄

[@vladdata741]

Hey, it's in the course page linked in the description: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab\

[@kopek3105]

Why not use PostgreSQL on local machine? Thats some bullshit, this is not the easiest and for sure not most comfortable way to learn SQL.

[@vladdata741]

You can certainly install it and follow along there. In fact the exercises are in PostgreSQL.

[@GoodGameShishou]

But I really like the way he is teaching! Quite clear and understandable for a beginner! 👏🏿👌🏿

[@florentd.5817]

Please rename it ! This is a google bigquery tutorial.

[@vladdata741]

Hey there. Not really, it was just the easiest way to get you started with SQL. The exercises are on another system (PostgreSQL).

[@longrolstral]

SQL is fairly agnostic, so the GUI used is not particularly relevant. Had he used a terminal, would it have been a terminal tutorial? Had he used DB Gate, would it have been a DB Gate tutorial?

[@Artopiumcom]

Who is seriously watching an 11 hour video tutorial? Clearly, trying to come back to where One left off is insanely difficult. There's an actual reason books a broken into chapters.

[@DiegoSita]

Me...

[@vladdata741]

Hello. You can find chapter's with timestamps on the description!

[@marcbazin6352]

I think rewatching some parts you might have already seen is extremely relevant when you're learning something. You know, repetition and all that. Also, SQL is kinda too big for a 5-minute clip, if that's what you're looking for.

[@nocopyrightgameplaystockvi231]

How hard is that for you to check out the chapters?

[@TheWefikus]

there's literally chapters in this video bro. settle down

[@zamanrashid122]

Nice🎉🎉