- Level Professional
- Duration 6 hours
- Course by Google Cloud
-
Offered by
About
This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Teradata and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Teradata, you also learn about similarities and differences between Teradata and BigQuery to help you get started with data warehouses in BigQuery.Modules
BigQuery Architecture and Resource Provisioning
1
Assignment
- Module 1 Quiz
1
External Tool
- Lab: Monitoring BigQuery Workloads
1
Videos
- Coursera: Getting Started with Google Cloud Platform and Qwiklabs
1
Readings
- BigQuery Architecture and Resource Provisioning
BigQuery Data Definition Model
1
Assignment
- Module 2 Quiz
1
Readings
- BigQuery Data Definition Model
BigQuery and Google Cloud IAM
1
Assignment
- Module 3 Quiz
1
External Tool
- Lab: Securing and Sharing BigQuery Datasets and Tables
1
Readings
- BigQuery and Google Cloud IAM
BigQuery Data Ingestion
1
Assignment
- Module 4 Quiz
1
Readings
- BigQuery Data Ingestion
BigQuery Schema Design and Optimization
1
Assignment
- Module 5 Quiz
1
External Tool
- Lab: Designing BigQuery Table Schemas for Teradata Professionals
1
Readings
- BigQuery Schema Design and Optimization
SQL in BigQuery
1
Assignment
- Module 6 Quiz
1
External Tool
- Lab: Working with SQL in BigQuery for Teradata Professionals
1
Readings
- SQL in BigQuery
Auto Summary
BigQuery Fundamentals for Teradata Professionals is an essential course for IT and Computer Science professionals looking to transition their skills from Teradata to BigQuery, a leading SQL-based cloud data warehouse. Guided by expert instruction on Coursera, this professional-level course offers a comprehensive 360-minute learning experience. Participants will engage in interactive lectures and hands-on labs designed to teach the provisioning of resources, data asset creation and sharing, data ingestion, and query performance optimization within BigQuery. Leveraging your existing Teradata expertise, you will explore the similarities and differences between the two platforms, ensuring a smooth and efficient transition to BigQuery. With flexible subscription options, including Starter and Professional tiers, this course is tailored to meet the needs of data warehousing professionals eager to expand their skills and enhance their career prospects in cloud data solutions.

Google Cloud Training