GCP200DATAFORM
Orchestrate BigQuery Workloads with Dataform
Dataform is a service for data analysts to develop, test, version control, and schedule complex SQL workflows for data transformation in BigQuery. In this course you will explore the components of Dataform core, learn how to define tables and dependencies in SQLX, document BigQuery tables and views, understand BigQuery security settings and how to manage these with Dataform, write assertions, execute SQL workflows, and explore additional advanced use cases.
Ce que vous allez apprendre
- Understand the components of Dataform core.
- Create tables and views in BigQuery using Dataform.
- Document BigQuery tables and views.
- Understand BigQuery security settings using Dataform.
- Use assertions to validate data in Dataform workflows.
- Execute Dataform SQL workflows in an automated fashion.
Prérequis
- Knowledge of SQL data analysis and BigQuery as discussed in BigQuery for Data Analysis.
Public cible
- Customers
Programme de la Formation
7 modules pour maîtriser les fondamentaux
Objectifs
- Understand the components of Dataform core.
Sujets abordés
- →SQL workflow
- →Repositories and workspaces
- →Default files and folders
- →Compiled graphs
Quality Process
SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach
Teaching Methods Used
- Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
- Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
- Guided Labs — Guided practical exercises on software, hardware, or technical environments.
- Quiz / MCQ — Quick knowledge check (paper-based or digital via tools like Kahoot/Klaxoon).
Evaluation and Monitoring System
The achievement of training objectives is evaluated at multiple levels to ensure quality:
- Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
- Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
- Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.
Prochaines sessions
12 février 2026
Distanciel • Français
22 mai 2026
Distanciel • Français
15 septembre 2026
Distanciel • Français
Former plusieurs collaborateurs
- Tarifs dégressifs (plusieurs places)
- Session privée ou sur-mesure
- En présentiel ou à distance