Data Science on Google Cloud Platform: Designing Data Warehouses

Focused View

Kumaran Ponnambalam

1:00:21

113 View

01 - Introduction

01 - Why data warehouses are important.mp4

01:03

02 - Data science modules covered.mp4

02:23

02 - 1. Storing Data in GCP

01 - GCP storage options.mp4

01:42

02 - Google Cloud Storage.mp4

02:20

03 - Cloud SQL.mp4

02:04

04 - Cloud Spanner.mp4

02:07

05 - Cloud Bigtable.mp4

02:14

06 - Cloud Datastore.mp4

02:11

07 - Cloud BigQuery.mp4

01:41

03 - 2. BigQuery Data Creation

01 - Intro to BigQuery.mp4

01:24

02 - Projects and datasets.mp4

01:32

03 - Tables.mp4

01:41

04 - Create a dataset.mp4

01:27

05 - Create a table with schema.mp4

04:11

06 - Create a table from CSV.mp4

01:20

07 - Load data from Cloud Storage.mp4

01:45

04 - 3. Querying Data in BigQuery

01 - Simple queries.mp4

02:04

02 - Filter data.mp4

01:20

03 - SQL functions.mp4

02:00

04 - Regular expressions.mp4

01:13

05 - Grouping and aggregations.mp4

00:52

06 - Joins and sub-queries.mp4

01:06

07 - Update data.mp4

01:10

05 - 4. Advanced BigQuery

01 - Partition tables.mp4

03:10

02 - External data sources.mp4

01:46

03 - Create views.mp4

00:49

04 - Create labels.mp4

02:09

05 - Google Cloud shell.mp4

01:05

06 - Other interfaces.mp4

01:22

06 - 5. Best Practices in BigQuery

01 - Table design considerations.mp4

01:39

02 - Optimize storage.mp4

01:48

03 - Load data.mp4

02:03

04 - Speed up queries.mp4

01:48

05 - Monitoring and logging.mp4

01:15

07 - Conclusion

01 - Next steps.mp4

00:37

Description

Cloud computing brings unlimited scalability and elasticity to data science applications. Expertise in the major platforms, such as Google Cloud Platform (GCP), is essential to the IT professional. This course—one of a series by veteran cloud engineering specialist and data scientist Kumaran Ponnambalam—shows how to design and build data warehouses using GCP. Explore the different types of storage options available in GCP for files, relational data, documents, and big data, including Cloud SQL, Cloud Bigtable, and Cloud BigQuery. Then learn how to use one solution, BigQuery, to perform data storage and query operations, and review advanced use cases, such as working with partition tables and external data sources. Finally, learn best practices for table design, storage and query optimization, and monitoring of data warehouses in BigQuery.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Warehouse

Google Cloud

Kumaran Ponnambalam

Instructor's Courses

A seasoned veteran in everything data, with a reputation for delivering high performance database and SaaS applications and currently specializing in leading Big Data Science and Engineering efforts

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.