Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
13 Hour(s) 1 Minute(s)
Language
English
Taught by
Jeff James
Rating
1 views
Course Overview
Go from SQL Zero to Hero and develop rich mental models for writing sophisticated SQL statements & solving problems.
Woah, another SQL course? Yes! Here's why this one is different.
We write 100% of the code together and I explain everything precisely and with abundant context. I have over a decade of industry experience over have taught this at the university level.
100% we do is application based. I rarely use toy data to illustrate points, unless it's more illustrative. Hopefully you'll learn much more than SQL throughout the course.
ZERO SET-UP. As long as you have a Google Account, you can login to BigQuery and get started immediately. No headaches configuring databases locally. You'll be up and running in under 3 minutes.
Spaced repetition to develop mastery. This is NOT a table of contents course. This is NOT a list of disparate exercises. Everything is connected. Concepts are revisited throughout the course so you can see them from different angles and maximize understanding.
Can you solve it? I provide tons of mini-challenges throughout the lecture material. The lecture material is basically us solving the problems. No time wasted on theory without context.
I'm not boring. I am human. I do make mistakes. I dwell on them so you can master the debugging process. Debugging is much more important than writing code.
Course Content
- 13 section(s)
- 63 lecture(s)
- Section 1 Should you take this course?
- Section 2 BigQuery Set-up - Writing Our First Queries!
- Section 3 The CASE Statement - Quick Case study using StackOverflow Questions
- Section 4 Join me and learn to JOIN data + Window/Analytic Functions
- Section 5 Other JOIN's You Might Need
- Section 6 JOIN's Mini Project - Hourly Revenue Trends
- Section 7 UNNEST, Correlated Subqueries
- Section 8 Stock Price Project
- Section 9 More Complex JOIN's and PARTITION'ing
- Section 10 Stack Overflow MiniProject - Top Phrases used in Title by Tag
- Section 11 More Text Processing With Regular Expressions
- Section 12 Google Analytics Attribution Analysis
- Section 13 NEW for 2024 - GA4 w/BigQuery - Data Model, Event Params and Attribution Part 1
What You’ll 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.
Reviews
-
KKandula Venkata Tarun
This is one the best sql course you should take once you have basic sql knowledge
-
SSamsuddin Midday
The instructor takes us though the course quite organically, I hate when people teach theory first and then practical. Thankfully he doesn't do that. He raises questions in us through engaging practically directly and then when we start wondering how, the theory comes of it's own.
-
FFlorin Andris
I liked that it was not just simple boring stuff, got more into more and more complex syntax and all, but a bit boring (not just for this course but in general) is that some of the most important stuff is missed: how to create a table and consider best practices for data types, primary keys and foreign keys and indexes and clustering, or partitioning for performance and cost purposes; how to check the correlation between tables within a database based on primary and foreign keys; maybe trying to apply that analysis on something more concrete for business purposes then just some abstract exercises
-
RRamcharan Nellutla
I have no knowledge about the sql before starting this course now I am able to write and correct the quarries on my own thank you for this opportunity to learn.
