In this course, you will learn to analyze and transform datasets using SQL, BigQuery, and Dataprep on Google Cloud. The course covers challenges faced by data analysts, evaluating data quality, and creating automated data cleaning pipelines.
Key Learning Points:
Certificate Available ✔
Get Started / More Info
This course comprises 7 modules that cover various aspects of data analysis and preparation using BigQuery and Dataprep on Google Cloud.
Module 1 provides an introduction to the From Data to Insights with Google Cloud series, offering a preview of the entire course.
Module 2 delves into the challenges of data analysis, comparing on-premises and cloud-based big data, real use cases, and the fundamentals of Google Cloud projects.
Module 3 explores tasks and challenges of data analysts, essential BigQuery features, architecture diagrams, and tools for analysts, scientists, and data engineers.
Module 4 introduces the e-commerce dataset from Google Analytics, common data analysis techniques, SQL queries, functions, and data types, and character wildcard filters.
Module 5 covers BigQuery job management, size and cost management, and optimizing query costs.
Module 6 focuses on maintaining data integrity, data shape and skew, data cleaning and transformation using SQL and Dataprep, and creating and analyzing data pipelines.
Module 7 provides a summary of the entire course, consolidating the key learnings and insights gained from the modules.
Oracle SQL Databases is a beginner-friendly Specialization that equips learners with the skills to proficiently create, modify, and manage Oracle SQL Databases.
Learn to create a project tracker using Airtable, a cloud collaboration service that combines databases and spreadsheets. No prior experience needed.
Start your journey in data engineering with this comprehensive course covering core concepts, tools, and skills needed for a foundational knowledge of the field....
Understanding Basic SQL Syntax - Learn to write SQL retrieval queries with correct syntax.