Data Warehousing for Partners (DWP)

 

Resumen del Curso

This deep dive technical course provides technical training for Enterprise Data Warehouses (EDW) solutions using BigQuery.

The course provides guidance and training on technical challenges that can arise when migrating existing EDW and ETL pipelines to Google Cloud. Learners are provided with practical experience with real migration tasks, such as data migration, schema optimization, and SQL Query conversion and optimization.

The course also covers key aspects of ETL pipeline migration to Dataproc and using Pub/Sub, Dataflow, and Cloud Data Fusion.

Quién debería asistir

The core audience for this course is Google Cloud Partners with the following relevant job roles:

  • Data Warehouse Deployment Engineers
  • Data Warehouse Consultants
  • Data Warehouse Architects

These roles, though not the core audience, may find the course relevant should they meet the requirements:

  • Technical Project Leads
  • Technical Project Managers
  • Data / Business Analysts

Prerrequisitos

Required:

  • Have completed the Data Engineering on Google Cloud training.
  • Be a Google Cloud Certified Professional Data Engineer or have equivalent expertise in Data Engineering.
  • Have access to Cloud Connect - Partners.

Recommended:

  • Experience building data processing pipelines.
  • Experience with Apache Beam and Apache Hadoop.
  • Java or Python programming expertise.

Organizational requirements:

  • The Cloud Partner organization must have implemented at least one Data Warehouse solution previously on any Data Warehouse platform.

Objetivos del curso

  • Discuss key elements of Google Data Warehouse solution portfolio and strategy.
  • Map Enterprise Data Warehouses concepts and components to BigQuery and Google data services.
  • Identify best practices for migrating Data Warehouses to BigQuery and demonstrate key skills required to perform successful migrations.
  • Implement data load and transformation pipelines for a BigQuery Data Warehouse using Google data processing and integration services.
  • Implement a streaming analytics solution using Pub/Sub, Dataflow, and BigQuery.
  • Use Looker and LookML to generate reports and gain insights.
  • Explore the GIS, GIS Visualization, and Machine Learning enhancements to BigQuery.

Precios & Delivery methods

Entrenamiento en línea

Duración
4 días

Precio
  • Consulta precio y disponibilidad
Classroom training

Duración
4 días

Precio
  • Consulta precio y disponibilidad

Presionar el boton sobre el nombre de la ciudad o "Entrenamiento en línea" para reservar Calendario

Instructor-led Online Training:   Este es un curso en línea Guiado por un Instructor

Alemania

Hanover Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea de verano Inscripción
Munich Inscripción

Eslovenia

Entrenamiento en línea Zona Horaria: Hora central europea Inscripción
Entrenamiento en línea Zona Horaria: Hora central europea de verano Inscripción