When does class start/end?
Class hours may vary, please reach out to contact@ascendientlearning.com if you have any questions.
Comprehensive Snowflake
This Comprehensive Snowflake training course covers fundamental and advanced Snowflake architecture and teaches best practices for configuring and deploying a Snowflake cloud-based database....
Read MoreOverview
This Comprehensive Snowflake training course covers fundamental and advanced Snowflake architecture and teaches best practices for configuring and deploying a Snowflake cloud-based database. Attendees take their skills to the next level to build an RBAC (role-based access control) hierarchy, incorporate a disaster recovery plan, optimize performance, and create automated workflows in Snowflake.
Skills Gained
- Describe the basics of Cloud, Data Warehouse, ETL/ETL, and Data Analytics
- Examine the architecture of Snowflake
- Examine Snowflake's key features
- Connect to Snowflake and assign roles
- Create database objects in Snowflake
- Ingest structured and unstructured data into Snowflake
- Ingest streaming data using Snowpipe
- Clone database objects
- Share Data using Web UI
- Un-drop database objects using SQL Commands
- Describe advanced Snowflake architecture features and functionality
- Design and build an RBAC hierarchy
- Share data from inside or outside of an organization
- Incorporate Snowflake into a disaster recovery plan
- Use performance tuning and resource management features to optimize Snowflake
- Leverage advanced caching features to enhance performance
- Enhance continuous data pipelines with scheduled tasks to create an automated workflow
Prerequisites
Students must have a basic knowledge of the Snowflake user interface and execution of SnowSQL.
Course Details
Training Materials
All Snowflake training students receive comprehensive courseware.
Software Requirements
All attendees will need access to a Snowflake SQL environment with Ascendient Learning’s sample data loaded.
Outline
- Introduction to Cloud and Data Warehouses
- Introduction to Cloud
- Why Cloud?
- Cloud Providers
- SaaS, PaaS, IaaS
- What is a Data Warehouse
- Why Data Warehouse
- Data Warehouse Basic
- Data Integration and Analytics
- ETL/ELT
- Batching vs. Streaming
- Data Analytics & Visualizations
- On-Prem Vs. Cloud
- Introduction to Snowflake
- What is Snowflake
- Snowflake History
- Datawarehouse as a Service
- Supported Cloud platforms & Regions
- Snowflake UI
- Query Pane
- Result Pane
- Object Navigation Pane
- Different Tabs
- Examine Snowflake UI
- Snowflake Architecture
- Introduction to Snowflake Architecture
- 3 Tier Architecture
- Data Storage
- Query Processing
- Cloud Services
- Snowflake Feature
- Security & Data Protection
- Standard & Extended SQL
- Tools & Interfaces
- Connectivity
- Data Import & Export
- Data Sharing
- Database Replication & Failover
- Continuous Data Protection
- Connecting to Snowflake and Assigning Roles
- Connecting to Snowflake
- Snowflake Roles
- Snowflake Editions
- Creating Database Objects
- Create Database objects
- Stage Files
- Create Objects in Snowflake
- Structure Data Ingestion
- Structured Data Ingestion
- Data Staging
- Bulk load from Cloud Storage
- Bulk load from Local Storage
- Query Data
- Unstructured Data Ingestion
- Unstructured Data Ingestion
- JSON Ingestion
- Query Data
- Stream Data Ingestion
- Introduction to Snowpipe
- How to Create Pipe
- How to Load Streaming Data
- How Query Data
- Ingesting Streaming Data
- Clone Database Objects
- Zero Copy Cloning
- How to Clone a Database
- How to Clone a Schema
- How Clone Tables and Views
- Cloning a Database
- Data Sharing
- What is Data Share
- Data Providers
- Data Consumers
- Share with Snowflake users
- Using Wed UI to Share
- Share Data with Snowflake and Non-Snowflake
- Un-drop Database Objects
- Un-drop Database Objects
- SQL Commands
- Advanced Snowflake Architecture
- Three Tiered Architecture
- Micro-Partitioning in Snowflake
- Snowflake Clustering
- Building an RBAC Hierarchy
- Role Hierarchies
- Multifactor Authentication and Authorization
- Security Best Practices
- Snowflake Roles
- Connecting Snowflake
- Data Sharing and Disaster Recovery
- Overview of Time Travel and Copy Cloning
- Data Sharing
- Overview of Disaster Recovery
- Disaster Recovery with Snowflake
- Performance Tuning and Resource Management
- Designing High-Performance Tables and Queries
- Resource Usage and Billing
- Multi-clustering and Clustering Keys
- Scaling
- Performance Tuning
- How Caching Improves Performance
- Temp Tables
- Transient Tables
- Snowflake Caching Features
- Advanced Caching
- Tasks and Scheduling Management
- Integrating Stored Procedures, Views, and Functions
- Tasks and Scheduling
- Enhance Continuous Data Pipeline
- Conclusion
Schedule
FAQ
Does the course schedule include a Lunchbreak?
Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.
What languages are used to deliver training?
Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.
What does GTR stand for?
GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.
How do I find an Ascendient Learning training location?
We have training locations across the United States and Canada - View a complete list of classroom training locations.
Which delivery formats are available?
At Ascendient Learning, we offer training that is Instructor-Led, Online, Virtual, and Self-Paced.
Does Ascendient Learning deliver group training?
Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.
What does vendor-authorized training mean?
As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.
Is the training too basic, or will you go deep into technology?
It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.
How up-to-date are your courses and support materials?
We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.
Are your instructors seasoned trainers who have deep knowledge of the training topic?
Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.
Do you provide hands-on training and exercises in an actual lab environment?
Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.
Will you customize the training for our company’s specific needs and goals?
We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.
How do I get started with certification?
Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.
Will I get access to content after I complete a course?
You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.
How do I request a W9 for Ascendient Learning?
View our filing status and how to request a W9.
Reviews
Instructor knew her stuff. Long time in the industry. Course was easy to follow and very informative.
They are very good and made sure we had all the appropriate materials for class.
Class was very informative, although one lab didnt but will try again later
the course is good, covers many aspects, wish the lab is a little bit more in depth
it was good and very informative. Instructure covered everything in detail.
