Course Title:

Google BigQuery for Data Analysts 2017


Global Knowledge Canada

Halifax, Mississauga, Montreal, Ottawa, Toronto, Winnipeg, Canada

Course format: Classroom

In this course, you will be introduced to Google BigQuery. Through a combination of instructor-led presentations, demonstrations, and hands-on labs, you will learn how to store, transform, analyze, and visualize data using Google BigQuery.

What You&,#146,ll Learn

Purpose of and use cases for Google BigQuery
Ways in which customers have used Google BigQuery to improve their businesses
Architecture of BigQuery and how queries are processed
Interact with BigQuery using the web UI and command-line interface
Purpose and structure of BigQuery schemas and data types
Purpose of and advantages of BigQuery destinations tables and caching
Use BigQuery jobs
Transform and load data into BigQuery
Export data from BigQuery
Store query results in a destination table
Create a federated query
Export log data to BigQuery and query it
Understand the BigQuery pricing structure and evaluate mechanisms for controlling query and storage costs
Best practices for optimizing query performance
Troubleshoot common errors in BigQuery
Use various BigQuery functions
Use external tools such as spreadsheets to interact with BigQuery
Visualize BigQuery data
Use access controls to restrict access to BigQuery data
Query Google Analytics Premium data exported to BigQuery

Elements of this syllabus are subject to change. Training programs and their availability may vary by location.

Please visit the school's official website or social networks for the latest training price and schedule.

Phone No.: 866-716-6688

School Address/Venue(s):

Global Knowledge
2 Bloor Street EAST,
31st Floor
Toronto, ON M4W 1A8

Free Course List: Halifax, Mississauga, Montreal, Ottawa, Toronto, Winnipeg

Search other schools for Google BigQuery for Data Analysts training programs.

Other courses offered by Global Knowledge Canada

Notice: The course description on this page was archived statically and not updated from day to day. If you are a school user, please upload your new courses using this form, or you can contact us for data management issues.

We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.

Google BigQuery for Data Analysts
Ask for Training
Add Courses