Snowflake is the leading solution for warehousing in the cloud. It is built for the cloud. Snowflake delivers the performance, concurrency and simplicity needed to store and analyze an organization’s data in one complete solution. Snowflake’s technology combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions.
NOTE: This course is Vendor Independent training, using independent content, and not affiliated with Snowflake official education.
Working within an engaging, hands-on learning environment led by our expert practitioner, attendees will explore:
Optional Additional Topics can include:
Need different skills or topics? If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate. We offer additional Snowflake, data analytics, data warehousing, scripting, cloud, visualization and other related topics that may be blended with this course for a track that best suits your needs. We will collaborate with you to design a targeted skills-focused agenda that meets your unique needs and goals.
This is an Intermediate level course designed for DevOps team members, Developers, and Managers who possess a strong IT background and basic SQL skills.
Next Steps / Follow-On Training: We offer a wide array of Analytics, DevOps, Programming, Cloud or other related hands-on, skills-focused courses. Please contact us for recommendations for next steps in your learning journey based on your unique needs and goals.
Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We will work with you to tune this course and level of coverage to target the skills you need most.
Getting Started with Snowflake
Building a Virtual Warehouse
Getting Started with SnowSQL
Continuous Data Loading with SnowPipe
Snowflake Security Overview
Optional Additional Topics
Snowflake objects
Caching in Snowflake and How different caching types works
Reading a Query Profile & How it helps
Data Loading
Roles and Inheritance
Semi-Structured Data
Building Semi-structured from Relational (using object_construct function)
External Stage Vs. External Tables Vs. External Tables +
Materialized Views
Snowflake - Python Connector, Spark Connector
Each student will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and links (as applicable). Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.
Lab Setup Made Simple. All course labs and solutions, data sets, Tableau course software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.
Live scheduled classes are listed below or browse our full course catalog anytime
Check out custom training solutions planned around your unique needs and skills.
Exclusive materials, ongoing support and a free live course refresh with every class.
Mix, Match & Master!
2FOR1: Two Courses, One Price!
Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price! Learn something new, or share the promo!
Special Offers
Limited Offer for most courses.
SAVE 50%