Course Outline on Google’s BigQuery for Data Science

Course Outline on Google’s BigQuery for Data Science

This Beginners-Intermediate course is designed for SQL beginners, 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.

We shall be using practical use cases and projects as a learning tool. Most of the sources of the use cases shall be from Google’s KAggle.

Learning Outcome:

By the end of this course, learners mat be expected to know the following:

• SQL basics:
  • SELECT,
  • WHERE,
  • HAVING,
  • JOIN's,
  • dealing with dates and timestamps
• SQL intermediate:
  • Date Handling,
  • CASE statements,
  • Common Table Expressions,
  • Subqueries,
  • Correlated Subqueries
• Develop clear models of translating business requirements to SQL
• Master Window / Analytic Functions for modern data-science SQL

Prerequisites:

• 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
• Fluent in English
• Access to two screens
• Experience in using the internet for file handling

Course Content

1. Module 1
   1. Overview of Tables, Columns and Writing Queries
   2. Anatomy of a SELECT statement
   3. Hands on use case
   4. GROUPING and the HAVING
   5. Quiz
2. Module 2
   1. Using CASE Statements to Classify Stack Overflow Questions
   2. Solution - Using Question Titles And Tags in our CASE statement
   3. Solution - Programming Language Growth Using Stack Overflow Data
   4. A bit of python
3. Module 3
   1. INNER, LEFT, RIGHT, OUTER JOIN's - crash course
   2. JOIN'ing Order and Customers - How to identify JOIN column candidates
   3. Breaking Down ROW_NUMBER() in Using order_items
   4. Full Outer Join
   5. Complex Joins
   6. Assessment
4. Module 4
   1. Case Study
   2. UNNEST Intro, Running Totals w/Correlated Subqueries
   3. Moving Averages
   4. LAG using a correlated subquery
5. FINAL ASSESSMENT