Channel BannerChannel Banner
mXW7JHJM34kmXW7JHJM34k

Intuitive SQL For Data Analytics - Tutorial

393,724
Socialcounts.OrgEnter Fullscreen (f)
10,539
likes
330
comments
daily view 0
monthly view 0

Share

Live Analytics

Comments 0

Intuitive SQL For Data Analytics - Tutorial Analytics Table

Income Estimates for Intuitive SQL For Data Analytics - Tutorial

Based on this YouTube video's total view count of 393K views and industry-standard rates, the estimated total earning is $276 - $787 through ad revenue. Historical data is not yet available to calculate daily, weekly, or monthly averages.

About Intuitive SQL For Data Analytics - Tutorial

Explore Intuitive SQL For Data Analytics - Tutorial with 393,724 views, 10,539 likes, and 330 comments. Experience the impact of this video content that has captured audience attention.

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 @vladg-yt ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ 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

About YouTube Real-Time View Count

With SocialCounts.org’s view counter, track your YouTube video’s live view count and YouTube likes count in real time with fast, reliable updates.

Watch every YouTube video live view count rise with our real-time YouTube views tracker—built for accuracy and minimal delay.

Follow YouTube real time views as they happen, using our dedicated view counter for YouTube videos.

Get up-to-date live view count on YouTube and see real-time growth with SocialCounts.org’s smart tracking tools.

Embed Widget

Parameters:

  • fullscreen=true - Fullscreen counter
  • graph=true - Live graph chart
  • counter=0/1/2 - Select counter (0=likes, 1=views, 2=comments)
URL

Click to copy the embed URL to your clipboard