Brolly Academy | Snowflake

Snowflake Syllabus and Course Fees in India

14 Modules, Labs, SnowPro Core Mapping and Course Fees in India (2026)

A complete 2026 Snowflake syllabus in 14 modules, each with topics, a mini lab and a clear outcome, plus beginner and advanced tracks, a mapping to the SnowPro Core exam, and an honest guide to Snowflake course fees in India: what is free, what costs money, the hidden costs and how to judge value before you pay.

Snowflake syllabus for 2026: 14 modules with a weekly plan, labs and outcomes, SnowPro Core mapping, plus Snowflake course fees in India and how to judge.

14 Modules Weekly Plan Course Fees Updated 9 Nov 2026
Share

By Brolly Academy Team · Brolly Academy · Updated 24 October 2026

Snowflake syllabus guide - Brolly Academy

Quick answer

A good Snowflake syllabus in 2026 covers 14 areas: SQL and warehousing basics, architecture, virtual warehouses, data loading and stages, semi-structured data, Time Travel and cloning, security and RBAC, streams, tasks and dynamic tables, performance and cost, Snowpark, data sharing, Cortex AI, dbt and orchestration, and certification prep. You can finish it in about 12 weeks of self-study at one to two hours a day. Fees range from zero (Snowflake's own on-demand courses are free) to paid classroom or live online courses, and the SnowPro Core exam is a separate cost: $175 per attempt, or $140 if you take it in India (Snowflake certification FAQ, October 2026).

  • Core modules: SQL, architecture, warehouses, loading, JSON, Time Travel, RBAC, streams and tasks, cost control
  • 2026 modules: Snowpark, dynamic tables, Cortex AI Functions, dbt
  • Free: Snowflake's on-demand courses and many Hands-On Essentials badges
  • Paid: classroom and live online courses, paid instructor-led training, practice exams, the exam itself

Key takeaways

  1. Judge a Snowflake syllabus by its labs, not its module count. Every module should end with something you build in a real Snowflake account.
  2. SQL appeared in all 14 Snowflake job descriptions we read on 25 October 2026, and dbt and Python each appeared in 9, so give those skills real time.
  3. The SnowPro Core exam (COF-C03) has five weighted domains, and a sound syllabus covers all five.
  4. A course fee and a certification fee are two different bills, so ask before you assume an exam voucher is included.
  5. Check any syllabus for retired products such as Document AI and for 2026 topics before you pay.

1. Snowflake syllabus at a glance

Short answer: The syllabus below runs over 12 weeks and moves from SQL basics to pipelines, performance, Snowpark, AI features and exam prep, with one mini lab per module.

New to the platform? Read what Snowflake does first. Use this table as your checklist, or print or save it as your own syllabus PDF.

Module Main topics Suggested week 1. SQL and warehousing basics SELECT, joins, GROUP BY, window functions, OLTP vs OLAP, star and snowflake schemas Week 1 2. Architecture and editions Storage, compute and cloud services layers, clouds, India regions, editions Week 2 3. Virtual warehouses Sizes, credits, auto-suspend, multi-cluster, Gen2 and Adaptive Warehouses Week 2 4. Loading and stages Stages, file formats, PUT, COPY INTO, Snowpipe, unloading Week 3 5. Semi-structured data VARIANT, JSON, Parquet, FLATTEN Week 4 6. Time Travel and cloning AT and BEFORE, UNDROP, retention, Fail-safe, zero-copy cloning Week 4 7. Security and RBAC System roles, custom roles, grants, MFA, key-pair auth, network policies, masking Week 5 8. Streams, tasks and dynamic tables Change tracking, scheduled tasks, task graphs, dynamic tables Week 6 9. Performance and cost Caching, Query Profile, clustering keys, resource monitors, ACCOUNT_USAGE Week 7 10. Snowpark Python DataFrames, UDFs, stored procedures, Snowpark-optimized warehouses Week 8 11. Data sharing Shares, reader accounts, listings, Marketplace Week 9 12. Cortex AI and Snowflake CoWork Cortex AI Functions, Cortex Search, Cortex Analyst, agents Week 9 13. dbt and orchestration dbt models and tests, dbt Projects on Snowflake, Airflow concepts Week 10 14. Certification prep and capstone SnowPro Core domains, practice, one end-to-end project Weeks 11 to 12

Before you start, check our guide to Snowflake prerequisites. Comfortable SQL matters more than anything else.

2. Module 1: SQL and data warehousing basics

Short answer: Snowflake is a SQL platform first, so the first week builds the SQL and data warehousing basics that every later module depends on.

Topics:

  • SELECT, WHERE, ORDER BY, GROUP BY and HAVING
  • Joins, common table expressions (CTEs) and window functions such as ROW_NUMBER
  • OLTP (transactions) vs OLAP (analytics)
  • ETL vs ELT. ELT means you load raw data first and transform it inside the warehouse
  • Fact and dimension tables, star schema and snowflake schema

Mini lab: On a small sales table, write daily totals, top five products per city with ROW_NUMBER, and a LEFT JOIN that keeps customers with no orders. Our Snowflake SQL tutorial covers these patterns.

Outcome: You can write the SQL every Snowflake job asks for. In the 14 Snowflake job descriptions we read on Naukri and LinkedIn on 25 October 2026, SQL appeared in all of them and five asked for data modelling.

3. Module 2: Architecture and editions

Short answer: This module explains how Snowflake separates storage, compute and services, which clouds and regions it runs in, and what each edition adds.

Topics:

  • The three layers: database storage, compute (virtual warehouses) and cloud services (security, metadata, query optimisation)
  • Micro-partitions: automatic storage units of about 50 MB to 500 MB of uncompressed data, stored column by column (Snowflake documentation, October 2026)
  • Clouds: Amazon Web Services, Microsoft Azure and Google Cloud
  • India regions: AWS Asia Pacific (Mumbai) and Azure Central India (Pune). There is no Google Cloud region in India
  • Editions: Standard, Enterprise, Business Critical and Virtual Private Snowflake (VPS)
  • The billing model: compute in credits, storage per TB per month, and data transfer

Mini lab: In a trial account, find your cloud and region in Snowsight, then sketch the three layers with one example of what lives in each.

Outcome: You can explain why two teams can run heavy queries at once without slowing each other down.

4. Module 3: Virtual warehouses and credits

Short answer: A virtual warehouse is the compute cluster that runs your queries; this module teaches you to size it, pause it and pay only for what you use.

Topics:

  • Credits per hour: X-Small uses 1 and each size doubles, up to 512 for 6X-Large. A credit is Snowflake's unit of compute billing
  • Per-second billing with a 60-second minimum; auto-suspend and auto-resume on by default
  • Multi-cluster warehouses (Enterprise Edition or higher) with Standard and Economy scaling policies
  • Gen2: new standard warehouses default to Gen2 where it is available
  • Adaptive Warehouses, generally available on AWS since 16 June 2026, where Snowflake manages size and scaling

These facts come from Snowflake documentation (October 2026). Credit prices vary by cloud, region and edition.

Mini lab: Create an X-Small warehouse, run a query, watch it suspend, then resize it and compare time and credits. Our Snowflake tutorial has a step-by-step version.

Outcome: You can choose a warehouse size and explain its cost.

5. Module 4: Data loading, stages and Snowpipe

Short answer: This module teaches how files get into Snowflake: through stages, file formats, the COPY INTO command and Snowpipe for continuous loading.

Topics:

  • Stages: a stage is a named location for files before loading. Internal stages are the user stage (@~), table stage (@%table) and named stage; external stages point to S3, Azure or Google Cloud Storage
  • Storage integrations for secure access to cloud buckets
  • File formats: CSV, JSON and Parquet for loading and unloading; Avro, ORC and XML for loading only
  • PUT to upload local files. PUT cannot run from a Snowsight worksheet; use Snowflake CLI, a driver or the Snowsight upload screen
  • COPY INTO a table for bulk loads, and COPY INTO a location for unloading
  • Snowpipe: a serverless service that loads files automatically as they land in cloud storage

-- Simplified example: a pipe-delimited CSV format and a named internal stage
CREATE OR REPLACE FILE FORMAT my_csv_format
  TYPE = CSV
  FIELD_DELIMITER = '|'
  SKIP_HEADER = 1;

CREATE STAGE my_int_stage
  ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE');

Mini lab: Upload an orders CSV with Snowflake CLI, load it with COPY INTO, break one row on purpose and read the error.

Outcome: You can load files from your laptop and a cloud bucket. Snowpipe appeared in four of the 14 job descriptions we read. Snowflake documentation (October 2026) calls SnowSQL a legacy client in maintenance mode and Snowflake CLI the preferred client, so teach Snowflake CLI.

6. Module 5: Semi-structured data

Short answer: Snowflake stores JSON and similar data in a VARIANT column, and this module teaches you to load it, query nested fields and flatten arrays into rows.

Topics:

  • The VARIANT data type for semi-structured data such as JSON, Avro and Parquet
  • Dot and bracket notation for nested fields, and casting to proper types
  • FLATTEN to turn arrays into rows

Mini lab: Load a JSON file of orders, each holding an array of items, and return one row per item.

Outcome: You can handle API and app data, common in retail and fintech projects at Hyderabad and Bengaluru GCCs (global capability centres).

7. Module 6: Time Travel, Fail-safe and cloning

Short answer: Time Travel lets you query or restore data as it was in the past, and zero-copy cloning makes instant copies, so this module is about recovery and safe testing.

Topics:

  • Time Travel: query old data with AT or BEFORE, and restore dropped objects with UNDROP
  • Retention: 1 day by default; Standard Edition allows 0 or 1 day, Enterprise and higher allow up to 90 days for permanent objects
  • Fail-safe: a fixed 7-day period after Time Travel ends, where only Snowflake Support can attempt recovery
  • Zero-copy cloning of tables, schemas and databases, including a clone at a past point in time

These rules are from Snowflake documentation (October 2026).

Mini lab: Delete rows, recover them with Time Travel, drop and UNDROP the table, then clone it. Our Snowflake Time Travel lab has the steps.

Outcome: You can recover from common mistakes and explain Time Travel vs Fail-safe.

8. Module 7: Security, RBAC and governance

Short answer: This module covers who can see and change what: roles, grants, authentication and data policies.

Topics:

  • RBAC (role-based access control): privileges go to roles, and roles go to users
  • System roles: ACCOUNTADMIN, SECURITYADMIN, USERADMIN, SYSADMIN, PUBLIC; ORGADMIN is being phased out for GLOBALORGADMIN
  • MFA (multi-factor authentication): Snowflake is ending single-factor password sign-in in three phases, the last for all human users scheduled for August to October 2026 (Snowflake calls these dates estimates)
  • Key-pair authentication, network policies, masking and row access policies

Mini lab: Create an analyst role that reads one schema only, grant it to a test user, and prove the user cannot drop a table.

Outcome: You can set up safe team access. RBAC or security appeared in three of the 14 job descriptions we read.

9. Module 8: Streams, tasks and dynamic tables

Short answer: Streams track changes, tasks run SQL on a schedule, and dynamic tables keep a query result fresh, so together they automate pipelines inside Snowflake.

Topics:

  • Streams: record inserts, updates and deletes on a table for change data capture (CDC)
  • Tasks: run SQL or a stored procedure on a schedule or when a stream has data. A new task starts suspended until you resume it
  • Task graphs that chain tasks in order
  • Dynamic tables: a table defined by a query that Snowflake refreshes to a target lag (minimum 60 seconds)

-- Simplified example: an hourly task and a dynamic table
CREATE TASK scheduled_t1
  WAREHOUSE = 'COMPUTE_WH'
  SCHEDULE = '60 MINUTES'
  AS SELECT 1;
ALTER TASK scheduled_t1 RESUME;

CREATE OR ALTER DYNAMIC TABLE dt_orders
  TARGET_LAG = '10 minutes'
  WAREHOUSE = transform_wh
  REFRESH_MODE = INCREMENTAL
  AS SELECT order_id, amount FROM raw_orders
     WHERE order_status != 'returned';

Mini lab: Build a stream on raw orders and an hourly task that merges new rows into a clean table, then rebuild it as a dynamic table. Our streams and tasks lab covers the MERGE step.

Outcome: You can automate an incremental pipeline. Streams and tasks appeared in four of the job descriptions we read.

10. Module 9: Performance tuning and cost control

Short answer: This module teaches you to find slow queries, fix them and stop surprise bills.

Topics:

  • Result, metadata and warehouse caches
  • Query Profile: spills, big scans and exploding joins
  • Clustering keys for very large tables
  • Resource monitors: warehouse credit limits that notify or suspend (serverless and AI services need budgets instead)
  • ACCOUNT_USAGE views such as QUERY_HISTORY, which can lag by 45 minutes to 3 hours

-- Simplified example: suspend a warehouse at its monthly credit quota
CREATE OR REPLACE RESOURCE MONITOR limit1
  WITH CREDIT_QUOTA = 1000
  TRIGGERS ON 100 PERCENT DO SUSPEND;
ALTER WAREHOUSE wh1 SET RESOURCE_MONITOR = limit1;

Mini lab: Run a slow join, read its Query Profile, fix it, and add a resource monitor to your trial warehouse.

Outcome: You can tune a query and control spend. Resource monitors and cost work appeared in four of the job descriptions we read.

11. Module 10: Snowpark

Short answer: Snowpark in Snowflake lets you write Python, Java or Scala code that runs inside Snowflake, so this module is the bridge from SQL to data engineering and ML work.

Topics:

  • Snowpark libraries for Python, Java and Scala
  • Lazy DataFrames: your code builds a plan that Snowflake runs as SQL only when an action such as collect runs
  • Python UDFs (user-defined functions) and stored procedures
  • Snowpark-optimized warehouses for memory-heavy jobs
  • Snowflake Notebooks for Python, SQL and Markdown cells in Snowsight

Mini lab: Read the orders table as a DataFrame, filter and group it, save the result as a table, then wrap the logic in a Python stored procedure.

Outcome: You can automate logic that is awkward in SQL. Python appeared in 9 of the 14 job descriptions we read, and Snowpark in two. The SnowPro Specialty: Snowpark exam (SPS-C01) retires on 1 November 2026, so learn Snowpark for the job, not that exam. Our Snowpark in Snowflake guide goes deeper.

12. Module 11: Secure Data Sharing

Short answer: Snowflake can share live data with another account without copying it, and this module covers shares, reader accounts and listings.

Topics:

  • Shares: the provider adds objects and consumer accounts; the consumer creates a read-only database from the share
  • Who pays: consumers pay for the compute they use, providers pay storage
  • Reader accounts for partners who do not have Snowflake, owned and paid for by the provider
  • Direct shares work within one region; cross-region sharing uses listings or replication
  • Listings and Snowflake Marketplace: private listings for named consumers, public listings on the Marketplace

Mini lab: With a classmate's trial account, share one table, query it as the consumer, then revoke access.

Outcome: You can explain data sharing, part of the SnowPro Core Data Collaboration domain.

13. Module 12: Cortex AI and Snowflake CoWork

Short answer: Snowflake's AI features let you call large language models from SQL and build agents over your data, so a 2026 syllabus should introduce them.

Topics:

  • Cortex AI Functions (formerly AISQL) such as AI_COMPLETE, AI_CLASSIFY, AI_SENTIMENT and AI_EXTRACT; some are in preview and availability is limited to select regions
  • Cortex Search and Cortex Analyst
  • Cortex Agents, Snowflake CoWork (formerly Snowflake Intelligence) and the Snowflake-managed MCP server (MCP, or Model Context Protocol, lets AI apps call tools), all generally available since 4 November 2025

Status dates are from Snowflake release notes (October 2026). Check Snowflake's regional availability page before planning an AI lab in the Mumbai or Pune regions. Trial accounts keep AI features off until you add a credit card.

Mini lab: If AI functions are enabled, run AI_SENTIMENT and AI_CLASSIFY on 20 product reviews. Our Snowflake Cortex AI tutorial has a full lab.

Outcome: You can discuss Snowflake's AI direction in interviews. Cortex was named in two of the job descriptions we read, both senior roles.

14. Module 13: dbt and orchestration

Short answer: dbt is the most common tool next to Snowflake in job descriptions, so this module teaches dbt models and tests and how pipelines are scheduled.

Topics:

  • dbt (data build tool): SQL models, sources, tests, documentation and snapshots for SCD Type 2 history
  • Staging, intermediate and mart layers
  • dbt Projects on Snowflake, which runs dbt inside Snowflake with commands such as EXECUTE DBT PROJECT (Snowflake documentation, October 2026)
  • Orchestration: Snowflake tasks for in-platform scheduling; Apache Airflow is a common external scheduler
  • Git and CI/CD basics for data code

Mini lab: Build staging, dimension and fact models on your orders data, add not-null and unique tests, and run them.

Outcome: You match the most common job ask after SQL. dbt was named in 9 of the 14 job descriptions we read, and a Naukri search for "dbt snowflake" showed 1,729 results on 25 October 2026 (keyword matches, not open jobs).

15. Module 14: Certification prep and capstone

Short answer: The last two weeks tie everything together: one end-to-end project for your portfolio and focused practice for the SnowPro Core exam.

Topics:

  • The SnowPro Core exam format and its five domains (section 17)
  • Weak-area revision using the domain weights
  • Practice questions and timed mock tests
  • A capstone project with a README, diagrams and SQL on GitHub

Mini lab: Take one timed mock test, list every wrong answer by domain, and revise the two weakest domains.

Outcome: You have a project to show and a clear view of your exam readiness. For the full exam guide, read our SnowPro Core certification guide.

16. Capstone project ideas

Short answer: Pick one capstone that uses at least six modules, because a single complete project impresses interviewers more than many half-finished ones.

Capstone Modules used What you show Retail sales pipeline (ShopKart) 4, 5, 8, 9, 13 Load CSV and JSON, automate with streams and tasks or dynamic tables, model with dbt, add a cost guard Payments CDC and audit 4, 6, 7, 8 Track changes with streams, recover with Time Travel, restrict card columns with masking Partner data share 7, 11 Share a curated sales view with a reader account and revoke it Customer review insights 5, 10, 12 Load reviews, clean with Snowpark, tag with Cortex AI Functions

For more ideas with datasets, see our list of Snowflake projects.

17. How the syllabus maps to SnowPro Core (COF-C03)

Short answer: The SnowPro Core exam has five domains, and every module above feeds at least one of them.

SnowPro Core (COF-C03) has 100 questions in 115 minutes, a pass mark of 750 on a 0 to 1000 scale and no prerequisites (Snowflake SnowPro Core page, October 2026). Snowflake suggests six or more months of experience. The weights are Snowflake's; the module mapping is our reading.

Exam domain Weight Syllabus modules 1.0 Snowflake AI Data Cloud Features and Architecture 31% 2, 3, 10, 12 2.0 Account Management and Data Governance 20% 6, 7, 9 3.0 Data Loading, Unloading and Connectivity 18% 4, 5 4.0 Performance Optimization, Querying and Transformation 21% 1, 5, 8, 9 5.0 Data Collaboration 10% 11

Architecture and features carry almost a third of the marks, so do not rush modules 2 and 3.

18. Beginner track vs advanced track

Short answer: Freshers and analysts should finish a beginner track first; working SQL, ETL and Informatica developers can move faster into the advanced modules.

Track Who it suits Modules Time Beginner B.Tech, BCA, B.Sc and MCA freshers, data analysts, testers 1 to 9 and 11 About 8 weeks Advanced SQL, ETL and Informatica developers, DBAs, working data engineers 8 to 14, with a fast review of 2 to 7 About 6 weeks

Role-wise focus: developers go deeper on modules 1, 8, 10 and 13; data engineers on 4, 8, 9 and 13; admins on 3, 7 and 9.

These times are our suggestions at one to two hours a day, not official figures. Our how to learn Snowflake roadmap has a study schedule.

19. How to spot an outdated Snowflake syllabus

Short answer: If a syllabus teaches a retired product or an old exam code, the rest may be out of date too.

Check course outlines for these changes (Snowflake documentation and learn.snowflake.com, October 2026):

  • Document AI: shut down on 16 March 2026; the replacement is the AI_EXTRACT function
  • SnowPro Core: the current exam is COF-C03, so COF-C02 material may not match
  • Snowflake Intelligence: now called Snowflake CoWork
  • SnowSQL only: SnowSQL is a legacy client; Snowflake CLI should be taught too
  • Snowflake Open Catalog: closed to new customers, who are pointed to Snowflake Horizon Catalog
  • Community MCP server: the Snowflake-Labs MCP repository is deprecated
  • Missing topics: no dynamic tables, Snowpark or dbt means the course stops short of how Snowflake teams work today

20. Snowflake course fees in India at a glance

Short answer: You can learn most of the syllabus free from Snowflake itself; you pay for guided teaching, structure, mentoring and the exam.

Course type What you pay What you get Snowflake on-demand courses and Hands-On Essentials badges Free courses; Snowflake says many of the badges are also free Self-paced lessons, graded labs, shareable badges Snowflake instructor-led training Courses are marked "PAID" or "FREE"; no price is shown to logged-out visitors Official live training on fundamentals, admin, data engineering and more Online learning platforms (Coursera, LinkedIn Learning, DataCamp) Varies by platform and plan; Coursera courses in Snowflake's Northstar programme are free to audit Recorded courses, some with certificates of completion Classroom or live online institute courses in Indian cities Paid; fees vary widely by city, mode, duration and inclusions A trainer, a fixed schedule, doubt sessions, projects, interview prep SnowPro Core exam $175 per attempt, or $140 in India A Snowflake-issued certification valid for 2 years

Snowflake University marks its on-demand courses as free, and its course catalogue labels instructor-led courses only "PAID" or "FREE" (Snowflake, October 2026). The badge wording is from the Hands-On Essentials track page (Snowflake, October 2026), and the Northstar details from Snowflake's Northstar page (October 2026). We have not verified Coursera, Udemy or DataCamp prices, so check each platform.

Among paid courses, recorded plans usually cost the least, live online sits in the middle, and classroom batches cost the most because they pay for a trainer and a venue. In rupees, the India Core exam fee of $140 is about ₹12,600 at an example rate of ₹90 per US dollar (our arithmetic, not an official price).

21. Certification exam fees (separate from course fees)

Short answer: SnowPro exams cost $175 (Core), $225 (Specialty) and $375 (Advanced) per attempt, with a 20% discount for exams taken in India.

According to Snowflake's certification FAQ (October 2026):

  • SnowPro Core: $175, or $140 in India
  • Specialty exams: $225, or $180 in India; SnowPro Core is not required
  • Advanced exams: $375, or $300 in India; an active SnowPro Core certification is required
  • Practice exam: $50, or $47 in India
  • Retakes: full fee every attempt, at most 4 attempts in 12 months, with a 7-day wait between attempts

Certifications last 2 years and renew through Continuing Education. There is no free SnowPro exam, but completing Snowflake's Northstar SnowPro Core track earns a $50 voucher (Snowflake, October 2026). For budgets and renewal rules, read our Snowflake certification cost guide.

22. Hidden costs to plan for

Short answer: Plan for retakes, practice tests, Snowflake usage after your trial, and your time.

  • Retakes and practice exams: full fee per retake, plus optional practice exams
  • After the trial: a trial lasts 30 days, ends earlier if the free balance runs out, and is then suspended until you add a card (Snowflake trial account docs, October 2026). Snowflake's trial page offered US$400 of free usage in October 2026. Openflow is excluded from trials
  • Cloud buckets: S3, Azure or Google Cloud storage for external stage labs may cost a little
  • Commute: classroom batches mean travel time

Credit prices vary by cloud, region and edition, so suspend warehouses and set a resource monitor from day one.

23. EMI and payment options

Short answer: Many institutes offer instalments or EMI, but read the terms before you sign.

Ask before you choose EMI:

  1. Is it truly no-cost, or are there interest and processing fees?
  2. Is a third-party lender involved?
  3. What is the refund policy if you drop out early?
  4. Are recordings, projects and mock interviews included?
  5. Can you attend a free demo before paying, without "today only" pressure?

24. How to judge the value of a Snowflake course

Short answer: Value comes from the syllabus, the labs and the trainer, not from the lowest fee or the longest module list.

Use this checklist before you pay:

  • Depth: does it cover the 14 areas above, including automation, cost and security?
  • 2026 topics: Snowflake CLI, dynamic tables, Snowpark, Cortex AI Functions, or a clear note on what it leaves out
  • Labs and projects: weekly work in your own account and one end-to-end project
  • Trainer: real Snowflake experience, and a demo class you can attend
  • Exam honesty: a clear statement that SnowPro fees are separate
  • Placement claims: resume help, mock interviews and interview scheduling are useful, but no course can promise a job. None of the 14 job descriptions we read accepted zero years of experience (the lowest ask was 2 to 5 years), so freshers usually enter through data engineer, SQL or ETL developer, data analyst or BI roles
  • Job fit: SnowPro was required in only one of the 14 JDs and preferred in one, while SQL, dbt and Python came up again and again

On mode: classroom suits learners who want fixed hours, face-to-face doubt clearing and peers, but adds commute time. Live online suits working professionals and people outside Hyderabad or Bengaluru. Recorded courses cost the least but need self-discipline. Pick the mode you will actually attend every week.

A course is worth its fee when it saves you months of trial and error. If you are disciplined, Snowflake's free material can take you far; if you need deadlines, feedback and mock interviews, a guided course earns its fee.

25. How Brolly Academy helps

Short answer: Brolly Academy's 45-day Snowflake course covers most of the core syllabus above in 15 modules, with 6 projects, mock interviews and a choice of video, live online and classroom plans.

Our Snowflake Training in Hyderabad course is beginner-friendly and teaches SQL from scratch. It is led by Mr. Bala Krishna, who has 13+ years in data warehousing, SQL and Snowflake. You get a Brolly Academy course completion certificate; SnowPro exams are issued and examined by Snowflake, and their fees are separate.

Fees, as listed on the course page (October 2026):

Plan Fee Format Video Recording ₹8,999 Recorded classes with lifetime access Online Course ₹17,999 Live interactive classes over 45 days Classroom Training ₹22,999 Classroom batches in Hyderabad over 45 days

Easy EMI is available, and you can attend a free demo class before you enrol.

How the Brolly course maps to this syllabus:

Syllabus module Brolly course module SQL and warehousing basics Data warehousing concepts; SQL taught from scratch Architecture and warehouses Architecture; cloud platforms; pricing, editions and credit usage Loading and JSON Data loading and unloading; Snowpipe; semi-structured data Time Travel and cloning Cloning; Time Travel and Fail-safe Security RBAC basics; data masking Streams and tasks Scheduling with tasks and streams Performance and cost Caching, clustering and performance; resource monitoring Data sharing Secure data sharing Python Python connector and Python integration Certification prep SnowPro exam guidance

The gaps: Snowpark, dynamic tables, Cortex AI and Airflow are not Brolly course modules, and dbt appears only in its tools list, so use the free resources above for those. The 6 projects are sales dashboards, an ETL pipeline, real-time data sharing, a Customer 360 view, a financial data warehouse and e-commerce analytics.

Want a trainer to walk you through this Snowflake syllabus?

Join Brolly Academy's 45-day Snowflake course to learn SQL, loading, Snowpipe, Time Travel, security, data sharing and performance tuning through 6 projects, with mock interviews and resume support. Choose video, live online or classroom in Hyderabad, and book a free demo class first to see if it suits you.

Frequently asked questions

What is the Snowflake syllabus?

A Snowflake syllabus is the list of topics you learn to work on the Snowflake platform. A complete 2026 syllabus covers SQL and warehousing basics, architecture, virtual warehouses, loading and stages, semi-structured data, Time Travel and cloning, security and RBAC, streams, tasks and dynamic tables, performance and cost, Snowpark, data sharing, Cortex AI, dbt and orchestration, and certification prep, with a hands-on lab in each module.

What topics are covered in Snowflake training?

Snowflake training usually covers architecture, virtual warehouses, data loading with stages and COPY INTO, Snowpipe, JSON with VARIANT, Time Travel, cloning, roles and grants, streams and tasks, data sharing, caching and cost control. Newer courses add Snowpark, dynamic tables, dbt and Cortex AI Functions. Check each course outline for these modern topics before you enrol, because older outlines often stop at the basics.

How many modules are in a Snowflake course?

There is no fixed number. Our syllabus uses 14 modules, and Brolly Academy's course uses 15 modules over 45 days. The count matters less than coverage and labs. Make sure the course covers loading, automation, security, performance and cost, and that every module ends with something you build in a real Snowflake account rather than slides alone.

How long does it take to complete the Snowflake syllabus?

At one to two hours a day, plan about 12 weeks for the full syllabus. A beginner track of the core modules takes about 8 weeks, and working SQL or ETL developers can cover the advanced modules in about 6 weeks. These are planning suggestions, not official figures. Your pace depends on your SQL level and how much hands-on practice you do.

What are the prerequisites before starting the Snowflake syllabus?

You mainly need comfortable SQL: SELECT, joins, GROUP BY and basic window functions. Knowing data warehousing ideas such as fact and dimension tables helps. Python is useful later for Snowpark but is not needed at the start. Freshers with a B.Tech, BCA, B.Sc or MCA can begin with the SQL module and build up from there.

Is there a Snowflake syllabus PDF?

Many people search for a PDF, and outlines on document-sharing sites rank for it, but they are often out of date. The syllabus-at-a-glance table on this page lists every module, its main topics and a suggested week. You can print or save that table as your own PDF checklist and tick off each module as you finish its lab.

What is the SnowPro Core certification syllabus?

The SnowPro Core exam, COF-C03, has five domains: AI Data Cloud features and architecture (31%), account management and data governance (20%), data loading, unloading and connectivity (18%), performance optimization, querying and transformation (21%), and data collaboration (10%). It has 100 questions in 115 minutes and a pass mark of 750 out of 1000.

Does the Snowflake syllabus include Python and Snowpark?

A modern syllabus should. Snowpark lets you write Python, Java or Scala that runs inside Snowflake using lazy DataFrames. Python appeared in 9 of the 14 Snowflake job descriptions we read in October 2026, and Snowpark was named in two. Note that the SnowPro Specialty Snowpark exam retires on 1 November 2026, so learn Snowpark for work.

Is dbt part of the Snowflake syllabus?

dbt is not part of Snowflake itself, but it belongs in a job-focused syllabus. It was named in 9 of the 14 Snowflake job descriptions we read in October 2026, and a Naukri search for "dbt snowflake" showed 1,729 keyword-match results on 25 October 2026. Learn dbt models, tests and snapshots after you are comfortable with Snowflake SQL.

What is the syllabus for a Snowflake developer?

A Snowflake developer should finish the core modules and then go deeper on SQL, streams and tasks, dynamic tables, Snowpark and dbt. Developers spend most of their time writing transformations, stored procedures and automated pipelines, so labs on CTEs, window functions, MERGE logic and Python procedures matter most for this role.

What is the syllabus for a Snowflake data engineer?

A Snowflake data engineer should go deeper on loading and stages, Snowpipe, streams, tasks and dynamic tables, performance and cost, and dbt. Data engineers own pipelines from source files to clean tables, so practise external stages with storage integrations, incremental loads, Query Profile tuning and resource monitors, and add Python for Snowpark work.

What does a Snowflake admin syllabus include?

A Snowflake admin syllabus focuses on virtual warehouses, security and monitoring. That means system roles and RBAC, MFA and key-pair authentication, network and masking policies, warehouse sizing, multi-cluster settings, resource monitors and ACCOUNT_USAGE views. Admins also need Time Travel and Fail-safe basics for recovery questions.

What projects are included in a Snowflake course?

Good courses include at least one end-to-end project. Strong capstone ideas are a retail sales pipeline that loads CSV and JSON and models data with dbt, a payments change-tracking project with Time Travel and masking, a partner data share with a reader account, and a review insights project using Snowpark and Cortex AI Functions.

Should a 2026 Snowflake syllabus include Cortex AI?

Yes, at least as an introduction. Cortex AI Functions let you call language models from SQL, and Cortex Agents and Snowflake CoWork, formerly Snowflake Intelligence, became generally available on 4 November 2025. Some functions are in preview and availability is limited to select regions, and trial accounts keep AI features off until you add a card.

What is the Snowflake course fee in India?

It ranges from free to paid. Snowflake's own on-demand courses are free, and many Hands-On Essentials badges are free. Online platform prices vary by plan, and classroom or live online institute fees vary by city, mode, duration and inclusions. The SnowPro Core exam is a separate cost of $175 per attempt, or $140 in India.

What is the Snowflake course fee in Hyderabad?

Fees in Hyderabad depend on the mode. Recorded courses usually cost the least, live online sits in the middle, and classroom batches cost the most because of the trainer's time and the venue. Brolly Academy's 45-day course offers all three modes, with fees and EMI listed in its section above. Always compare what each fee includes, not just the price.

Is the Snowflake course free?

Some are. Snowflake's on-demand courses on learn.snowflake.com are free, and Snowflake says many of its Hands-On Essentials badges are free too. Coursera courses in Snowflake's Northstar programme are free to audit. What is never free is the SnowPro exam itself: every attempt costs the full fee, and there is no free SnowPro exam.

Can I learn Snowflake for free?

Yes, you can learn most of the syllabus for free. Use Snowflake's free on-demand courses, the Hands-On Essentials labs and a 30-day trial account. Plan your labs well, because the trial ends after 30 days or earlier if the free balance runs out. Free learning needs discipline, so follow a weekly plan and build one capstone project.

Does the course fee include the certification exam fee?

Usually not. SnowPro exams are run and charged by Snowflake through its own registration, so treat the exam as a separate bill. SnowPro Core costs $175 per attempt, or $140 in India, and every retake costs the full fee again. Ask any institute directly whether a voucher is included before you pay.

What is the difference between course fee and certification cost?

A course fee pays for teaching: a trainer, classes, labs, projects and interview support. The certification cost pays Snowflake for the SnowPro exam attempt, which leads to a certification valid for 2 years. You can take the exam without any course, and you can take a course without the exam. Most learners budget for both.

Snowflake course online vs classroom: which is better?

Neither is better for everyone. Classroom batches suit learners who want fixed hours, face-to-face doubt clearing and peers, but they add commute time. Live online classes suit working professionals and people outside Hyderabad or Bengaluru. Recorded courses are cheapest but need strong self-discipline. Pick the mode you will actually attend every week.

Is a Snowflake course worth the money?

It is worth it if it saves you months of trial and error and ends with a project you can explain. Check the syllabus depth, weekly labs, trainer experience and honest placement claims. If you are disciplined, Snowflake's free material can take you far. If you need deadlines, feedback and mock interviews, a guided course earns its fee.

Do Snowflake courses offer placement assistance?

Many do, but the term usually means resume help, mock interviews and interview scheduling, not a guaranteed job. Ask whether the institute shows placement numbers or employers with proof. Remember that in our October 2026 sample of 14 Snowflake job descriptions, none accepted zero years of experience, so plan for entry through data engineer or analyst roles.

Is EMI available for Snowflake courses?

Many institutes offer instalments or EMI. Before you sign, check whether it is truly no-cost or carries interest and processing fees, whether a third-party lender is involved, what the refund policy is if you drop out early, and whether projects, recordings and mock interviews are included. Attend a free demo class before committing.

How do I spot an outdated Snowflake syllabus?

Look for retired products and old exam codes. Document AI was shut down on 16 March 2026, Snowflake Intelligence is now Snowflake CoWork, and the current SnowPro Core exam is COF-C03. A syllabus that teaches only SnowSQL and has no dynamic tables, Snowpark or dbt also stops short of how Snowflake teams work in 2026.

Learn with Brolly Academy

Review the syllabus, practical projects and batch timings, and book a free demo before you enrol.

Related Articles

Snowflake Tutorial

Hands-on guide for beginners.

Read Article

Snowflake Projects

20 beginner projects with SQL.

Read Article

Continue Your Learning

Snowflake Training in Hyderabad

45-day course covering Snowflake architecture, warehouses, data loading, security, performance and real-time projects, in classroom, live online and recorded plans.

View Course

dbt Course

Learn dbt, the transformation tool most Snowflake job descriptions ask for, to build tested, documented data models.

View Course

Databricks Course

Add the lakehouse side of modern data engineering with Databricks, Spark and Delta Lake, often used alongside Snowflake.

View Course