3000+ Courses from California Community Colleges

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to BigQuery

via DataCamp

Go to class Write review

Overview

Unlock BigQuery's power: grasp its fundamentals, execute queries, and optimize workflows for efficient data analysis.

Embark on this course for practical insights into data analysis. Explore BigQuery's architecture, run analytical queries, and optimize workflows. Gain confidence in navigating datasets, query elements, and data manipulation. Unlock advanced techniques for efficient analysis and master the art of joining data. Upon completion, navigate BigQuery effectively, optimize queries, and analyze data swiftly.

Syllabus

  • BigQuery Architecture and Structure
    • In this chapter, you will learn about the unique features of BigQuery, how it runs large analytical queries, and how it compares to other data warehouses and databases.
  • Writing queries and data types
    • This chapter will cover the fundamentals of how to write queries in BigQuery while also providing a review of SQL concepts. You will also learn how to ingest bulk data into BigQuery and the different data types within BigQuery.
  • Querying data in BigQuery
    • Learn how to query data using common table expressions, aggregations, and window functions.
  • Data management and optimization
    • Understand all join types in BigQuery, mange data with data manipulation, and optimize your queries.

Taught by

Matt Forrest

Reviews

Start your review of Introduction to BigQuery

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.