Getting Started with BigQuery by Coding is for Losers
Get access for free

Getting Started with BigQuery

Making the jump from spreadsheets to databases, one small SQL query at a time.
Get access for free

What's included?

Video Icon 28 videos File Icon 6 files Text Icon 7 text files

Contents

Getting Acquainted
1) All the links: datasets, templates and tools
Get access
2) Join us on Slack
Get access
3) How we can help
Get access
Why Work in BigQuery?
How I learned SQL
3 mins
Get access
Why do we recommend BigQuery?
3 mins
Get access
How does BigQuery fit into the rest of the Google stack?
2 mins
Get access
How we build marketing data pipelines in BigQuery
4 mins
Get access
What all do you really need to learn?
5 mins
Get access
What does it cost?
2 mins
Get access
BigQuery SQL - Getting Started
Creating a Project + Access the GA Sample Dataset
6 mins
Get access
Writing your first SELECT query
6 mins
Get access
Filtering data with WHERE
5 mins
Get access
Ordering results with ORDER BY
Get access
Calculating aggregate totals with GROUP BY
5 mins
Get access
Calculating columns (SUM, COUNT, etc) within queries
6 mins
Get access
Aggregating by day, week and month
10 mins
Get access
Nesting queries
Get access
Unnesting RECORD arrays
7 mins
Get access
Quiz 1
Get access
Bigquery SQL - Diving Deeper
Joining Tables
11 mins
Get access
Using WITH for cleaner Joins
7 mins
Get access
Window (analytic) functions
8 mins
Get access
Deduping query results
6 mins
Get access
Quiz 2
Get access
Getting Data Into BigQuery
Push from Google Sheets to BigQuery
Get access
Push from FB Ads (or any platform) to BigQuery
4 mins
Get access
Reviewing Stitch vs Supermetrics for BigQuery
Get access
Scheduling BQ queries with DBT
Intro to DBT for SQL modeling
4 mins
Get access
Creating your DBT project
8 mins
Get access
Connect your BigQuery database to DBT
8 mins
Get access
Writing basic SQL queries in DBT
9 mins
Get access
The magic of DBT's {{ref}}
6 mins
Get access
Debugging SQL models with DBT
7 mins
Get access
Pro tip: standardizing URL structure with DBT
3 mins
Get access
Pro tip: using DBT macros
6 mins
Get access
Building your BigQuery pipeline
Hire CIFL to build your data pipeline
Get access
Learn to build your own data pipeline
4 mins
Get access
Execute common marketing "Recipes" with Query.recipes
2 mins
Get access
Office Hours
How Google Cloud Functions et al fit with BigQuery
Get access
BigQuery Partitioning and Clustering, Explained
Get access
Working with JSON data in BigQuery
Get access
Upcoming!
User-defined functions
Get access
Partitioning with DBT
Get access