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 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

  • Basic understanding of databases and SQL concepts

Audience

  • Data analysts
  • Database administrators
 28 Hours

Number of participants



Price per participant

Testimonials (1)

Related Courses

Google AdWords: Beginner to Advanced

7 Hours

Introduction to Google Analytics

7 Hours

Google Apps Script: Beginner to Advanced

14 Hours

Google Cloud AutoML

7 Hours

Mastering Google Earth Pro

21 Hours

Google Kubernetes Engine (GKE)

14 Hours

Google Maps API for Developers

14 Hours

Google Sheets - 1 Day

7 Hours

Related Categories

1