Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
- Executing basic SQL queries in BigQuery
SQL Querying in BigQuery
- Advanced SQL querying techniques
- Aggregating data using GROUP BY
- Filtering and sorting datasets
- Utilizing date and time functions
- Joining multiple tables
- Working with subqueries and window functions
Advanced BigQuery Capabilities
- Exporting data from BigQuery
- Implementing user-defined functions (UDFs)
- Managing and scheduling queries
- Introduction to BigQuery scripting
- Handling arrays and structs
- Processing JSON data
BigQuery Optimization
- Techniques for optimizing query performance
- Partitioning and clustering tables
- Analyzing the Query Execution Plan
- Troubleshooting and debugging queries
- Best practices for cost control and billing
- Security and access control within BigQuery
Advanced Topics and Integrations
- Real-time data analysis using streaming data
- Integrating BigQuery with Google Data Studio
- Introduction to BigQuery ML for machine learning
- Building and deploying machine learning models via BigQuery ML
- Data lake integration with BigQuery
Summary and Next Steps
Requirements
- A foundational understanding of databases and SQL concepts
Target Audience
- Data analysts
- Database administrators
28 Hours
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
The scheduling of every topic and the breaks inserted it helps in digesting the information specially to the newbie to the topic
