Description
Google BigQuery for Cloud Computing is a custom-tailored session focused on solving customized training needs with Google BigQuery. Throughout the training, students will build custom Google BigQuery solutions using custom-built curriculums and methodologies. At the end of training, students will have developed bespoke solutions for work portfolios as well as improved technical skillsets in Google BigQuery and enhanced conceptional understandings of cloud computing.
Benefits
• Bespoke solutions for work portfolios
• Technical skillsets in SELECT, ORDER BY, WHERE, Aggregate Functions, GROUP BY, Joins, and Subqueries
• Conceptual understandings of querying data, sorting and filtering queries, aggregating data, combining tables, and nesting queries
• Live private trainings
• Continuous learning resources
Topics
1. Querying data using SELECT, DISTINCT, and CAST
2. Sorting and filtering queries using ORDER BY and WHERE
3. Aggregating data using COUNT, SUM, AVG, MAX/MIN, and GROUP BY
4. Combining tables using INNER JOIN, LEFT/RIGHT JOIN, and FULL JOIN
5. Nesting queries using Subqueries
Deliverables
• 60-min live private training via Google Meet
Requirements
• Google BigQuery
• MS Excel or Google Sheets (recommended)
• Private information secured during screensharing
Policies
• Scheduling Policy – Scheduling is in 60-min increments. Attendance will be charged in full at start of each 60-min increment.
• Cancellation Policy – Cancelled or Missed attendance without 24-hr notice will be charged in full and ineligible for rescheduling, exchange, or refund. Late arrival over 15-min will be considered Missed.
