Bring your data to life in the cloud. In Snowflake: Loading and Querying Data, you’ll explore the essential, beginner-friendly steps to get data into Snowflake and make it useful fast. You’ll explore simple ways to load files (like CSV, JSON, and Parquet), understand where that data lives, and practice reliable patterns for both one-time and ongoing ingestion. Along the way, you’ll pick up practical setup tips so you can follow the same steps in your own account with confidence. Once your data is in, you’ll learn how to ask it good questions. Greg guides you through the basics of querying—selecting, filtering, joining, and summarizing—plus handy techniques for working with semi-structured data. You’ll see how to keep things speedy and cost-aware by choosing the right compute, and how features like views and simple best practices make your work easy to share and maintain. By the end, you’ll have an end-to-end workflow: load cleanly, query clearly, and deliver answers your team can trust.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 44m
Skills Learned
After completing this online training course, students will be able to:
Apply window functions for advanced analytical queries
Implement high availability and disaster recovery solutions
Apply learned concepts to real-world business challenges
Database Administrators
None
01. Introduction to High Availability
02. Replication (Snapshot Replication)
03. Replication (Transactional Replication)
04. Replication (Monitor Replication)
05. Replication (Summary)
06. Log Shipping (Setting Up Log Shipping to Single Secondary)
07. Log Shipping (Setting Up Log Shipping Monitor Server)
08. Database Mirroring
09. Windows Server Failover Cluster
10. Availability Groups (Setup and Configuration)
11. Availability Groups (Additional Considerations)
12. Basic Availability Groups
13. Clustering SQL Server
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Apply window functions for advanced analytical queries
Implement high availability and disaster recovery solutions
Apply learned concepts to real-world business challenges
WHO SHOULD ATTEND
Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. Introduction to High Availability
02. Replication (Snapshot Replication)
03. Replication (Transactional Replication)
04. Replication (Monitor Replication)
05. Replication (Summary)
06. Log Shipping (Setting Up Log Shipping to Single Secondary)
07. Log Shipping (Setting Up Log Shipping Monitor Server)
08. Database Mirroring
09. Windows Server Failover Cluster
10. Availability Groups (Setup and Configuration)
11. Availability Groups (Additional Considerations)
12. Basic Availability Groups
13. Clustering SQL Server
