Build a Data Warehouse Using BigQuery-Lesson 1: Understanding BigQuery Platform
Welcome to the Course
Introduction to the Instructor
()
Introduction to BigQuery
()
Setting up and accessing bigQuery
()
Navigating the BigQuery UI
()
Exploring "bigquery-public-data" datasets
()
Additional resources
Build a Data Warehouse Using BigQuery-Lesson 2: Creating A Data Warehouse Using UI Interface And SQL
Introduction to Data Warehousing and BigQuery
()
Creating Datasets for Data Organization
()
Defining Tables with Schema and Settings
()
Partitioning and Clustering Strategies
()
Creating Tables using SQL
()
Creating Partitioned Tables using SQL
()
Additional resources
Build a Data Warehouse Using BigQuery-Lesson 3: Creating A Data Warehouse Using Python
Installing Anaconda Package and Configuring Credentials
()
Introduction to Jupyter Notebook UI
()
Manipulating Data with Pandas: Replacing and Appending Tables
()
Adding Schema Information Dynamically
()
Incorporating Partitioning and Clustering Configurations
()
Additional resources
Build a Data Warehouse Using BigQuery-Lesson 4: ETL With Python From External Sources
Understanding ETL (Extract, Transform, Load)
()
Performing ETL with CSV, Excel, and JSON files
()
Additional resources
Build a Data Warehouse Using BigQuery-Lesson 5: Querying And Governance
Introduction to Data Query Language
()
Exploring SQL Examples for Data Retrieval
()
Leveraging Aggregate and Window Functions for Advanced Queries
()
User-Defined Functions (UDFs) for Custom Transformations
()
Data Security and Governance Best Practice
()
Additional resources
Build a Data Warehouse Using BigQuery-Conclusion & Final Assessment
Conclusion
()