Intuitive SQL For Data Analytics - Tutorial
Рет қаралды 105,235
Күн бұрын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 21 күн бұрын
Hope you enjoy the course. Subscribe to my channel and let me know what I should cover next!
@teachersdelight6996 21 күн бұрын
You rock. Thank you, Subscribing right away.
@vladdata741 21 күн бұрын
@@teachersdelight6996 ❤
@rpa_class2020 20 күн бұрын
Already subscribed sir ..if possible pls power bi 🙏
@FM-Vox 20 күн бұрын
This is exactly what I needed! Thank you 🙏
@GoodGameShishou 18 күн бұрын
I really liked the way you describe every concept in detail making it easier to understand and remember. 🫡👌🏿
@darasat 16 күн бұрын
Doesn't matter if you are begginer or advanced in SQL language, this course is very clear and useful. Thank you!
@vladdata741 16 күн бұрын
❤
@AkshitaDhyani-md1pq Күн бұрын
This is the best tutorial ever. I was not able to stop myself from commenting. Thank you so much :)
@vladdata741 23 сағат бұрын
❤
@rpa_class2020 21 күн бұрын
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 21 күн бұрын
That's awesome. Comments like this make my day ❤
@jt3guitar 23 күн бұрын
oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!
@vladdata741 23 күн бұрын
Thank you! 😊
@bharathnaveen8870 22 күн бұрын
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 21 күн бұрын
You won't be a noob for long! :)
@ramesettyramya4528 20 күн бұрын
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 19 күн бұрын
Amazing, thank you ❤
@georgechen676 10 күн бұрын
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 10 күн бұрын
❤
@lisdexia1 22 күн бұрын
I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'
@vladdata741 22 күн бұрын
Yep, SQL is pretty great
@TheWefikus 20 күн бұрын
thanks bro - excellent course, exactly what I need for my job!
@longrolstral 20 күн бұрын
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.
@giveaway4002 11 күн бұрын
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 11 күн бұрын
♥
@giveaway4002 10 күн бұрын
@@vladdata741 u know, i used oracle autonomous databases, almost eveything was same.
@vladdata741 10 күн бұрын
@@giveaway4002 Good thing about SQL, it's a universal language :)
@nadetdevfullstack7041 23 күн бұрын
Excellent. Thanks.
@jeffjeff4831 24 күн бұрын
Thanks for this.
@vladdata741 23 күн бұрын
My pleasure, hope you like it! Vlad
@Apenschi 22 күн бұрын
Good course! Thanks for providing it for free!!!
@mannykhan7752 22 күн бұрын
Thank you thank you thank for this amazing video
@platinum11110 20 күн бұрын
Great! Thank you!
@sundayoloruntoba9915 18 күн бұрын
Great explanation. Thanks
@askholia 24 күн бұрын
This is exactly what I needed.
@vladdata741 23 күн бұрын
Awesome to hear!
@ministerbo3025 24 күн бұрын
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 23 күн бұрын
Nice, keep on learning!
@hemanththegamer1901 24 күн бұрын
❤❤
@sumanuphuket 20 күн бұрын
Enjoying it, thanks Lots of Love
@TheNoodleMint 24 күн бұрын
Thank you.
@vladdata741 23 күн бұрын
My pleasure!
@frankzelazko 24 күн бұрын
Thank you
@vladdata741 23 күн бұрын
Enjoy the course!
@foland2619 2 күн бұрын
Thanks, great course
@vladdata741 23 сағат бұрын
❤
@datacreative 11 күн бұрын
Fantastic course!!!
@vladdata741 11 күн бұрын
♥
@jhormanalcantaramedina6392 23 күн бұрын
Thankkk youuu🙌🏻🙏🙏
@vladdata741 23 күн бұрын
Enjoy!
@matteomcguinness3929 24 күн бұрын
Nice just what I was looking for🎉
@ickebins6948 24 күн бұрын
Sure...
@jhormanalcantaramedina6392 23 күн бұрын
X2
@vladdata741 23 күн бұрын
Awesome, hope you like the course!
@Lucifer0872 24 күн бұрын
i wan thinking about this today only
@vladdata741 23 күн бұрын
Nice!
@dennellewalton5843 17 күн бұрын
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 17 күн бұрын
Yes, but I see alias as more of a component of select rather than a separate step
@nocopyrightgameplaystockvi231 23 күн бұрын
This is a google bigQuery tutorial? Nice thanks x100.
@vladdata741 23 күн бұрын
Hey there! It's an intro to BigQuery but mainly focused on SQL fundamentals. I chose BigQuery because it's easy to use.
@nocopyrightgameplaystockvi231 23 күн бұрын
@@vladdata741 thanks. I also wanted to use BigQuery but this looks like a good starter point. Thanks again.
@nebojsaknezevic6053 7 сағат бұрын
@vladdata741 Will you make more advanced courses?
@AM2596 9 күн бұрын
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 8 күн бұрын
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 8 күн бұрын
Thanks! 😊
@nikhuge6580 24 күн бұрын
nice course
@vladdata741 23 күн бұрын
Thank you, hope it helps!
@vncoolestguy 24 күн бұрын
is there a 1080p version ?
@vladdata741 23 күн бұрын
This is the best I have now. I'm still learning the ropes on video making!
@sarmhn123 23 күн бұрын
@@vladdata741 This is perfectly fine. Good enough Video & Audio. Thank you.
@PANDURANG99 24 күн бұрын
is there any certifications?
@vladdata741 23 күн бұрын
No, unfortunately. But I'll probably do it for my next course!
@PANDURANG99 23 күн бұрын
@@vladdata741 I hope, that I will complete in 1 month 😅
@apamwamba 22 күн бұрын
SQL Joins visualizer is cool any link?
@vladdata741 22 күн бұрын
sql-joins.leopard.in.ua/
@moisesespiritosanto2195 24 күн бұрын
Hi, I'm from São Paulo! Yeah excellent! ABRAÇO!
@vladdata741 23 күн бұрын
Tomara que você curta o curso! Vlad
@lettileite 23 күн бұрын
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 23 күн бұрын
@@lettileiteI'm Romanian, sometimes we sound weirdly similar to Portuguese! 😀
@lettileite 23 күн бұрын
😂 Sorry about that. Just got to the sing in part 😁. Subscribed to your channel. Thank you again 🎉
@DiegoSita 23 күн бұрын
@@vladdata741 Amazing tutorial, man. Greetings from Brazil.
@MHb789 Күн бұрын
Can you make an end to end data analysis bootcamp intended for beginners?
@vladdata741 23 сағат бұрын
I'd love to!
@bluehat974 23 күн бұрын
Why not using DuckDB directly in Python or in browser?
@vladdata741 23 күн бұрын
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 23 күн бұрын
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 23 күн бұрын
BigQuery is actually used by companies, 60% of the time.
@keithle_ 19 күн бұрын
Hope you will open a free data engineering course (from A to Z) Vlad soon since you're DE yourself
@vladdata741 19 күн бұрын
I'd love to do that 😊
@ashishsahu8065 16 күн бұрын
hi can you please share the dataset ?
@vladdata741 15 күн бұрын
You can find on the course page miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
@giveaway4002 12 күн бұрын
awesome awesome course. i reserved my weekend only for this!
@nguyenchucao8264 9 күн бұрын
7:34:05
@syedmuhammadahmed885 23 күн бұрын
do we get a certification if we do on there website or something guys just give a yes or no
@vladdata741 22 күн бұрын
No certification
@deepaksoni5684 11 күн бұрын
Lucid way of teaching
@vladdata741 11 күн бұрын
♥
@Apenschi 22 күн бұрын
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 22 күн бұрын
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 22 күн бұрын
@@vladdata741 Ok. Thanks!
@nocopyrightgameplaystockvi231 13 күн бұрын
Where is the zip file 🌚🙄
@vladdata741 13 күн бұрын
Hey, it's in the course page linked in the description: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab\
@kopek3105 23 күн бұрын
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 23 күн бұрын
You can certainly install it and follow along there. In fact the exercises are in PostgreSQL.
@GoodGameShishou 22 күн бұрын
But I really like the way he is teaching! Quite clear and understandable for a beginner! 👏🏿👌🏿
@florentd.5817 23 күн бұрын
Please rename it ! This is a google bigquery tutorial.
@vladdata741 23 күн бұрын
Hey there. Not really, it was just the easiest way to get you started with SQL. The exercises are on another system (PostgreSQL).
@longrolstral 20 күн бұрын
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 23 күн бұрын
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 23 күн бұрын
Me...
@vladdata741 23 күн бұрын
Hello. You can find chapter's with timestamps on the description!
@marcbazin6352 23 күн бұрын
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 23 күн бұрын
How hard is that for you to check out the chapters?
@TheWefikus 20 күн бұрын
there's literally chapters in this video bro. settle down
@zamanrashid122 22 күн бұрын
Nice🎉🎉
Unorthodox Change
Рет қаралды 178 М.
techTFQ
Рет қаралды 96 М.
techTFQ
Рет қаралды 769 М.