Data Warehousing w/ BigQuery: Storage Design, Query Optimization, Administration

Name: Data Warehousing w/ BigQuery: Storage Design, Query Optimization, Administration
Price: 2700.00 USD
Availability: InStock
Rating: 4.5 (1200 reviews)

Price
$2,700.00 USD

Duration
3 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

In this course, you learn about the internals of BigQuery and best practices for designing, optimizing, and administering your data warehouse. Through a combination of lectures, demos, and labs, you learn about BigQuery architecture and how to design optimal storage and schemas for data ingestion and changes. Next, you learn techniques to improve read performance, optimize queries, manage workloads, and use logging and monitoring tools. You also learn about the different pricing models. Finally, you learn various methods to secure data, automate workloads, and build machine learning models with BigQuery ML.

Course Objectives

Describe BigQuery architecture fundamentals.
Implement storage and schema design patterns to improve performance
Use DML and schedule data transfers to ingest data.
Apply best practices to improve read efficiency and optimize query performance.
Manage capacity and automate workloads.
Understand patterns versus anti-patterns to optimize queries and improve read performance.
Use logging and monitoring tools to understand and optimize usage patterns.
Apply security best practices to govern data and resources.
Build and deploy several categories of machine learning models with BigQuery ML.

Who Should Attend?

Data analysts, data scientists, data engineers, and developers who perform work on a scale that requires advanced BigQuery internals knowledge to optimize performance.

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.