Simple play icon Course

Setting up Cloud Databases and Tables with Snowflake

by Thomas LeBlanc

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.

About the author

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.

Ready to upskill? Get started