Intuitive SQL For Data Analytics - Tutorial
Вставка
- Опубліковано 13 тра 2024
- 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
Hope you enjoy the course. Subscribe to my channel and let me know what I should cover next!
You rock. Thank you, Subscribing right away.
@@teachersdelight6996 ❤
Already subscribed sir ..if possible pls power bi 🙏
This is exactly what I needed! Thank you 🙏
I really liked the way you describe every concept in detail making it easier to understand and remember. 🫡👌🏿
Doesn't matter if you are begginer or advanced in SQL language, this course is very clear and useful.
Thank you!
❤
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 🎉
That's awesome. Comments like this make my day ❤
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.
❤
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
You won't be a noob for long! :)
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
Amazing, thank you ❤
oh wow, some teachers are just so clear.. i was thinking about brushing up and this magically appeared! Vlad you rock!
Thank you! 😊
thanks bro - excellent course, exactly what I need for my job!
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 u know, i used oracle autonomous databases, almost eveything was same.
@@giveaway4002 Good thing about SQL, it's a universal language :)
Enjoying it, thanks
Lots of Love
awesome awesome course. i reserved my weekend only for this!
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.
I adore SQL. posing simple queries to get direct responses. Select * where [Result] = 'Happyness'
Yep, SQL is pretty great
Excellent. Thanks.
Good course! Thanks for providing it for free!!!
Great explanation. Thanks
Thank you thank you thank for this amazing video
Great! Thank you!
Thanks, great course
Thanks for this.
My pleasure, hope you like it! Vlad
Fantastic course!!!
♥
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.🌴
Nice, keep on learning!
This is exactly what I needed.
Awesome to hear!
Thank you.
My pleasure!
Thankkk youuu🙌🏻🙏🙏
Enjoy!
❤❤
Thank you
Enjoy the course!
Nice just what I was looking for🎉
Sure...
X2
Awesome, hope you like the course!
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;"
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.
Thanks! 😊
This is a google bigQuery tutorial? Nice thanks x100.
Hey there! It's an intro to BigQuery but mainly focused on SQL fundamentals. I chose BigQuery because it's easy to use.
@@vladdata741 thanks. I also wanted to use BigQuery but this looks like a good starter point. Thanks again.
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?
Yes, but I see alias as more of a component of select rather than a separate step
nice course
Thank you, hope it helps!
i wan thinking about this today only
Nice!
Hope you will open a free data engineering course (from A to Z) Vlad soon since you're DE yourself
I'd love to do that 😊
Lucid way of teaching
♥
Hi, I'm from São Paulo! Yeah excellent! ABRAÇO!
Tomara que você curta o curso! Vlad
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 ❤🎉❤🎉
@@lettileiteI'm Romanian, sometimes we sound weirdly similar to Portuguese! 😀
😂 Sorry about that. Just got to the sing in part 😁. Subscribed to your channel. Thank you again 🎉
@@vladdata741 Amazing tutorial, man. Greetings from Brazil.
SQL Joins visualizer is cool any link?
sql-joins.leopard.in.ua/
is there any certifications?
No, unfortunately. But I'll probably do it for my next course!
@@vladdata741 I hope, that I will complete in 1 month 😅
is there a 1080p version ?
This is the best I have now. I'm still learning the ropes on video making!
@@vladdata741 This is perfectly fine. Good enough Video & Audio. Thank you.
Why not using DuckDB directly in Python or in browser?
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.
And if you want to work in analytics, having knowledge of a data warehouse like BigQuery is a bonus. Two birds with one stone.
BigQuery is actually used by companies, 60% of the time.
7:34:05
hi can you please share the dataset ?
You can find on the course page miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab
do we get a certification if we do on there website or something guys just give a yes or no
No certification
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!
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.
@@vladdata741 Ok. Thanks!
Where is the zip file 🌚🙄
Hey, it's in the course page linked in the description: miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab\
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.
You can certainly install it and follow along there. In fact the exercises are in PostgreSQL.
But I really like the way he is teaching! Quite clear and understandable for a beginner! 👏🏿👌🏿
Please rename it ! This is a google bigquery tutorial.
Hey there. Not really, it was just the easiest way to get you started with SQL. The exercises are on another system (PostgreSQL).
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?
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.
Me...
Hello. You can find chapter's with timestamps on the description!
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.
How hard is that for you to check out the chapters?
there's literally chapters in this video bro. settle down
Nice🎉🎉