Intuitive SQL For Data Analytics - Tutorial

Learn SQL for analytics. Learn some nan mentation and nan believe truthful you tin confidently lick difficult SQL challenges connected your own. No erstwhile acquisition required and you'll do everything successful your browser utilizing 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 debar Google Cloud charges ⌨️ (00:22:11) Introduction to our data ⌨️ (00:23:16) How information is organized successful BigQuery ⌨️ (00:26:53) Loading our information successful 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 3 orders of SQL operations ⌨️ (01:00:05) The logical bid of SQL operations ⌨️ (01:03:28) Introduction to basics ⌨️ (01:04:10) SELECT and FROM ⌨️ (01:08:22) Transform columns pinch SELECT ⌨️ (01:19:32) The bid 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 array expressions 1 ⌨️ (03:48:12) Common array expressions 2 ⌨️ (03:53:08) Common array 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 codification for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles connected programming: https://freecodecamp.org/news