Achieving Advanced Insights with BigQuery

Focused View

Google Cloud

3:25:51

24 View

01 - Introduction

01 - Course Intro.mp4

02:04

02 - Getting started with GCP and Qwiklabs.mp4

03:48

02 - Advanced Functions and Clauses

03 - Advanced Functions - Statistical and Approximations.mp4

07:55

04 - Analytic Functions, WITH clause, and RANK().mp4

18:04

05 - BigQuery User-Defined Functions (UDFs).mp4

04:52

06 - Sub-query and CTE design.mp4

03:32

07 - Lab Overview.mp4

00:15

08 - Deriving Insights from Advanced SQL Functions v1.5.mp4

00:10

09 - Lab Solution.mp4

11:01

03 - Schema Design and Nested Data Structures

10 - Background -Traditional Relational Database Architecture.mp4

11:01

11 - Denormalized, Column-Based Storage.mp4

04:25

12 - Table Sharding.mp4

07:30

13 - Introducing Nested and Repeated Fields.mp4

03:58

14 - Working with Arrays and Structs in BigQuery.mp4

21:28

15 - BigQuery Standard SQL vs Legacy SQL.mp4

01:08

16 - Practicing SQL on Repeated Fields in BigQuery.mp4

08:23

17 - Data to Insights - Practicing Querying Nested and Repeated Fields v1.1.mp4

00:10

18 - Lab Solution Walkthrough.mp4

11:57

04 - More Visualization with Google Data Studio

19 - Advanced Data Studio -Case Statements and Filters.mp4

16:20

20 - Sharing Dashboards and Data Access Pitfalls.mp4

01:51

05 - Optimizing for Performance

21 - Avoid BigQuery Performance Pitfalls.mp4

09:25

22 - Data Skew in your Datasets.mp4

01:15

23 - Diagnose Performance Issues with the Query Explanation map.mp4

19:10

24 - Lab Overview.mp4

00:18

25 - Data to Insights - Optimizing and Troubleshooting Query Performance v1.1.mp4

00:10

26 - Lab Solution Walkthrough.mp4

05:45

06 - Advanced Insights with Cloud Datalab

27 - Introducing Cloud Datalab.mp4

03:22

28 - Demo -Cloud Datalab Notebook Cells.mp4

09:12

29 - Benefits of Cloud Datalab.mp4

02:03

07 - Data Access

30 - Data Access Roles, Creating Authorized Views, and Common Pitfalls.mp4

13:08

08 - Summary

31 - Course Recap.mp4

02:11

Description

Achieving Advanced Insights with BigQuery will build on your growing knowledge of SQL as we dive into advanced functions and how to break apart a complex query into manageable steps. We will cover the internal architecture of BigQuery (column-based sharded storage) and advanced SQL topics like nested and repeated fields through the use of Arrays and Structs. Lastly we will dive into optimizing your queries for performance and how you can secure your data through authorized views.

What You'll Learn?

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Google BigQuery

Google Cloud

Instructor's Courses

Google Cloud can help solve your toughest problems and grow your business. With Google Cloud, their infrastructure is your infrastructure. Their tools are your tools. And their innovations are your innovations.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.