Achieving Advanced Insights with BigQuery
About this Course
The third course in this course series is Achieving Advanced Insights with BigQuery. Here we will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views. After completing this course, enroll in the Applying Machine Learning to your Data with Google Cloud course.Created by: Google Cloud

Related Online Courses
In this course, you will learn important language for talking about nutrition, health, sleep, stress, goal-setting, and more. Learning activities in this course will take place on Voxy, an engaging... more
This course on Test Management will provide learners with the essential skills to effectively plan, execute, and assess testing processes in software development. It caters to both beginners... more
This course deals with compression. When we push an object, it compresses. Compression is what\'s going to hold up our building. Arches, vaults, domes, and anti-funicular forms help resist... more
In this course, you will study the fundamental concepts involved in interconnecting devices for communications. You will also explore protocols, network hardware, and network services. The career... more
In a post-pandemic world, companies across the globe are constantly looking to expand and grow their businesses. Mergers and Acquisitions (M&A) offers many ways to achieve this goal. Through this... more