Intuitive SQL For Data Analytics - Tutorial

Curriculum for the course 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: https://miniature-icon-2cc.notion.site/Intuitive-SQL-For-Analytics-65241f69e06446d5bb0a7de272fb5dab 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: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news

Watch Online Full Course: Intuitive SQL For Data Analytics - Tutorial

Click Here to watch on Youtube: Intuitive SQL For Data Analytics - Tutorial

This video is first published on youtube via freecodecamp. If Video does not appear here, you can watch this on Youtube always.

Udemy Intuitive SQL For Data Analytics - Tutorial courses free download, Plurasight Intuitive SQL For Data Analytics - Tutorial courses free download, Linda Intuitive SQL For Data Analytics - Tutorial courses free download, Coursera Intuitive SQL For Data Analytics - Tutorial course download free, Brad Hussey udemy course free, free programming full course download, full course with project files, Download full project free, College major project download, CS major project idea, EC major project idea, clone projects download free