Get in Touch

Course Outline

Introduction

  • Overview of Google BigQuery.

Getting Started

  • Setting up a Google Cloud account.
  • Introduction to BigQuery Web UI.
  • Creating and managing datasets and tables.
  • Loading data into BigQuery.
  • Basic SQL queries in BigQuery.

SQL Query in BigQuery

  • Advanced SQL querying techniques.
  • Aggregating data with GROUP BY.
  • Filtering and sorting data.
  • Working with date and time functions.
  • Joining multiple tables.
  • Subqueries and window functions.

Advanced BigQuery Features

  • Exporting data from BigQuery.
  • Using user-defined functions (UDFs).
  • Managing and scheduling queries.
  • Introduction to BigQuery scripting.
  • Handling arrays and structs.
  • Working with JSON data.

BigQuery Optimisation

  • Query performance optimisation techniques.
  • Partitioning and clustering tables.
  • Using the Query Execution Plan.
  • Troubleshooting and debugging queries.
  • Cost control and billing best practices.
  • Security and access control in BigQuery.

Advanced Topics and Integration

  • Real-time data analysis with streaming data.
  • Integrating BigQuery with Google Data Studio.
  • Introduction to BigQuery ML for machine learning.
  • Building and deploying machine learning models with BigQuery ML.
  • Data lake integration with BigQuery.

Summary and Next Steps

Requirements

  • Basic understanding of databases and SQL concepts.

Target Audience

  • Data analysts.
  • Database administrators.
 28 Hours

Testimonials (2)

Upcoming Courses

Related Categories