SQL for Data Analysis in Google BigQuery

Topic outline

• Select topic Introduction

  Introduction

  Collapse all Expand all
  • Select activity 0. Course Instructors

    

    0. Course Instructors Page

    Completion

    Students must

    

    View
  • Select activity 1. Course Introduction

    

    1. Course Introduction Page

    Completion

    Students must

    

    View
  • Select activity 2. What is Google BigQuery?

    

    2. What is Google BigQuery? Page

    Completion

    Students must

    

    View
  • Select activity 3. How To Access Data?

    

    3. How To Access Data? Page

    Completion

    Students must

    

    View
• Select topic Dataset #1. Superstore

  Dataset #1. Superstore
  • Select activity 4. Working With a Single Table: Superstore Dataset

    

    4. Working With a Single Table: Superstore Dataset Page

    Completion

    Students must

    

    View
  • Select activity 5. Counting the Number of Rows and Columns

    

    5. Counting the Number of Rows and Columns Page

    Completion

    Students must

    

    View
  • Select activity 6. Basic Column Analysis

    

    6. Basic Column Analysis Page

    Completion

    Students must

    

    View
  • Select activity 7. Basic Data Quality Checks

    

    7. Basic Data Quality Checks Page

    Completion

    Students must

    

    View
  • Select activity 8. Basic Sales Analysis

    

    8. Basic Sales Analysis Page

    Completion

    Students must

    

    View
  • Select activity 9. Working With Dates

    

    9. Working With Dates Page

    Completion

    Students must

    

    View
  • Select activity 10. Introduction to Sub-Queries

    

    10. Introduction to Sub-Queries Page

    Completion

    Students must

    

    View
  • Select activity 11. Intermediate Sales Analysis

    

    11. Intermediate Sales Analysis Page

    Completion

    Students must

    

    View
  • Select activity 12. Introduction to Window Functions

    

    12. Introduction to Window Functions Page

    Completion

    Students must

    

    View
  • Select activity 13. Advanced Sales Analysis

    

    13. Advanced Sales Analysis Page

    Completion

    Students must

    

    View
• Select topic Dataset #2. Bookstore

  Dataset #2. Bookstore
  • Select activity 14. Working with multiple tables: Bookstore dataset

    

    14. Working with multiple tables: Bookstore dataset Page

    Completion

    Students must

    

    View
  • Select activity 15. JOIN functions: Basic tasks

    

    15. JOIN functions: Basic tasks Page

    Completion

    Students must

    

    View
  • Select activity 16. JOIN functions: Intermediate tasks

    

    16. JOIN functions: Intermediate tasks Page

    Completion

    Students must

    

    View
  • Select activity 17. JOIN functions: Advanced tasks

    

    17. JOIN functions: Advanced tasks Page

    Completion

    Students must

    

    View
• Select topic Miscellaneous

  Miscellaneous
  • Select activity 18. Working with Partitioning and Clustering

    

    18. Working with Partitioning and Clustering Page

    Completion

    Students must

    

    View
  • Select activity 19. Understanding Tables and Views in BigQuery

    

    19. Understanding Tables and Views in BigQuery Page

    Completion

    Students must

    

    View
  • Select activity 20. Navigating Arrays in Google BigQuery

    

    20. Navigating Arrays in Google BigQuery Page

    Completion

    Students must

    

    View
  • Select activity 21. Harnessing the Power of Regular Expressions

    

    21. Harnessing the Power of Regular Expressions Page

    Completion

    Students must

    

    View
  • Select activity 22. Enhancing Performance: SQL Query Optimization in Google BigQuery

    

    22. Enhancing Performance: SQL Query Optimization in Google BigQuery Page

    Completion

    Students must

    

    View
  • Select activity 23. Embracing Procedural Language for Advanced SQL Operations

    

    23. Embracing Procedural Language for Advanced SQL Operations Page

    Completion

    Students must

    

    View
• Select topic Further Learning

  Further Learning
  • Select activity 24. Resources for Further Learning

    

    24. Resources for Further Learning Page

    Completion

    Students must

    

    View
  • Select activity 25. The Final Word

    

    25. The Final Word Page

    Completion

    Students must

    

    View
• Select topic Your Certificate

  Your Certificate