Intuitive SQL For Data Analytics - Tutorial
Переглядів 99,840
День тому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 16 днів тому
Hope you enjoy the course. Subscribe to my channel and let me know what I should cover next!
@teachersdelight6996 16 днів тому
You rock. Thank you, Subscribing right away.
@vladdata741 16 днів тому
@@teachersdelight6996 ❤
@rpa_class2020 15 днів тому
Already subscribed sir ..if possible pls power bi 🙏
@FM-Vox 14 днів тому
This is exactly what I needed! Thank you 🙏
@GoodGameShishou 12 днів тому
I really liked the way you describe every concept in detail making it easier to understand and remember. 🫡👌🏿
@darasat 11 днів тому
Doesn't matter if you are begginer or advanced in SQL language, this course is very clear and useful. Thank you!
@vladdata741 11 днів тому
❤
@georgechen676 5 днів тому
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.
@vladdata741 5 днів тому
❤
@rpa_class2020 16 днів тому
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 16 днів тому
That's awesome. Comments like this make my day ❤
@jt3guitar 18 днів тому
oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!
@vladdata741 18 днів тому
Thank you! 😊
@bharathnaveen8870 16 днів тому
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 16 днів тому
You won't be a noob for long! :)
@TheWefikus 15 днів тому
thanks bro - excellent course, exactly what I need for my job!
@sumanuphuket 15 днів тому
Enjoying it, thanks Lots of Love
@giveaway4002 5 днів тому
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 5 днів тому
♥
@giveaway4002 5 днів тому
@@vladdata741 u know, i used oracle autonomous databases, almost eveything was same.
@vladdata741 5 днів тому
@@giveaway4002 Good thing about SQL, it's a universal language :)
@ramesettyramya4528 14 днів тому
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 14 днів тому
Amazing, thank you ❤
@lisdexia1 17 днів тому
I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'
@vladdata741 17 днів тому
Yep, SQL is pretty great
@giveaway4002 6 днів тому
awesome awesome course. i reserved my weekend only for this!
@longrolstral 14 днів тому
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.
@Apenschi 17 днів тому
Good course! Thanks for providing it for free!!!
@nadetdevfullstack7041 18 днів тому
Excellent. Thanks.
@sundayoloruntoba9915 13 днів тому
Great explanation. Thanks
@mannykhan7752 16 днів тому
Thank you thank you thank for this amazing video
@platinum11110 15 днів тому
Great! Thank you!
@jeffjeff4831 18 днів тому
Thanks for this.
@vladdata741 18 днів тому
My pleasure, hope you like it! Vlad
@ministerbo3025 18 днів тому
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 18 днів тому
Nice, keep on learning!
@askholia 18 днів тому
This is exactly what I needed.
@vladdata741 18 днів тому
Awesome to hear!
@datacreative 6 днів тому
Fantastic course!!!
@vladdata741 5 днів тому
♥
@hemanththegamer1901 18 днів тому
❤❤
@TheNoodleMint 18 днів тому
Thank you.
@vladdata741 18 днів тому
My pleasure!
@matteomcguinness3929 18 днів тому
Nice just what I was looking for🎉
@ickebins6948 18 днів тому
Sure...
@jhormanalcantaramedina6392 18 днів тому
X2
@vladdata741 18 днів тому
Awesome, hope you like the course!
@frankzelazko 18 днів тому
Thank you
@vladdata741 18 днів тому
Enjoy the course!
@jhormanalcantaramedina6392 18 днів тому
Thankkk youuu🙌🏻🙏🙏
@vladdata741 18 днів тому
Enjoy!
@keithle_ 13 днів тому
Hope you will open a free data engineering course (from A to Z) Vlad soon since you're DE yourself
@vladdata741 13 днів тому
I'd love to do that 😊
@dennellewalton5843 11 днів тому
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 11 днів тому
Yes, but I see alias as more of a component of select rather than a separate step
@AM2596 3 дні тому
Hello Vlad, just finished the tutorial, really well done with a clear and concise explanation. Could you please help me understand the difference between these two queries in terms of computation and storage, especially when we consider the SQL execution order? SELECT * FROM EMPLOYEE; SELECT * FROM EMPLOYEE LIMIT 10;"
@vladdata741 3 дні тому
Hey there! The LIMIT *typically* does not save computation because it simply cuts rows at the end of the query. (There are some special cases where the engine uses LIMIT to reduce the query e.g. if there are clustering fields but I would not worry about that). In terms of storage, the first query will store all the data from the employee table, while the second query will only store 10 rows.
@AM2596 2 дні тому
Thanks! 😊
@Lucifer0872 18 днів тому
i wan thinking about this today only
@vladdata741 18 днів тому
Nice!
@nocopyrightgameplaystockvi231 18 днів тому
This is a google bigQuery tutorial? Nice thanks x100.
@vladdata741 18 днів тому
Hey there! It's an intro to BigQuery but mainly focused on SQL fundamentals. I chose BigQuery because it's easy to use.
@nocopyrightgameplaystockvi231 18 днів тому
@@vladdata741 thanks. I also wanted to use BigQuery but this looks like a good starter point. Thanks again.
@nikhuge6580 18 днів тому
nice course
@vladdata741 18 днів тому
Thank you, hope it helps!
@deepaksoni5684 6 днів тому
Lucid way of teaching
@vladdata741 5 днів тому
♥
@moisesespiritosanto2195 18 днів тому
Hi, I'm from São Paulo! Yeah excellent! ABRAÇO!
@vladdata741 18 днів тому
Tomara que você curta o curso! Vlad
@lettileite 18 днів тому
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 18 днів тому
@@lettileiteI'm Romanian, sometimes we sound weirdly similar to Portuguese! 😀
@lettileite 18 днів тому
😂 Sorry about that. Just got to the sing in part 😁. Subscribed to your channel. Thank you again 🎉
@DiegoSita 18 днів тому
@@vladdata741 Amazing tutorial, man. Greetings from Brazil.
@PANDURANG99 18 днів тому
is there any certifications?
@vladdata741 18 днів тому
No, unfortunately. But I'll probably do it for my next course!
@PANDURANG99 18 днів тому
@@vladdata741 I hope, that I will complete in 1 month 😅
@apamwamba 17 днів тому
SQL Joins visualizer is cool any link?
@vladdata741 17 днів тому
sql-joins.leopard.in.ua/
@vncoolestguy 18 днів тому
is there a 1080p version ?
@vladdata741 18 днів тому
This is the best I have now. I'm still learning the ropes on video making!
@sarmhn123 18 днів тому
@@vladdata741 This is perfectly fine. Good enough Video & Audio. Thank you.
@bluehat974 18 днів тому
Why not using DuckDB directly in Python or in browser?
@vladdata741 18 днів тому
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 18 днів тому
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 18 днів тому
BigQuery is actually used by companies, 60% of the time.
@ashishsahu8065 10 днів тому
hi can you please share the dataset ?
@vladdata741 10 днів тому
You can find on the course page miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
@Apenschi 17 днів тому
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 17 днів тому
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 17 днів тому
@@vladdata741 Ok. Thanks!
@nguyenchucao8264 4 дні тому
4:24:40
@syedmuhammadahmed885 18 днів тому
do we get a certification if we do on there website or something guys just give a yes or no
@vladdata741 17 днів тому
No certification
@nocopyrightgameplaystockvi231 7 днів тому
Where is the zip file 🌚🙄
@vladdata741 7 днів тому
Hey, it's in the course page linked in the description: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab\
@kopek3105 18 днів тому
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 18 днів тому
You can certainly install it and follow along there. In fact the exercises are in PostgreSQL.
@GoodGameShishou 17 днів тому
But I really like the way he is teaching! Quite clear and understandable for a beginner! 👏🏿👌🏿
@florentd.5817 18 днів тому
Please rename it ! This is a google bigquery tutorial.
@vladdata741 18 днів тому
Hey there. Not really, it was just the easiest way to get you started with SQL. The exercises are on another system (PostgreSQL).
@longrolstral 14 днів тому
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 18 днів тому
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 18 днів тому
Me...
@vladdata741 18 днів тому
Hello. You can find chapter's with timestamps on the description!
@marcbazin6352 18 днів тому
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 18 днів тому
How hard is that for you to check out the chapters?
@TheWefikus 15 днів тому
there's literally chapters in this video bro. settle down
@zamanrashid122 17 днів тому
Nice🎉🎉
ZAXID.NET
Переглядів 582 тис.
Stephen | Data
Переглядів 7 тис.
freeCodeCamp.org
Переглядів 2,1 млн