Location

Community Services & Continuing Education - Cairo

Objectives

• BigQuery is Google’s managed data warehouse in the cloud. BigQuery is incredibly fast. It can scan billions of rows in seconds. It’s also surprisingly inexpensive and easy to use. Querying terabytes of data costs only pennies and you only pay for what you use since there are no up-front costs.

Outcomes

-Load data into BigQuery using files or by streaming one record at a time-Run a query using standard SQL and save your results to a table-Export data from BigQuery using Google Cloud Storage

Course Contents

-Intorduction to Google Cloud Platform (GCP)-Basic SQL-SQL Joins-SQL Date, Text, String Functions-SQL STRUCT and ARRAY advanced Data Structures-Advanced Querying Techniques-Data Warngling with BigQuery- Data Analytics Functions (Window Functions)