Ementorhub

What you'll learn

Describe BigQuery’s architecture, resource provisioning, and data definition model.

Create, secure, and share BigQuery data assets using best practices.

Implement common patterns and best practices for designing schemas, ingesting data, and querying data in BigQuery.

Compare and contrast the differences and commonalities between Oracle and BigQuery.

Skills you'll gain

Real Time Data

Google Cloud Platform

Database Architecture and Administration

SQL

Oracle Databases

Data Modeling

Data Security

Data Import/Export

Extract, Transform, Load

Data Architecture

Data Sharing

Identity and Access Management

Database Design

Data Integration

There are 6 modules in this course

This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle 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 Oracle, you also learn about similarities and differences between Oracle and BigQuery to help you get started with data warehouses in BigQuery.

Module 2: BigQuery Data Definition Model

Module 3: BigQuery and Google Cloud IAM

Module 4: BigQuery Data Ingestion

Module 5: BigQuery Schema Design and Optimization

Module 6: SQL in BigQuery