Setting up Cloud Databases and Tables with Snowflake

Focused View

Thomas LeBlanc

57:13

113 View

1. Course Overview

1. Course Overview.mp4

02:07

2. Building Snowflake Databases

1. Building Snowflake Databases.mp4

02:01

2. Demo - Setup Files and Navigating Databases.mp4

04:39

3. Roles and Worksheets.mp4

02:18

4. Snowflake Databases.mp4

02:31

5. Demo - Create a Database.mp4

01:19

6. Compute with Warehouses.mp4

02:10

7. Summary - Building Snowflake Databases.mp4

00:25

3. Creating and Populating Snowflake Tables

1. Snowflake Table Properties.mp4

03:33

2. Demo - Create Schema with Table and Insert Data.mp4

04:42

3. More About Tables.mp4

02:59

4. Demo - Loading Data to Stage and Transient Tables.mp4

05:57

5. Other Table Objects.mp4

03:01

6. Demo - Using a Sequence with Dimension Insert.mp4

03:36

4. Scaling the Snowflake Configuration

1. Virtual Warehouses.mp4

03:45

2. Demo - Virtual Warehouses.mp4

04:13

3. Using Compute for Merging Data.mp4

04:54

4. Continuous Loading of Data with Snowpipe.mp4

03:03

Description

This course will teach you how to use Snowflake for creating databases and tables plus using the SQL language for inserting and extracting data in a cloud data warehouse.

What You'll Learn?

Snowflake is the first cloud data warehouse designed from the ground up and integrated with all the major cloud providers. In this course, Setting Up Cloud Database and Tables with Snowflake, you'll learn the ins and outs of cloud data warehousing with Snowflake. First, you'll explore the virtual warehouse used as compute for Snowflake. Next, you'll discover the SQL language used to create schemas and tables plus inserting data using Snowflake databases. Finally, you'll learn how to manage the workloads through virtual warehouses when additional data must be added and retrieved to a data mart for reporting. When you're finished with this course, you'll have the skills and knowledge of Snowflake databases, virtual warehouses, and tables needed to be a data analyst or database administrator for cloud data warehouses in Snowflake.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Database Programming

Cloud Computing

Thomas LeBlanc

Instructor's Courses

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.

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.