[{"id":"74704","title":"Introduzione","description":"

Questo modulo fornisce un'introduzione ai corsi della serie Data Engineering on Google Cloud e a questo corso specifico, dal titolo Modernizing Data Lakes and Data Warehouses with Google Cloud.

","steps":[{"id":"518059","prompt":null,"isOptional":true,"activities":[{"id":"510889","href":"/course_sessions/25450573/video/510889?locale=it","isLocked":false,"duration":160000,"title":"Introduzione alla serie di corsi","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":"/course_sessions/25450573/video/510890?locale=it","isLocked":false,"duration":56000,"title":"Introduzione al corso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74705","title":"Introduzione al data engineering","description":"

In questo modulo viene illustrato il ruolo del data engineer, spiegando perché le attività di data engineering dovrebbero essere eseguite nel cloud

","steps":[{"id":"518061","prompt":null,"isOptional":true,"activities":[{"id":"510891","href":"/course_sessions/25450573/video/510891?locale=it","isLocked":false,"duration":101000,"title":"Introduzione al modulo","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":"/course_sessions/25450573/video/510892?locale=it","isLocked":false,"duration":259000,"title":"Il ruolo di un data engineer","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":"/course_sessions/25450573/video/510893?locale=it","isLocked":false,"duration":330000,"title":"Le sfide del data engineering","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":"/course_sessions/25450573/video/510894?locale=it","isLocked":false,"duration":145000,"title":"Introduzione 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":"/course_sessions/25450573/video/510895?locale=it","isLocked":false,"duration":283000,"title":"Data lake e data warehouse","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":"/course_sessions/25450573/video/510896?locale=it","isLocked":false,"duration":271000,"title":"Database transazionali e data warehouse","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":"/course_sessions/25450573/video/510897?locale=it","isLocked":false,"duration":282000,"title":"Collaborazione efficace con gli altri team di gestione dati","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":"/course_sessions/25450573/video/510898?locale=it","isLocked":false,"duration":103000,"title":"Gestione dell'accesso ai dati e della governance","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":"/course_sessions/25450573/video/510899?locale=it","isLocked":false,"duration":118000,"title":"Demo: Uso dell'API DLP per la ricerca delle informazioni PII in un set di dati","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":"/course_sessions/25450573/video/510900?locale=it","isLocked":false,"duration":122000,"title":"Creazione di pipeline pronte per l'ambiente di produzione","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":"/course_sessions/25450573/video/510901?locale=it","isLocked":false,"duration":61000,"title":"Case study di un cliente 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":"/course_sessions/25450573/video/510902?locale=it","isLocked":false,"duration":63000,"title":"Riepilogo","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":"/course_sessions/25450573/video/510903?locale=it","isLocked":false,"duration":14000,"title":"Introduzione al lab: Utilizzo di BigQuery per eseguire l'analisi","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":"/course_sessions/25450573/labs/510904?locale=it","isLocked":false,"duration":2700000,"title":"Utilizzo di BigQuery per eseguire l'analisi","description":"In questo lab analizzerai due diversi set di dati pubblici ed eseguirai query su questi set di dati, prima separatamente e poi combinandole per ottenere insight interessanti.","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":"/course_sessions/25450573/quizzes/510905?locale=it","isLocked":false,"duration":600000,"title":"Quiz: Introduzione al data engineering","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74706","title":"Creazione di un data lake","description":"

In questo modulo viene spiegato che cos'è un data lake e come utilizzare Cloud Storage come data lake su Google Cloud.

","steps":[{"id":"518076","prompt":null,"isOptional":true,"activities":[{"id":"510906","href":"/course_sessions/25450573/video/510906?locale=it","isLocked":false,"duration":58000,"title":"Introduzione al modulo","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":"/course_sessions/25450573/video/510907?locale=it","isLocked":false,"duration":534000,"title":"Introduzione ai data lake","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":"/course_sessions/25450573/video/510908?locale=it","isLocked":false,"duration":275000,"title":"Opzioni di archiviazione dei dati e ETL su 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":"/course_sessions/25450573/video/510909?locale=it","isLocked":false,"duration":554000,"title":"Creazione di un data lake utilizzando 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":"/course_sessions/25450573/video/510910?locale=it","isLocked":false,"duration":360000,"title":"Protezione di 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":"/course_sessions/25450573/video/510911?locale=it","isLocked":false,"duration":272000,"title":"Archiviazione di tutti i tipi di dati","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":"/course_sessions/25450573/video/510912?locale=it","isLocked":false,"duration":421000,"title":"Cloud SQL come data lake relazionale","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":"/course_sessions/25450573/video/510913?locale=it","isLocked":false,"duration":32000,"title":"Introduzione al lab: Caricare i dati dei taxi in 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":"/course_sessions/25450573/labs/510914?locale=it","isLocked":false,"duration":3600000,"title":"Caricare i dati dei taxi in Google Cloud SQL 2.5","description":"In questo lab importerai i dati da file di testo CSV in Cloud SQL ed eseguirai quindi analisi di base dei dati utilizzando semplici query.","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":"/course_sessions/25450573/quizzes/510915?locale=it","isLocked":false,"duration":600000,"title":"Quiz: Creazione di 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":"Creazione di un data warehouse","description":"

In questo modulo parleremo di BigQuery come opzione di data warehouse su Google Cloud

","steps":[{"id":"518086","prompt":null,"isOptional":true,"activities":[{"id":"510916","href":"/course_sessions/25450573/video/510916?locale=it","isLocked":false,"duration":71000,"title":"Introduzione al modulo","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":"/course_sessions/25450573/video/510917?locale=it","isLocked":false,"duration":225000,"title":"Il data warehouse 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":"/course_sessions/25450573/video/510918?locale=it","isLocked":false,"duration":405000,"title":"Introduzione 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":"/course_sessions/25450573/video/510919?locale=it","isLocked":false,"duration":426000,"title":"Demo: query su TB di dati in pochi secondi","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":"/course_sessions/25450573/video/510920?locale=it","isLocked":false,"duration":768000,"title":"Inizia a utilizzare 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":"/course_sessions/25450573/video/510921?locale=it","isLocked":false,"duration":702000,"title":"Caricare dati in 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":"/course_sessions/25450573/video/510922?locale=it","isLocked":false,"duration":26000,"title":"Introduzione al lab: Caricamento di dati in 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":"/course_sessions/25450573/labs/510923?locale=it","isLocked":false,"duration":5400000,"title":"Caricamento di dati in BigQuery","description":"Questo lab spiega come importare i dati nelle tabelle all'interno di 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":"/course_sessions/25450573/video/510924?locale=it","isLocked":false,"duration":28000,"title":"Esplorare gli schemi","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":"/course_sessions/25450573/video/510925?locale=it","isLocked":false,"duration":626000,"title":"Demo: Esplorare gli schemi","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":"/course_sessions/25450573/video/510926?locale=it","isLocked":false,"duration":196000,"title":"Progettazione di uno schema","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":"/course_sessions/25450573/video/510927?locale=it","isLocked":false,"duration":541000,"title":"Campi nidificati e ripetuti","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":"/course_sessions/25450573/video/510928?locale=it","isLocked":false,"duration":937000,"title":"Demo: Campi nidificati e ripetuti","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":"/course_sessions/25450573/video/510929?locale=it","isLocked":false,"duration":87000,"title":"Progettazione dello schema ottimale per 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":"/course_sessions/25450573/video/510930?locale=it","isLocked":false,"duration":18000,"title":"Introduzione al lab: Utilizzo di dati di tipo JSON e array in 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":"/course_sessions/25450573/labs/510931?locale=it","isLocked":false,"duration":3600000,"title":"Utilizzo dei tipi di dati JSON e array in BigQuery 2.5","description":"In questo lab imparerai a utilizzare i dati semistrutturati (importazione di tipi di dati per array JSON) all'interno di BigQuery. Ti eserciterai a caricare, interrogare e denidificare vari set di dati semistrutturati, risolvendo anche i problemi relativi.","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":"/course_sessions/25450573/video/510932?locale=it","isLocked":false,"duration":407000,"title":"Creazione di partizioni e cluster per l'ottimizzazione","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":"/course_sessions/25450573/video/510933?locale=it","isLocked":false,"duration":15000,"title":"Introduzione al lab: Tabelle partizionate in 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":"/course_sessions/25450573/labs/510934?locale=it","isLocked":false,"duration":3600000,"title":"Tabelle partizionate in Google BigQuery","description":"Questo lab spiega come eseguire query su set di dati partizionati e come creare le tue partizioni del set di dati per migliorare le prestazioni delle query e ridurre il costo.","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":"/course_sessions/25450573/video/510935?locale=it","isLocked":false,"duration":129000,"title":"Riepilogo","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":"/course_sessions/25450573/quizzes/510936?locale=it","isLocked":false,"duration":600000,"title":"Creazione di un data warehouse","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74708","title":"Riepilogo","description":"

Riepilogo dei punti chiave per l'apprendimento

","steps":[{"id":"518107","prompt":null,"isOptional":true,"activities":[{"id":"510937","href":"/course_sessions/25450573/video/510937?locale=it","isLocked":false,"duration":131000,"title":"Riepilogo del corso","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"74709","title":"Risorse del corso","description":"

Link alle versioni PDF dei singoli moduli

","steps":[{"id":"518108","prompt":null,"isOptional":true,"activities":[{"id":"510938","href":"/course_sessions/25450573/documents/510938?locale=it","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":"Prossimi passaggi","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"Badge del corso","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Modernizing Data Lakes and Data Warehouses with Google Cloud - Italiano

Creazione di un data warehouse