Get in Touch

Course Outline

Introduction

  • Overview of Google BigQuery.

Getting Started

  • Setting up a Google Cloud account.
  • Introduction to the 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 Optimization

  • Query performance optimization 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

  • Foundational understanding of databases and SQL concepts.

Audience

  • Data analysts.
  • Database administrators.
 28 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories