BigQuery: Data Ingestion, Modeling, and Query Optimization
Build practical skills in Google BigQuery to query, ingest, model, and optimize data for analysis and reporting. In this Specialization, you'll learn SQL fundamentals, data warehousing, data transformation, and query optimization through hands-on Google Cloud activities.
You'll begin by writing SQL queries in BigQuery and Cloud SQL, then learn to troubleshoot syntax and logical errors. Next, you'll explore data analysis, cleaning, and transformation using SQL and Dataform, along with visualization using Connected Sheets and Looker Studio.
As you progress, you'll ingest datasets from Cloud Storage and CSV files, create tables, and combine data using joins and unions. You'll then work with JSON, arrays, and structs before learning to create date-partitioned tables. You'll explore techniques such as clustering, denormalization, partition pruning, and materialized views to improve performance and manage costs. Finally, you'll use Gemini in BigQuery for data exploration, code assistance, and workflow visualization.
By the end, you'll be able to:
Write, troubleshoot, and transform data using SQL. Ingest datasets and create reporting tables. Query semi-structured data and optimize BigQuery performance. Use Gemini to support data analysis and development workflows.
This Specialization is designed for aspiring data analysts, cloud practitioners, and professionals seeking practical experience with Google Cloud data tools.
Status: Data Analysis
Data AnalysisStatus: Google Gemini
Google GeminiIntermediate·Specialization