Welcome to Design in BigQuery, where we map Enterprise Data Warehouse concepts and components to BigQuery and Google data services with a focus on schema design.
Learn more
This course discusses the key elements of Google's Data Warehouse solution portfolio and strategy.
Learn more
This course continues to explore the implementation of data load and transformation pipelines for a BigQuery Data Warehouse using Cloud Data Fusion.
Learn more
While the traditional approaches of using data lakes and data warehouses can be effective, they have shortcomings, particularly in large enterprise environments. This course introduces the concept of a data lakehouse and the Google Cloud products used to create one. A lakehouse architecture uses open-standard data sources and combines the best features of data lakes and data warehouses, which addresses many of their shortcomings.
Learn more
Looking to build or optimize your data warehouse? Learn best practices to Extract, Transform, and Load your data into Google Cloud with BigQuery. In this series of interactive labs you will create and optimize your own data warehouse using a variety of large-scale BigQuery public datasets. BigQuery is Google's fully managed, NoOps, low cost analytics database. With BigQuery you can query terabytes and terabytes of data without having any infrastructure to manage or needing a database administrator. BigQuery uses SQL and can take advantage of the pay-as-you-go model. BigQuery allows you to focus on analyzing data to find meaningful insights. Looking for a hands on challenge lab to demonstrate your skills and validate your knowledge? On completing this quest, enroll in and finish the additional challenge lab at the end of this quest to receive an exclusive Google Cloud digital badge.
Learn more
Complete the intermediate Build a Data Warehouse with BigQuery skill badge course to demonstrate skills in the following: joining data to create new tables, troubleshooting joins, appending data with unions, creating date-partitioned tables, and working with JSON, arrays, and structs in BigQuery.
Learn more
Data Warehousing for Partners: Design in BigQuery
Earned янв. 31, 2024 EST
Data Warehousing for Partners: Enable Google Cloud Customers
Earned янв. 29, 2024 EST
Data Warehousing for Partners: Cloud Data Fusion Pipelines
Earned янв. 24, 2024 EST
Build Data Lakes and Data Warehouses on Google Cloud
Earned дек. 27, 2023 EST
DEPRECATED BigQuery for Data Warehousing
Earned дек. 20, 2023 EST
Build a Data Warehouse with BigQuery
Earned дек. 19, 2023 EST