Fundamentals of BigQuery
Google Cloud 2018
| Intermediate
- 10 Videos | 1h 13m 22s
- Includes Assessment
- Earns a Badge
BigQuery is an essential tool for any data analyst using Google Cloud Platform. Explore BigQuery and examine several operations including multiple table queries, nested and repeated fields and building BigQueries.
WHAT YOU WILL LEARN
-
Define BigQuery and its use in GCPrecognize concepts in BigQuery datasets, tables and viewsdescribe the process of executing queriesdescribe how to load data into BigQuerydescribe how to export data into GCP BigQuery
-
define the process of querying nested and repeated fieldsdemonstrate query plans and complex queries using BigQuerydescribe the process of querying with multiple tablesdemonstrate how to write query results, use cached queries, use parameterized queries and save and sharing queries in BigQueryrecognize the main concepts and operations behind BigQuery
IN THIS COURSE
-
1.Introduction to BigQuery3m 48sUP NEXT
-
2.BigQuery Exploring Datasets, Tables and Views6m 49s
-
3.Writing Queries with BigQuery6m 36s
-
4.Big Query - Loading Data5m
-
5.Exporting with BigQuery7m 7s
-
6.Using Nested and Repeated Fields7m 2s
-
7.Using Complex Queries8m 29s
-
8.Multiple Table Queries6m 52s
-
9.Building BigQuery Queries8m 23s
-
10.Exercise: BigQuery Concepts and Operations13m 16s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.