Introduction to SQL Using Google BigQuery

Focused View

Danny Ma

3:20:51

14 View

01 - Introduction

01 - Kick-start your BigQuery journey.mp4

00:29

02 - What you should know.mp4

01:14

03 - Introduction to Google BigQuery.mp4

03:46

02 - 1. Google BigQuery Setup

01 - Case study introduction.mp4

01:36

02 - Set up BigQuery sandbox.mp4

04:16

03 - Loading data into BigQuery.mp4

06:33

03 - 2. Data Exploration

01 - SELECT statement.mp4

09:29

02 - ORDER BY clause.mp4

04:53

03 - WHERE clause conditional logic.mp4

05:55

04 - WHERE clause BETWEEN and IN.mp4

07:06

05 - Fuzzy string matching.mp4

05:47

06 - COUNT function.mp4

06:35

07 - Calculation functions.mp4

07:58

08 - Challenge Wisdom Pet, quiz 1.mp4

01:47

09 - Solution Wisdom Pet, quiz 1.mp4

10:48

04 - 3. Data Aggregation

01 - GROUP BY clause.mp4

08:34

02 - CASE WHEN statements.mp4

08:47

03 - COUNTIF function.mp4

10:18

04 - PIVOT function.mp4

08:38

05 - Challenge Financial analysis.mp4

01:08

06 - Solution Financial analysis.mp4

08:54

05 - 4. Table Joins

01 - Introduction to table joins.mp4

05:07

02 - INNER JOIN.mp4

08:55

03 - LEFT JOIN.mp4

09:58

04 - Challenge Wisdom Pet, quiz 2.mp4

01:03

05 - Solution Wisdom Pet, quiz 2.mp4

09:00

06 - 5. Window Functions

01 - Introduction to window functions.mp4

05:01

02 - Ranking functions.mp4

06:31

03 - Cumulative metrics.mp4

07:52

04 - Moving averages.mp4

11:08

05 - Challenge Wisdom Pet, quiz 3.mp4

01:15

06 - Solution Wisdom Pet, quiz 3.mp4

09:08

07 - Conclusion

01 - Next steps.mp4

01:22

Description

As more and more companies adapt to cloud platforms—which are tailor-made for analytics and machine learning—many companies are also moving away from Amazon Web Services and trying alternative cloud vendors. Google Big Query has been gaining steam in the market in recent years, and provides some game-changing technology in the modern data landscape. In this course, instructor Danny Ma shows data professionals how to be productive and effective using GBQ and use the power of the cloud to analyze data at scale. If you have some SQL experience and want to learn what’s available on a modern cloud platform, join Danny in this course to see how BigQuery can help jumpstart your data career.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Google BigQuery

Danny Ma

Instructor's Courses

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.