[{"id":"74704","title":"Introducción","description":"

Este módulo es la introducción a la serie de cursos Data Engineering on Google Cloud y al curso Modernizing Data Lakes and Data Warehouses with Google Cloud.

","steps":[{"id":"518059","prompt":null,"isOptional":true,"activities":[{"id":"510889","href":"/paths/31/course_templates/54/video/510889?locale=es","isLocked":false,"duration":160000,"title":"Introducción a la serie de cursos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518060","prompt":null,"isOptional":true,"activities":[{"id":"510890","href":"/paths/31/course_templates/54/video/510890?locale=es","isLocked":false,"duration":56000,"title":"Introducción al curso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74705","title":"Introducción a la ingeniería de datos","description":"

En este módulo, se analiza el rol de la ingeniería de datos y se explica por qué debe realizarse en la nube.

","steps":[{"id":"518061","prompt":null,"isOptional":true,"activities":[{"id":"510891","href":"/paths/31/course_templates/54/video/510891?locale=es","isLocked":false,"duration":101000,"title":"Introducción al módulo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518062","prompt":null,"isOptional":true,"activities":[{"id":"510892","href":"/paths/31/course_templates/54/video/510892?locale=es","isLocked":false,"duration":259000,"title":"Rol del ingeniero de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518063","prompt":null,"isOptional":true,"activities":[{"id":"510893","href":"/paths/31/course_templates/54/video/510893?locale=es","isLocked":false,"duration":330000,"title":"Desafíos de la ingeniería de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518064","prompt":null,"isOptional":true,"activities":[{"id":"510894","href":"/paths/31/course_templates/54/video/510894?locale=es","isLocked":false,"duration":145000,"title":"Introducción a BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518065","prompt":null,"isOptional":true,"activities":[{"id":"510895","href":"/paths/31/course_templates/54/video/510895?locale=es","isLocked":false,"duration":283000,"title":"Data lakes y almacenes de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518066","prompt":null,"isOptional":true,"activities":[{"id":"510896","href":"/paths/31/course_templates/54/video/510896?locale=es","isLocked":false,"duration":271000,"title":"Comparación entre las bases de datos transaccionales y los almacenes de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518067","prompt":null,"isOptional":true,"activities":[{"id":"510897","href":"/paths/31/course_templates/54/video/510897?locale=es","isLocked":false,"duration":282000,"title":"Asóciate de manera eficaz con otros equipos de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518068","prompt":null,"isOptional":true,"activities":[{"id":"510898","href":"/paths/31/course_templates/54/video/510898?locale=es","isLocked":false,"duration":103000,"title":"Maneja el acceso y la administración de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518069","prompt":null,"isOptional":true,"activities":[{"id":"510899","href":"/paths/31/course_templates/54/video/510899?locale=es","isLocked":false,"duration":118000,"title":"Demostración: Encuentra PII en los conjuntos de datos mediante la API de DLP","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518070","prompt":null,"isOptional":true,"activities":[{"id":"510900","href":"/paths/31/course_templates/54/video/510900?locale=es","isLocked":false,"duration":122000,"title":"Crea canalizaciones listas para la producción","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518071","prompt":null,"isOptional":true,"activities":[{"id":"510901","href":"/paths/31/course_templates/54/video/510901?locale=es","isLocked":false,"duration":61000,"title":"Caso de éxito de un cliente de Google Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518072","prompt":null,"isOptional":true,"activities":[{"id":"510902","href":"/paths/31/course_templates/54/video/510902?locale=es","isLocked":false,"duration":63000,"title":"Resumen","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518073","prompt":null,"isOptional":true,"activities":[{"id":"510903","href":"/paths/31/course_templates/54/video/510903?locale=es","isLocked":false,"duration":14000,"title":"Introducción al lab: Cómo utilizar BigQuery para analizar datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518074","prompt":null,"isOptional":false,"activities":[{"id":"510904","href":"/paths/31/course_templates/54/labs/510904?locale=es","isLocked":false,"duration":2700000,"title":"Cómo utilizar BigQuery para analizar datos","description":"En este lab, analizarás 2 conjuntos de datos públicos diferentes y ejecutarás consultas en ellos (por separado y, luego, en combinación) para obtener estadísticas interesantes.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518075","prompt":null,"isOptional":false,"activities":[{"id":"510905","href":"/paths/31/course_templates/54/quizzes/510905?locale=es","isLocked":false,"duration":600000,"title":"Cuestionario: Introducción a la ingeniería de datos","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74706","title":"Crea un data lake","description":"

En este módulo, se describe qué es un data lake y cómo utilizar Cloud Storage como data lake en Google Cloud.

","steps":[{"id":"518076","prompt":null,"isOptional":true,"activities":[{"id":"510906","href":"/paths/31/course_templates/54/video/510906?locale=es","isLocked":false,"duration":58000,"title":"Introducción al módulo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518077","prompt":null,"isOptional":true,"activities":[{"id":"510907","href":"/paths/31/course_templates/54/video/510907?locale=es","isLocked":false,"duration":534000,"title":"Introducción a los data lakes","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518078","prompt":null,"isOptional":true,"activities":[{"id":"510908","href":"/paths/31/course_templates/54/video/510908?locale=es","isLocked":false,"duration":275000,"title":"Opciones de almacenamiento de datos y ETL en Google Cloud","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518079","prompt":null,"isOptional":true,"activities":[{"id":"510909","href":"/paths/31/course_templates/54/video/510909?locale=es","isLocked":false,"duration":554000,"title":"Crea un data lake con Cloud Storage","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518080","prompt":null,"isOptional":true,"activities":[{"id":"510910","href":"/paths/31/course_templates/54/video/510910?locale=es","isLocked":false,"duration":360000,"title":"Almacenamiento seguro en Cloud Storage","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518081","prompt":null,"isOptional":true,"activities":[{"id":"510911","href":"/paths/31/course_templates/54/video/510911?locale=es","isLocked":false,"duration":272000,"title":"Almacena todo tipo de datos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518082","prompt":null,"isOptional":true,"activities":[{"id":"510912","href":"/paths/31/course_templates/54/video/510912?locale=es","isLocked":false,"duration":421000,"title":"Cloud SQL como data lake relacional","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518083","prompt":null,"isOptional":true,"activities":[{"id":"510913","href":"/paths/31/course_templates/54/video/510913?locale=es","isLocked":false,"duration":32000,"title":"Introducción al lab: Cómo cargar datos de taxis en Google Cloud SQL","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518084","prompt":null,"isOptional":false,"activities":[{"id":"510914","href":"/paths/31/course_templates/54/labs/510914?locale=es","isLocked":false,"duration":3600000,"title":"Cómo cargar datos de taxis en Google Cloud SQL 2.5","description":"En este lab, importarás datos desde archivos de texto CSV a Cloud SQL y, luego, llevarás a cabo algunos análisis de datos básicos usando consultas simples.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518085","prompt":null,"isOptional":false,"activities":[{"id":"510915","href":"/paths/31/course_templates/54/quizzes/510915?locale=es","isLocked":false,"duration":600000,"title":"Cuestionario: Crea un data lake","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74707","title":"Crea un almacén de datos","description":"

En este módulo, hablamos sobre BigQuery como opción de almacenamiento de datos en Google Cloud.

","steps":[{"id":"518086","prompt":null,"isOptional":true,"activities":[{"id":"510916","href":"/paths/31/course_templates/54/video/510916?locale=es","isLocked":false,"duration":71000,"title":"Introducción al módulo","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518087","prompt":null,"isOptional":true,"activities":[{"id":"510917","href":"/paths/31/course_templates/54/video/510917?locale=es","isLocked":false,"duration":225000,"title":"El almacén de datos moderno","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518088","prompt":null,"isOptional":true,"activities":[{"id":"510918","href":"/paths/31/course_templates/54/video/510918?locale=es","isLocked":false,"duration":405000,"title":"Introducción a BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518089","prompt":null,"isOptional":true,"activities":[{"id":"510919","href":"/paths/31/course_templates/54/video/510919?locale=es","isLocked":false,"duration":426000,"title":"Demostración: Consulta TB de datos en segundos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518090","prompt":null,"isOptional":true,"activities":[{"id":"510920","href":"/paths/31/course_templates/54/video/510920?locale=es","isLocked":false,"duration":768000,"title":"Primeros pasos con BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518091","prompt":null,"isOptional":true,"activities":[{"id":"510921","href":"/paths/31/course_templates/54/video/510921?locale=es","isLocked":false,"duration":702000,"title":"Carga datos en BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518092","prompt":null,"isOptional":true,"activities":[{"id":"510922","href":"/paths/31/course_templates/54/video/510922?locale=es","isLocked":false,"duration":26000,"title":"Introducción al lab: Cómo cargar datos en BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518093","prompt":null,"isOptional":false,"activities":[{"id":"510923","href":"/paths/31/course_templates/54/labs/510923?locale=es","isLocked":false,"duration":5400000,"title":"Cómo cargar datos en BigQuery","description":"En este lab, nos enfocaremos en cómo transferir datos a tablas de BigQuery.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518094","prompt":null,"isOptional":true,"activities":[{"id":"510924","href":"/paths/31/course_templates/54/video/510924?locale=es","isLocked":false,"duration":28000,"title":"Análisis de los esquemas","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518095","prompt":null,"isOptional":true,"activities":[{"id":"510925","href":"/paths/31/course_templates/54/video/510925?locale=es","isLocked":false,"duration":626000,"title":"Demostración: Explora esquemas","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518096","prompt":null,"isOptional":true,"activities":[{"id":"510926","href":"/paths/31/course_templates/54/video/510926?locale=es","isLocked":false,"duration":196000,"title":"Diseña esquemas","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518097","prompt":null,"isOptional":true,"activities":[{"id":"510927","href":"/paths/31/course_templates/54/video/510927?locale=es","isLocked":false,"duration":541000,"title":"Campos anidados y repetidos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518098","prompt":null,"isOptional":true,"activities":[{"id":"510928","href":"/paths/31/course_templates/54/video/510928?locale=es","isLocked":false,"duration":937000,"title":"Demostración: Campos anidados y repetidos","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518099","prompt":null,"isOptional":true,"activities":[{"id":"510929","href":"/paths/31/course_templates/54/video/510929?locale=es","isLocked":false,"duration":87000,"title":"Diseña el esquema óptimo para BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518100","prompt":null,"isOptional":true,"activities":[{"id":"510930","href":"/paths/31/course_templates/54/video/510930?locale=es","isLocked":false,"duration":18000,"title":"Introducción al lab: Cómo trabajar con datos de JSON y arrays en BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518101","prompt":null,"isOptional":false,"activities":[{"id":"510931","href":"/paths/31/course_templates/54/labs/510931?locale=es","isLocked":false,"duration":3600000,"title":"Cómo trabajar con datos de JSON y arrays en BigQuery 2.5","description":"En este lab, trabajarás con datos semiestructurados (transferencia de archivos de tipo JSON y arrays) dentro de BigQuery. También practicarás cómo cargar, consultar y desanidar diversos conjuntos de datos semiestructurados, además de cómo solucionar problemas en estos.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518102","prompt":null,"isOptional":true,"activities":[{"id":"510932","href":"/paths/31/course_templates/54/video/510932?locale=es","isLocked":false,"duration":407000,"title":"Realiza optimizaciones con la creación de particiones y el agrupamiento en clústeres","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518103","prompt":null,"isOptional":true,"activities":[{"id":"510933","href":"/paths/31/course_templates/54/video/510933?locale=es","isLocked":false,"duration":15000,"title":"Introducción al lab: Tablas particionadas en BigQuery","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518104","prompt":null,"isOptional":false,"activities":[{"id":"510934","href":"/paths/31/course_templates/54/labs/510934?locale=es","isLocked":false,"duration":3600000,"title":"Tablas particionadas en Google BigQuery","description":"Este lab se enfoca en cómo consultar conjuntos de datos particionados y cómo crear tus propias particiones en conjuntos de datos para mejorar el rendimiento de las consultas y, por ende, reducir los costos.","type":"lab","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518105","prompt":null,"isOptional":true,"activities":[{"id":"510935","href":"/paths/31/course_templates/54/video/510935?locale=es","isLocked":false,"duration":129000,"title":"Repaso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"518106","prompt":null,"isOptional":false,"activities":[{"id":"510936","href":"/paths/31/course_templates/54/quizzes/510936?locale=es","isLocked":false,"duration":600000,"title":"Crea un almacén de datos","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74708","title":"Resumen","description":"

Resumen de los puntos de aprendizaje clave.

","steps":[{"id":"518107","prompt":null,"isOptional":true,"activities":[{"id":"510937","href":"/paths/31/course_templates/54/video/510937?locale=es","isLocked":false,"duration":131000,"title":"Resumen del curso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74709","title":"Recursos del curso","description":"

Vínculos a las versiones en PDF de cada módulo.

","steps":[{"id":"518108","prompt":null,"isOptional":true,"activities":[{"id":"510938","href":"/paths/31/course_templates/54/documents/510938?locale=es","isLocked":false,"duration":1800000,"title":"Modernizing Data Lakes and Data Warehouses with Google Cloud","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"Tus próximos pasos","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Insignia del curso","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Cloud Skills Boost

04

Modernizing Data Lakes and Data Warehouses with Google Cloud - Español