This course, "BigQuery Fundamentals for Oracle Professionals," offered by Google Cloud, is designed for SQL-based cloud data warehouse professionals looking to transition to working in BigQuery. The course provides a comprehensive understanding of BigQuery's architecture, resource provisioning, data definition model, data ingestion, schema design, query optimization, and Google Cloud IAM. Through interactive lecture content and hands-on labs, participants will learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery.
Participants will gain insight into the similarities and differences between Oracle and BigQuery, enabling them to leverage their existing knowledge to start working with data warehouses in BigQuery. The course covers best practices for creating, securing, and sharing BigQuery data assets, and implements common patterns for designing schemas, ingesting data, and querying data in BigQuery.
Certificate Available ✔
Get Started / More Info
This course comprises six modules that cover essential aspects of BigQuery, including its architecture, resource provisioning, data definition model, Google Cloud IAM, data ingestion, schema design, query optimization, and SQL implementation in BigQuery.
The first module, "BigQuery Architecture and Resource Provisioning," introduces participants to Google Cloud and Qwiklabs, providing a foundational understanding of BigQuery's architecture and resource provisioning. Participants will learn about monitoring BigQuery workloads and essential best practices.
The second module, "BigQuery Data Definition Model," delves into the data definition model in BigQuery, equipping participants with the knowledge to create, secure, and share BigQuery data assets using best practices.
The third module, "BigQuery and Google Cloud IAM," focuses on implementing common patterns and best practices for designing schemas, ingesting data, and querying data in BigQuery while leveraging Google Cloud IAM for secure access management.
The fourth module, "BigQuery Data Ingestion," provides comprehensive guidance on ingesting data into BigQuery, ensuring participants understand the essential patterns and best practices for successful data ingestion.
The fifth module, "BigQuery Schema Design and Optimization," covers best practices for schema design and optimization in BigQuery, enabling participants to implement efficient data structures and query optimization techniques.
The final module, "SQL in BigQuery," equips participants with the knowledge and skills required to implement SQL queries effectively in BigQuery, leveraging their existing expertise in SQL-based cloud data warehouses.
Learn the basics of containers and cloud computing with Codio's "Containers in the Cloud" specialization. Master Docker, Kubernetes, Terraform, and infrastructure-as-code...
This course provides an in-depth understanding of the encoder-decoder architecture, focusing on training and generating text using this powerful machine learning...
Learn to load your own data into BigQuery from CSV files and various sources using Google Cloud console and CLI.
Use Docker at AWS with the Command Line