Study guide

GCP Data Practitioner study guide

Read a lesson, then practice the ideas you want to remember.

Lessons

  1. Cloud Storage Security & Access Controls
  2. Fine-Grained Security: Column-Level & Row-Le
  3. IAM Principles & Role Hierarchies for Data S
  4. Secure Data Sharing with Analytics Hub — Free Study Guide 2026
  5. Query Optimization, Execution Plans, and Cos
  6. Table Clustering & Data Skipping — Free Study Guide 2026
  7. Table Partitioning Strategies — Free Study Guide 2026
  8. Answering Business Questions with BigQuery:
  9. BigQuery SQL Syntax & Analytical Functions
  10. Complex Data Types: Arrays, Structs, and JSO
  11. Cloud Storage Buckets, Location Types & Stor
  12. File Formats & Serialization Characteristics
  13. Selecting Google Cloud Databases and Storage
  14. Data Quality, Cleaning, and Validation — Free Study Guide 2026
  15. Data Transfer and Migration Tools — Free Study Guide 2026
  16. ETL, ELT, and ETLT Transformation Paradigms
  17. Building, Modifying & Sharing Looker Dashboa
  18. Enterprise BI with Looker & LookML Foundatio
  19. Exploratory Analysis with Jupyter & Colab En
  20. Looker Studio Reporting & Dashboard Design
  21. About the Associate Data Practitioner Exam
  22. Data Retention, Time Travel, and Point-in-Ti
  23. Encryption Key Management & Privacy Complian
  24. High Availability & Disaster Recovery Archit
  25. Object Lifecycle Management & Storage Tierin
  26. BigQuery External Tables, BigLake & Federate
  27. Batch Loading Data into BigQuery — Free Study Guide 2026
  28. Schema Definition & Evolution for Loaded Dat
  29. Streaming Ingestion & Deduplication Patterns
  30. Creating, Training & Evaluating Models with
  31. Running Inference and Organizing Models in M
  32. Planning an ML Project: BigQuery ML, AutoML,
  33. Using Pretrained Gemini Models from BigQuery
  34. Apache Beam & Cloud Dataflow Core Concepts
  35. Stream Processing: Windowing, Watermarks, an
  36. Transformation Engine Selection Matrix — Free Study Guide 2026
  37. Event-Driven Ingestion: Pub/Sub to BigQuery
  38. Monitoring Pipelines: Dataflow Job UI, Cloud
  39. SQL Pipelines with Dataform & Scheduled Quer
  40. Workflow Orchestration with Cloud Composer &