Applied SQL For Data Analytics / Data Science With BigQuery

Go from SQL Zero to Hero and develop rich mental models for writing sophisticated SQL statements & solving problems.

Created by: Jeff James
Senior Data Scientist With 10+ Years of Applied Experience

What Will I Learn?

• SQL 101: The basics (SELECT, WHERE, HAVING, JOIN's, dealing with dates and timestamps)
• [NEW] Google Analytics 4 and BigQuery - Master the data model and attribution
• SQL 202: Date Handling, CASE statements, Common Table Expressions, Subqueries, Correlated Subqueries
• Develop clear models of translating business requirements to SQL
• Master Window / Analytic Functions, which are the power tools of modern data-science SQL
• 100% of videos are code along and provide numerous points to stop and "solve it" before me.

Requirements

• Be able to write very basic SQL statements or at least understand what rows and columns are
• Have a google account since we use BigQuery

Target audience

• People with at least some SQL experience (you can write simple SELECT statements)
• Aspiring data scientists or data scientists who don't leverage SQL
• Data analysts
• Product managers who want to get better with DIY analysis.
• Developers who are interested in SQL!
• People interested in BigQuery that already know some SQL.
• Analysts needing to ramp up on GA4 BigQuery