Introduction
  • Introduction
  • Creating Google Account
  • Signing up for 12 Month Free Trial of Google Cloud Platform and Google Big Query
  • Getting Access to Big Query Public Data Sets and Pinning them Quick Access
  • Introduction Big Query UI and Functionality
  • How Big Query Charges Per Query and How to Make Your Credit Last A Long Time
Counting Records, Returning Distinct Records, and Ordering Records
  • Intro to Count and Count Distinct
  • Count and Count Distinct with Null Records
  • Quiz 1: Count and Count Distinct Quiz
  • Quiz 1 Solutions
  • Returning Distinct Records and Ordering Records
  • Quiz 2: Returning Distinct Records and Ordering With a Single Column
  • Quiz 2 Solutions
  • Returning DIstinct Records and Order with Multiple Columns
Where Clause
  • Introduction to Where Clause
  • Where Clauses On Numerical Columns
  • Where Clause On String (Text) Columns
  • Quiz 3: Where Clause Quiz With Integer and String Columns
  • Quiz 3 Solutions
  • Where Clause On TIMESTAMP Columns And Some Useful Extract Functions
  • Quiz 4: Where Clause Quiz With Timestamp Column
  • Quiz 4: Solution
  • Where Clause: IS NULL & IS NOT NULL
Group By And Aggregate Functions
  • Intro to Group By, Aggregation, and Google's Data Studio Visualization Tool
  • Group By And Aggregation Functions: MAX MIN SUM COUNT AVG
  • Group By Example: COUNT with WHERE Clause and Visualization In Data Studio
  • Group By Example: SUM and Visualization In Data Studio
  • Group By Example: MAX MIN AVG with WHERE and Visualization In Data Studio
  • Group BY Example: COUNT with HAVING and Visualization In Data Studio
  • Quiz 5: Group By And Aggregate Functions Quiz
  • Quiz 5 Solutions
  • Grouping By Multiple Columns Explanation
  • Grouping By Multiple Columns Example
Project 1: New York Citi Bike Dashboard
  • Project Intro
  • Quick Intro to Google Data Studio Reporting and Data Sources
  • Prepare Data Set Question: NY Citi Bike By Day
  • Prepare Data Set Answer: NY Citi Bike By Day
  • Prepare Data Set Data Studio: NY Citi Bike By Day
  • Prepare Remaining Three Data Sets In Data Studio: NY Citi Bike Project
  • Create Dashboard in Data Studio
Joins (Joining Multiple Tables Together)
  • Intro to Joins
  • Left Join Example Big Query Census Data
  • Joining Tables with Duplicate Records Leads to Duplicate Results Example
  • Trimming and Lowering When Joining on Columns of Type String
  • Joins & Where Clause & Group By and Aggregate: Putting it all together Examples
  • Joining On Multiple Columns With Multiple Tables (More than 2)
Census International Data Dashboard Project
  • Project Intro
Big Query Standard SQL Functions
  • Intro to Big Query Standard SQL Functions
  • Examples With Cast Function
  • Examples with Mathematical Functions
  • Examples with String Functions
  • Examples with Date and Timestamp Functions
  • Practice Questions for SQL Functions Section
  • Solutions for SQL Functions Questions
Case Statements
  • Intro to Case Statement Syntax and Example
  • Case Statement Examples
Next Steps: Start Your Own Projects!
  • Start Your Own Projects!