Advanced BigQuery

Focused View

Kishan Iyer

2:14:53

95 View

01.01-making the most of bigquery.mp4

02:42

02.01-partitioning and clustering.mp4

04:44

02.02-creating a bigquery data set.mp4

02:54

02.03-loading data into a table.mp4

04:38

02.04-creating a partitioned table.mp4

04:17

02.05-querying a partitioned table.mp4

05:23

02.06-partitioning on an integer column.mp4

04:44

02.07-understanding integer-based partitions.mp4

02:56

02.08-partitioning on ingestion time.mp4

05:38

03.01-defining a clustered table.mp4

05:41

03.02-querying a clustered table.mp4

04:59

03.03-combining partitioning and clustering.mp4

04:32

04.01-working with composite data.mp4

01:53

04.02-creating tables with nested fields.mp4

05:00

04.03-inserting nested data.mp4

04:36

04.04-querying nested data.mp4

05:05

04.05-aggregating data using array agg.mp4

03:28

04.06-performing windows operations.mp4

04:32

05.01-simplifying bigquery tasks.mp4

03:23

05.02-setting up the source and destination for a transfer.mp4

05:51

05.03-configuring user permissions for a transfer.mp4

02:41

05.04-defining a scheduled transfer.mp4

05:26

05.05-running an ad-hoc transfer.mp4

04:45

06.01-granting access to data sets.mp4

05:50

06.02-permissions on bigquery tables.mp4

05:47

06.03-revoking permissions in bigquery.mp4

02:26

06.04-restricting access to derived data.mp4

05:31

06.05-monitoring bigquery usage.mp4

02:53

06.06-snapshots.mp4

03:38

07.01-creating a service account.mp4

04:12

07.02-connecting to bigquery with python.mp4

04:06

08.01-next steps.mp4

00:42

Description

If you’re already using BigQuery for your data warehouse, you may be ready to take your next step. But the sheer array of available solutions can get a little overwhelming. In this course, software engineer and instructor Kishan Iyer shows you how to use advanced skills and techniques to get the most out of your BigQuery experience.

Learn to apply table partitioning and clustering to improve query performance and reduce data processing costs. Find out how to use nested data structures, regulate access to datasets and tables, monitor resource utilization, and access BigQuery programmatically, even from external services. Along the way, Kishan walks you through populating tables with the data transfer service.

This course was created by Kishan Iyer. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Google BigQuery

Kishan Iyer

Instructor's Courses

I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.