GCP Data Engineer Pro: BigQuery Data Warehouse

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. In order to answer the big questions, you'll need to have the right data, arranged in the right way. BigQuery is the main Google repository for data that will be used in analysis and machine learning (ML). In this course, you will navigate the BigQuery UI and command line interface (CLI), explore public datasets, and learn the art of dataset replication. We will unveil the process of creating robust datasets, delve into the world of BigQuery tables, views, routines, and connections, and uncover the capabilities of BigQuery search and vector indexes. You’ll also gain proficiency in importing data, batch loading options, and publishing datasets for collaboration. The course will guide you through optimizing costs with various pricing models, and introduce you to Looker and Looker Studio, where you’ll create and share insightful reports. Finally, you’ll be equipped to troubleshoot both BigQuery and Looker, ensuring a smooth data analysis experience. This course is one of a collection that prepares learners for the Google Professional Data Engineer exam.