Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Google Cloud Data Engineer Certification
·
Module 1
Data Engineering and SQL Foundations
1
Classifying Data by Structure and Use
Classify a dataset as structured, semi-structured, or unstructured from its format and intended use.
2
Tracing Data from Source to Sink
Trace data from source to sink through ingestion, transformation, storage, and serving stages.
3
Understanding Keys and Relationships in Relational Schemas
Identify primary keys, foreign keys, and relationships in a relational schema.
4
Filtering and Sorting Data with SELECT, WHERE, and ORDER BY
Retrieve and filter rows from a table using SELECT, WHERE, and ORDER BY.
5
Summarizing Grouped Data with Aggregate Functions and GROUP BY
Summarize grouped data using aggregate functions and GROUP BY.
6
Combining Tables with INNER JOIN and LEFT JOIN
Combine related tables using INNER JOIN and LEFT JOIN.
7
Building Multi-Step SQL Transformations with Common Table Expressions
Structure a multi-step SQL transformation using a common table expression.
8
Validating SQL Results for Duplicates, Nulls, and Row Counts
Check a SQL result for duplicates, nulls, and unexpected row counts.
Next module isn't ready yet,
Back to course
Previous module
Next module