Introduction to BigQuery
Unlock BigQuery's power: grasp its fundamentals, execute queries, and optimize workflows for efficient data analysis.
Start Course for Free4 hours15 videos62 exercises4,561 learnersStatement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?
Try DataCamp for BusinessLoved by learners at thousands of companies
Course Description
Delve into the core concepts of BigQuery architecture, understanding its historical significance and comparing it to traditional database systems. Uncover the diverse range of applications where BigQuery shines, setting the stage for a deeper exploration of its capabilities.
Mastering Analytical Queries and Data Manipulation
Learn to wield the power of BigQuery by executing analytical queries and manipulating data with precision. Navigate datasets and tables effortlessly while gaining proficiency in utilizing bq command line tools for data ingestion. Dive into the complexities of data types and unstructured data, honing your skills to extract meaningful insights.Optimizing Workflow Efficiency and Query Performance
Elevate your data analysis workflow to new heights by mastering advanced techniques within BigQuery. From optimizing query performance through strategic optimization strategies to mastering the intricacies of joining data, this section equips you with the tools needed to streamline your analytical processes. Unlock the potential of Data Manipulation Language (DML) statements, empowering you to perform complex data transformations with ease.Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.- 1
BigQuery Architecture and Structure
FreeIn 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.
Introduction to BigQuery50 xpUnique attributes of BigQuery50 xpBigQuery, Snowflake, and Redshift100 xpBigQuery compared to a traditional SQL database100 xpStarting with e-commerce100 xpBigQuery Architecture50 xpClassifying BigQuery components100 xpOrdering the BigQuery architecture100 xpExecution trees inside Dremel100 xpBigQuery data organization50 xpTable structure100 xpBigQuery data rules50 xpTables in the wild100 xp - 2
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.
Writing queries in BigQuery50 xpExploring the course data with SQL100 xpFinding order total value100 xpUsing joins100 xpData ingestion in BigQuery50 xpLoading local data to BigQuery50 xpAcceptable data formats100 xpStructuring a LOAD DATA statement100 xpDate/time types in BigQuery50 xpFormatting dates for reports100 xpFormatting timestamps and dates100 xpFinding data within certain ranges100 xpUsing CURRENT_TIMESTAMP100 xpUnstructured data50 xpCreate an array in a query100 xpUse SEARCH with unstructured data100 xpUNNEST-ing Data100 xp - 3
Querying data in BigQuery
Learn how to query data using common table expressions, aggregations, and window functions.
Common table expressions50 xpFiltering data with CTEs100 xpOptimizing using CTEs100 xpUsing multiple CTEs100 xpAggregations50 xpClassifying aggregate functions100 xpUsing COUNTIF100 xpFiltering with HAVING100 xpANY_VALUE100 xpSpecial aggregations in BigQuery50 xpLogical aggregates100 xpUsing STRING_AGG and ARRAY_CONCAT_AGG100 xpApproximate statistical functions100 xpWINDOW Functions50 xpWriting a window query100 xpRANK and LEAD/LAG100 xpUsing row based WINDOW functions100 xpFiltering with QUALIFY100 xp - 4
Data management and optimization
Understand all join types in BigQuery, mange data with data manipulation, and optimize your queries.
Joins in BigQuery50 xpFinding the correct join type50 xpRIGHT, LEFT, and OUTER joins100 xpUNNEST with CROSS JOINs100 xpJoins with aggregations100 xpData manipulation language (DML) statements50 xpData manipulation types50 xpUsing conditions in DML statements100 xpConsiderations using DML statements100 xpQuery optimization strategies50 xpLimiting the amount of data100 xpFinding the last 90 days of orders100 xpPerform optimizations in BigQuery100 xpCongratulations!50 xp
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.collaborators
prerequisites
Data Manipulation in SQLMatt Forrest
See MoreField CTO
Matt Forrest, Field CTO at CARTO, champions innovation and learning in the tech sphere. With over 13 years of expertise, he guides individuals and organizations to advance their technical careers. His commitment to knowledge sharing is evident in his recent publication on Spatial SQL, highlighting his dedication to fostering technological progress.
What do other learners have to say?
Join over 15 million learners and start Introduction to BigQuery today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.