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