Setting up Cloud Databases and Tables with Snowflake
|
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.
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.
Author Name: Thomas LeBlanc
Author Description:
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.
Table of Contents
- Course Overview
2mins - Building Snowflake Databases
15mins - Creating and Populating Snowflake Tables
23mins - Scaling the Snowflake Configuration
15mins
User Reviews
Be the first to review “Setting up Cloud Databases and Tables with Snowflake”
Related Products
Building a Successful, Multi-Cloud Strategy
More and more organizations find themselves juggling multiple cloud providers—some through careful planning, but many by happenstance. In this session, cloud expert Janani Ravi goes in-depth on how to build a successful hybrid, multi-cloud strategy.
Installing and Managing Salesforce Marketing Cloud Connect
This course will give you an overview of Marketing Cloud Connect and it’s features. After completing this course, you will be able to install and configure Marketing Cloud Connect and connect your Salesforce CRM instance with Marketing Cloud.
Leveraging Load Balancing Options on the GCP
Developers and app architects need to understand what kind of load balancer to choose, and why. This course covers the essential load balancing options available on the GCP and demonstrates their use in combination with other GCP technologies.
Configuration in Salesforce Marketing Cloud
This course will teach you how to set up Salesforce Marketing Cloud as an administrator: setting up business units, users, permission sets, API packages, FTP accounts, and general administration settings.
Introduction to the VCP-CMA Certification
This course provides an overview of the different certification paths VMware has to offer, introduces the VCP-CMA exam, and lines out some topics you should already be familiar with.
Deploying and Managing Windows Workloads on Google Cloud
This course teaches you about deploying and managing Microsoft Windows® workloads on Google Cloud. This course uses lectures and hands-on labs to show you how to plan and configure Microsoft Windows Server and Microsoft SQL Server in Google Cloud. You will configure identity solutions including Managed Service for Microsoft Active Directory, deploy Windows workloads to Compute Engine and Google Kubernetes Engine, and learn to manage and operate Windows workloads with Cloud Console, Cloud Logging, and Cloud Monitoring.
There are no reviews yet.