- Course Series Introduction
- Course introduction
Intermediate
Online
2 Weeks
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
certificate availability
certificate providing authority
The syllabus
Week 1: Introduction
Videos
Week 1: Introduction to Data Engineering
Videos
- Module Introduction
- The role of a data engineer
- Data engineering challenges
- Introduction to BigQuery
- Data lakes and data warehouses
- Transactional databases versus data warehouses
- Partner effectively with other data teams
- Manage data access and governance
- Demo: Finding PII in your dataset with the DLP API
- Build production-ready pipelines
- Google Cloud customer case study
- Recap
- Lab Intro: Using BigQuery to do Analysis
- Getting Started with Google Cloud and Qwiklabs
Practice Exercise
- Introduction to Data Engineering
Week 1: Building a Data Lake
Videos
- Module Introduction
- Introduction to Data Lakes
- Data storage and ETL options on Google Cloud
- Build a data lake using Cloud Storage
- Secure Cloud Storage
- Store all sorts of data types
- Cloud SQL as a relational Data Lake
- Lab Intro: Loading Taxi Data into Google Cloud SQL
Practice Exercise
- Building a Data Lake
Week 2: Building a data warehouse
Videos
- Module Introduction
- The modern data warehouse
- Introduction to BigQuery
- Demo: Querying TB of data in seconds
- Get started with BigQuery
- Load data into BigQuery
- Lab Intro: Loading Data into BigQuery
- Explore schemas
- Demo: Exploring Schemas
- Schema design
- Nested and repeated fields
- Demo: Nested and repeated fields
- Design the optimal schema for BigQuery
- Lab Intro: Working with JSON and Array data in BigQuery
- Optimize with partitioning and clustering
- Review
Practice Exercise
- Building a Data Warehouse
Week 2: Summary
Video
- Course Summary
Articles
Popular Articles
Latest Articles
Similar Courses
Business Intelligence and Data Warehousing
UNAM Mexico via Coursera
Courses of your interest
Salesforce Administrator and App Builder
SkillUp Online via Simplilearn
Introduction to Medical Software
Yale University, New Haven via Coursera
Google Cloud Architect Program
Google Cloud via SkillUp Online
Google Cloud Architect Program
Google via SkillUp Online
Information Security Design and Development
Coventry University, Coventry via Futurelearn
Ethics Laws and Implementing an AI Solution on Mic...
CloudSwyft Global Systems, Inc via Futurelearn
Network Security and Defence
Coventry University, Coventry via Futurelearn
Cyber Security Foundations Start Building Your Car...
EC-Council via Futurelearn
Applied Data Analysis
CloudSwyft Global Systems, Inc via Futurelearn
More Courses by Google
Advanced Training
Certified Trainer
Building No-Code Apps with AppSheet Implementation
Google via Coursera
Contact Center Artificial Intelligence Operations ...
Google via Coursera
Building Batch Data Pipelines on GCP
Google via Coursera
Enterprise Database Migration
Google via Coursera
Mitigating Security Vulnerabilities on Google Clou...
Google via Coursera
Migrating to Google Cloud
Google via Coursera
Building Resilient Streaming Analytics Systems on ...
Google via Coursera
Essential Google Cloud Infrastructure Foundation
Google via Coursera