Troubleshooting and Solving Data Join Pitfalls

About this course

This is a self-paced lab that takes place in the Google Cloud console. This lab focuses on how to reverse-engineer the relationships between data tables and the pitfalls to avoid when joining them together.

What you will learn

• Use BigQuery to explore a dataset.
• Troubleshoot duplicate rows in a dataset.
• Create joins between data tables and understand each join type