Pass the SnowPro Core exam with confidence by mastering Snowflake's architecture, data loading, security, and performance fundamentals hands-on.
Curriculum covers
19 modules · 60 hours · 24 live sessions
After this course, you will
Hands-on learning
3 industry capstone projects · built from scratch · yours to keep
Create an AWS S3 external stage with an IAM storage integration object, configure a Snowpipe with S3 event notifications for automatic file ingestion, load structured CSV data into a Snowflake table, and validate results using COPY history views and the Snowsight Query Profile.
Analyse a slow-running query using the Snowflake Query Profile tool, apply clustering keys to a large table, create a materialized view for a high-frequency aggregation, enable the Search Optimization Service, and document measurable query performance improvements before and after each change.
Design a role hierarchy for a simulated company with department-level access boundaries, apply data masking policies to PII columns, create a direct share with a second Snowflake account, and publish a Marketplace listing — validating consumer data access at each step using multiple test user accounts.
Plus 16 guided mini-projects across the curriculum — Q&A bots, resume screeners, SQL helpers, and more.
⚡ Seats filling fast — only 7 remaining across all batches
| Batch Type | Schedule | Duration | Next Start Date | Availability |
|---|---|---|---|---|
| Weekend | Sat & Sun, 10am–1pm | 10 weeks | 12 Sept 2026 | Available |
| Weekday | Mon–Fri, 7–9pm | 8 weeks | 14 Sept 2026 | Available |
| Fast-track | Mon–Sun, 6 hours/day | 2 weeks | 21 Sept 2026 | Available |
Yes. SnowPro Core is Snowflake's foundational certification and the recommended entry point for anyone new to Snowflake. It validates understanding of architecture, data loading, security, and performance fundamentals that all advanced certifications build directly on.
The exam is challenging if you rely on memorisation alone. With the hands-on practice in this course — warehouses, stages, time travel, access control, and performance tuning — most candidates with some data warehousing background find the concepts very approachable and are exam-ready at completion.
Internal stages — user, table, and named internal stages — store files within Snowflake's managed cloud storage. External stages reference cloud storage you own (AWS S3, Azure Blob, or GCS) and use a storage integration object for secure, credential-free access.
Snowflake uses three cache layers: the query result cache returns identical queries instantly from memory; the metadata cache avoids scanning for COUNT, MIN, and MAX operations; and the local warehouse disk cache stores recently scanned micro-partitions. All three are key exam topics and major performance levers in practice.
Yes. The course covers all sharing mechanisms: direct sharing between accounts, reader accounts for consumers without a Snowflake subscription, the Data Exchange for private group sharing, and the public Snowflake Marketplace for publishing or subscribing to third-party data listings.
Most students with some data warehousing background are exam-ready after completing the full 60-hour curriculum and hands-on labs. The programme is structured to take 8-10 weeks part-time, aligning with the Weekend and Weekday batch schedules.
Download the curriculum to see every module, batch dates and fees. Book a free 30-minute session with our advisors to get your questions answered.
Book Free DemoSee every module, capstone project, and tool covered — free, instant access.
