お問い合わせを送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
予約を送信いただきありがとうございます！当社のスタッフがすぐにご連絡いたします。
コース概要
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
要求
- Basic understanding of databases and SQL concepts
Audience
- Data analysts
- Database administrators
28 時間
お客様の声 (2)
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.
Mircea
コース - Google Cloud Platform Basics and Management
解決策と実用化で対応します。
Agnieszka - AIRBUS HELICOPTERS POLSKA SP. Z O.O.
コース - Google AdWords: Beginner to Advanced
機械翻訳
