Build and Optimize Data Warehouses with BigQuery

Complete the intermediate Build a Data Warehouse with BigQuery skill badge 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. A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete the skill badge course, and final assessment challenge lab, to receive a digital badge that you can share with your network. For practice with BigQuery fundamentals (including working with the console and command line), complete the course titled BigQuery Basics for Data Analysts.

• Build a Data Warehouse with BigQuery
• Creating a Data Warehouse Through Joins and Unions
• Creating Date-Partitioned Tables in BigQuery
• Troubleshooting and Solving Data Join Pitfalls
• Working with JSON, Arrays, and Structs in BigQuery
• Build a Data Warehouse with BigQuery: Challenge Lab
• Your Next Steps
• Course Badge