KZhead

Intuitive SQL For Data Analytics - Tutorial

freeCodeCamp.org
2024 ж. 20 Мам.
109 645 Рет қаралды
Жүктеу

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!

    @vladdata741@vladdata74126 күн бұрын

    • You rock. Thank you, Subscribing right away.

      @teachersdelight6996@teachersdelight699626 күн бұрын

    • @@teachersdelight6996 ❤

      @vladdata741@vladdata74126 күн бұрын

    • Already subscribed sir ..if possible pls power bi 🙏

      @rpa_class2020@rpa_class202024 күн бұрын

    • This is exactly what I needed! Thank you 🙏

      @FM-Vox@FM-Vox24 күн бұрын

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

      @GoodGameShishou@GoodGameShishou22 күн бұрын

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

    @darasat@darasat21 күн бұрын

    • ❤

      @vladdata741@vladdata74121 күн бұрын

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

    @AkshitaDhyani-md1pq@AkshitaDhyani-md1pq5 күн бұрын

    • ❤

      @vladdata741@vladdata7415 күн бұрын

  • 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 🎉

    @rpa_class2020@rpa_class202026 күн бұрын

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

      @vladdata741@vladdata74126 күн бұрын

  • 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

    @bharathnaveen8870@bharathnaveen887026 күн бұрын

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

      @vladdata741@vladdata74126 күн бұрын

  • 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.

    @georgechen676@georgechen67615 күн бұрын

    • ❤

      @vladdata741@vladdata74115 күн бұрын

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

    @jt3guitar@jt3guitar28 күн бұрын

    • Thank you! 😊

      @vladdata741@vladdata74128 күн бұрын

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

    @TheWefikus@TheWefikus25 күн бұрын

  • 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.

    @longrolstral@longrolstral24 күн бұрын

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

    @lisdexia1@lisdexia127 күн бұрын

    • Yep, SQL is pretty great

      @vladdata741@vladdata74127 күн бұрын

  • 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

    @ramesettyramya4528@ramesettyramya452824 күн бұрын

    • Amazing, thank you ❤

      @vladdata741@vladdata74124 күн бұрын

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

    @Apenschi@Apenschi26 күн бұрын

  • Excellent. Thanks.

    @nadetdevfullstack7041@nadetdevfullstack704128 күн бұрын

  • 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.

    @giveaway4002@giveaway400215 күн бұрын

    • ♥

      @vladdata741@vladdata74115 күн бұрын

    • @@vladdata741 u know, i used oracle autonomous databases, almost eveything was same.

      @giveaway4002@giveaway400215 күн бұрын

    • ​@@giveaway4002 Good thing about SQL, it's a universal language :)

      @vladdata741@vladdata74115 күн бұрын

  • Great explanation. Thanks

    @sundayoloruntoba9915@sundayoloruntoba991523 күн бұрын

  • Thank you thank you thank for this amazing video

    @mannykhan7752@mannykhan775226 күн бұрын

  • Great! Thank you!

    @platinum11110@platinum1111025 күн бұрын

  • Thanks for this.

    @jeffjeff4831@jeffjeff483128 күн бұрын

    • My pleasure, hope you like it! Vlad

      @vladdata741@vladdata74128 күн бұрын

  • Enjoying it, thanks Lots of Love

    @sumanuphuket@sumanuphuket25 күн бұрын

  • 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.🌴

    @ministerbo3025@ministerbo302528 күн бұрын

    • Nice, keep on learning!

      @vladdata741@vladdata74128 күн бұрын

  • Fantastic course!!!

    @datacreative@datacreative15 күн бұрын

    • ♥

      @vladdata741@vladdata74115 күн бұрын

  • Thanks, great course

    @foland2619@foland26197 күн бұрын

    • ❤

      @vladdata741@vladdata7415 күн бұрын

  • 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;"

    @AM2596@AM259613 күн бұрын

    • 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.

      @vladdata741@vladdata74112 күн бұрын

    • Thanks! 😊

      @AM2596@AM259612 күн бұрын

  • Thank you.

    @TheNoodleMint@TheNoodleMint28 күн бұрын

    • My pleasure!

      @vladdata741@vladdata74128 күн бұрын

  • Thank you

    @frankzelazko@frankzelazko28 күн бұрын

    • Enjoy the course!

      @vladdata741@vladdata74128 күн бұрын

  • ❤❤

    @hemanththegamer1901@hemanththegamer190128 күн бұрын

  • This is exactly what I needed.

    @askholia@askholia28 күн бұрын

    • Awesome to hear!

      @vladdata741@vladdata74128 күн бұрын

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

    @giveaway4002@giveaway400216 күн бұрын

  • 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?

    @dennellewalton5843@dennellewalton584321 күн бұрын

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

      @vladdata741@vladdata74121 күн бұрын

  • Thankkk youuu🙌🏻🙏🙏

    @jhormanalcantaramedina6392@jhormanalcantaramedina639228 күн бұрын

    • Enjoy!

      @vladdata741@vladdata74128 күн бұрын

  • Lucid way of teaching

    @deepaksoni5684@deepaksoni568415 күн бұрын

    • ♥

      @vladdata741@vladdata74115 күн бұрын

  • nice course

    @nikhuge6580@nikhuge658028 күн бұрын

    • Thank you, hope it helps!

      @vladdata741@vladdata74128 күн бұрын

  • i wan thinking about this today only

    @Lucifer0872@Lucifer087228 күн бұрын

    • Nice!

      @vladdata741@vladdata74128 күн бұрын

  • Nice just what I was looking for🎉

    @matteomcguinness3929@matteomcguinness392928 күн бұрын

    • Sure...

      @ickebins6948@ickebins694828 күн бұрын

    • X2

      @jhormanalcantaramedina6392@jhormanalcantaramedina639228 күн бұрын

    • Awesome, hope you like the course!

      @vladdata741@vladdata74128 күн бұрын

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

    @keithle_@keithle_23 күн бұрын

    • I'd love to do that 😊

      @vladdata741@vladdata74123 күн бұрын

  • This is a google bigQuery tutorial? Nice thanks x100.

    @nocopyrightgameplaystockvi231@nocopyrightgameplaystockvi23127 күн бұрын

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

      @vladdata741@vladdata74127 күн бұрын

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

      @nocopyrightgameplaystockvi231@nocopyrightgameplaystockvi23127 күн бұрын

  • @vladdata741 Will you make more advanced courses?

    @nebojsaknezevic6053@nebojsaknezevic60534 күн бұрын

    • Working on it. Subscribe to my channel or LinkedIn for updates.

      @vladdata741@vladdata7414 күн бұрын

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

    @moisesespiritosanto2195@moisesespiritosanto219528 күн бұрын

    • Tomara que você curta o curso! Vlad

      @vladdata741@vladdata74128 күн бұрын

    • 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 ❤🎉❤🎉

      @lettileite@lettileite28 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

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

      @lettileite@lettileite28 күн бұрын

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

      @DiegoSita@DiegoSita28 күн бұрын

  • Can you make an end to end data analysis bootcamp intended for beginners?

    @MHb789@MHb7896 күн бұрын

    • I'd love to!

      @vladdata741@vladdata7415 күн бұрын

  • SQL Joins visualizer is cool any link?

    @apamwamba@apamwamba27 күн бұрын

    • sql-joins.leopard.in.ua/

      @vladdata741@vladdata74127 күн бұрын

  • is there any certifications?

    @PANDURANG99@PANDURANG9928 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

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

      @PANDURANG99@PANDURANG9928 күн бұрын

  • is there a 1080p version ?

    @vncoolestguy@vncoolestguy28 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

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

      @sarmhn123@sarmhn12328 күн бұрын

  • Why not using DuckDB directly in Python or in browser?

    @bluehat974@bluehat97428 күн бұрын

    • 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@vladdata74128 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

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

      @nocopyrightgameplaystockvi231@nocopyrightgameplaystockvi23127 күн бұрын

  • 7:34:05

    @nguyenchucao8264@nguyenchucao826414 күн бұрын

  • 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!

    @Apenschi@Apenschi26 күн бұрын

    • 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@vladdata74126 күн бұрын

    • @@vladdata741 Ok. Thanks!

      @Apenschi@Apenschi26 күн бұрын

  • hi can you please share the dataset ?

    @ashishsahu8065@ashishsahu806520 күн бұрын

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

      @vladdata741@vladdata74120 күн бұрын

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

    @syedmuhammadahmed885@syedmuhammadahmed88527 күн бұрын

    • No certification

      @vladdata741@vladdata74127 күн бұрын

  • Where are the linked files?

    @CeeRiley-xc5dv@CeeRiley-xc5dv2 күн бұрын

    • miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab

      @vladdata741@vladdata741Күн бұрын

  • Where is the zip file 🌚🙄

    @nocopyrightgameplaystockvi231@nocopyrightgameplaystockvi23117 күн бұрын

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

      @vladdata741@vladdata74117 күн бұрын

  • 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.

    @kopek3105@kopek310528 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

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

      @GoodGameShishou@GoodGameShishou26 күн бұрын

  • Please rename it ! This is a google bigquery tutorial.

    @florentd.5817@florentd.581728 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

    • 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?

      @longrolstral@longrolstral24 күн бұрын

  • 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.

    @Artopiumcom@Artopiumcom28 күн бұрын

    • Me...

      @DiegoSita@DiegoSita28 күн бұрын

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

      @vladdata741@vladdata74128 күн бұрын

    • 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.

      @marcbazin6352@marcbazin635228 күн бұрын

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

      @nocopyrightgameplaystockvi231@nocopyrightgameplaystockvi23127 күн бұрын

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

      @TheWefikus@TheWefikus25 күн бұрын

  • Nice🎉🎉

    @zamanrashid122@zamanrashid12227 күн бұрын
KZhead