Learning BigQuery
1h 59mBeginner2022-07-28
Authors
Kishan Iyer
Content Engineer, DevOps Expert, and Google Cloud Platform Power User
Course details
If you’re just getting started with BigQuery, this course was made for you. Find out why everyone’s talking about the cloud-hosted data warehouse on the Google Cloud Platform. Join software engineer and instructor Kishan Iyer as he gives you an overview of the skills you need to know to set up a BigQuery data warehouse.
Discover supercharged business intelligence with cost-effective solutions. Learn the basics of BigQuery for data-driven decision-making at scale. Explore tips and tricks to help you get the most out of this powerful and easy-to-use tool: building, modifying, and working with datasets and tables; executing queries and visualizing results; and creating views to save and store results for speedy analysis on the go. By the end of this course, you’ll also be primed to start using the bq command-line tool.
Discover supercharged business intelligence with cost-effective solutions. Learn the basics of BigQuery for data-driven decision-making at scale. Explore tips and tricks to help you get the most out of this powerful and easy-to-use tool: building, modifying, and working with datasets and tables; executing queries and visualizing results; and creating views to save and store results for speedy analysis on the go. By the end of this course, you’ll also be primed to start using the bq command-line tool.
Skills covered
BigQueryData EngineeringGoogleLearningData Science
Concepts
0. Introduction
- 01 - Introducing BigQuery
1. Introducing BigQuery
- 02 - BigQuery services and compute process
- 03 - The arrangement of data in BigQuery
- 04 - Data sources and queries in BigQuery
- 05 - The BigQuery cost structure
2. Creating and Working with Datasets and Tables
- 06 - Configuring the GCP
- 07 - Creating a BigQuery dataset
- 08 - Defining a BigQuery table from the UI
- 09 - Querying a simple BigQuery table
- 10 - Uploading data to create a BigQuery table
- 11 - Querying data and viewing statistics of queries
- 12 - Reading JSON data into a BigQuery table
- 13 - Creating a table from a query result
- 14 - Creating a table from a filter
3. Executing Queries and Visualizing Results
- 15 - Public datasets in BigQuery
- 16 - Configuring and using BigQuery caches
- 17 - External BigQuery tables
- 18 - Integrating BigQuery with Data Studio
- 19 - Geographic points in BigQuery
- 20 - Visualizing geographical data with Geo Viz
4. Creating and Working with Views
- 21 - Saving query results using views
- 22 - Querying views vs. querying the original tables
- 23 - Materialized views in BigQuery
- 24 - Defining a restricted view of data
- 25 - Granting a user project-level access
- 26 - Setting up an authorized view
5. Using the bq Command-Line Tool
- 27 - Configuring the bq shell
- 28 - Executing queries from the BigQuery command-line
Conclusion
- 29 - Summary and next steps