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.
Duration 28 hours
Course Outline
Overview
- Introduction to the Google BigQuery Platform
Initial Configuration
- Establishing a Google Cloud account
- Navigating the BigQuery Web interface
- Provisioning and administering datasets and tables
- Ingesting data into the BigQuery environment
- Executing fundamental SQL queries within BigQuery
SQL Querying in BigQuery
- Advanced methods for constructing SQL queries
- Data aggregation using GROUP BY clauses
- Data filtering and sorting procedures
- Utilizing date and time functional operations
- Joining multiple data tables
- Implementing subqueries and window functions
Advanced BigQuery Capabilities
- Exporting data from the BigQuery repository
- Application of user-defined functions (UDFs)
- Administration and scheduling of query execution
- Foundations of BigQuery scripting
- Processing arrays and structural data types
- Handling JSON-formatted data
BigQuery Performance Optimization
- Strategies for enhancing query performance
- Table partitioning and clustering methodologies
- Interpreting the Query Execution Plan
- Diagnostic troubleshooting and query debugging
- Cost management and billing compliance practices
- Security protocols and access control mechanisms in BigQuery
Advanced Topics and System Integration
- Real-time analysis via streaming data ingestion
- Integration of BigQuery with Google Data Studio
- Introduction to BigQuery ML for machine learning applications
- Development and deployment of machine learning models using BigQuery ML
- Integration with data lake architectures
Summary and Forward Planning
Requirements
- Familiarity with fundamental database architecture and SQL syntax
Target Audience
- Data analysts
- Database administrators
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