Skip to content
CoursesToJob

Snowflake · dbt · Cortex AI · SnowPro Core prep

Snowflake Data Engineering: Zero to Job-Ready

Live online classes with a Lead Data Engineer with 16+ years of experience. Build real pipelines with Snowflake, dbt and Cortex AI, prepare for SnowPro Core, and walk into interviews with projects you can explain.

  • 8 weeks
  • ~60 hours
  • Live online + class recordings
  • Taught in English

Next batch starts

Taught by Balakrishna Koraganti: 16+ years in data engineering · SnowPro Core Certified · SnowPro Specialty: Gen AI

Save ₹5,001 (25% off)

₹14,999 Regular price ₹20,000

Inclusive of all taxes · EMI available

Modules
18
Topics
97+
Live hours
~60
Projects
4

Detailed curriculum

What you'll learn, module by module

Open any module to see its topics. The syllabus is reviewed each batch to track new Snowflake features.

Talk to the instructor
  1. 01 Data warehousing & cloud fundamentals The foundations every interviewer expects you to know.
    • OLTP vs OLAP, data warehouse vs data lake vs lakehouse
    • Dimensional modelling: facts, dimensions, star and snowflake schemas
    • SCD types 1, 2 and 3 explained with examples
    • Cloud basics: AWS, Azure, GCP regions and object storage
    • Create your free Snowflake trial account and tour Snowsight
  2. 02 Snowflake architecture How Snowflake separates storage, compute and services.
    • Three-layer architecture: database storage, compute, cloud services
    • Micro-partitions, columnar storage and metadata
    • Snowflake editions and what each one unlocks
    • Snowsight, Workspaces, worksheets, SnowSQL and the Snowflake CLI
    • Accounts, organisations, regions and connection options
  3. 03 Virtual warehouses Compute sizing, scaling and credit usage.
    • Warehouse sizes, credits and per-second billing
    • Auto-suspend and auto-resume
    • Scale up vs scale out; multi-cluster warehouses and scaling policies
    • Gen2 / Snowpark-optimised warehouses: when to use them
    • Query acceleration service overview
  4. 04 Databases, schemas, tables & stages Every Snowflake object you will create on the job.
    • Permanent, transient and temporary tables
    • Views, secure views and materialized views
    • Internal stages (user, table, named) and external stages on S3
    • File formats and storage integrations
    • Sequences, identity columns and constraints in Snowflake
  5. 05 Data loading & unloading Batch and continuous ingestion patterns.
    • COPY INTO: options, validation mode, ON_ERROR and load history
    • Snowpipe with S3 event notifications (auto-ingest)
    • Snowpipe Streaming: concepts and use cases
    • Unloading data to stages with COPY INTO <location>
    • Loading best practices: file sizing, compression, error handling
  6. 06 Semi-structured data JSON, Parquet and Avro the Snowflake way.
    • VARIANT, OBJECT and ARRAY data types
    • Dot and bracket notation, casting, FLATTEN and LATERAL
    • Loading Parquet with INFER_SCHEMA and schema evolution
    • Building relational views on top of JSON
    • Performance tips for semi-structured queries
  7. 07 Time Travel, Fail-safe & zero-copy cloning Data protection and instant environments.
    • Time Travel: AT / BEFORE, UNDROP and retention periods
    • Fail-safe and how it differs from Time Travel
    • Zero-copy cloning of tables, schemas and databases
    • Using clones for dev/test environments
    • Storage cost implications
  8. 08 Streams, Tasks & Dynamic Tables Build automated, incremental pipelines inside Snowflake.
    • Streams: standard, append-only and insert-only; offsets and staleness
    • Tasks, task graphs (DAGs), schedules and serverless tasks
    • MERGE patterns for CDC and SCD Type 2
    • Dynamic tables: target lag, refresh modes and when to use them
    • Monitoring pipelines with TASK_HISTORY and alerts
  9. 09 Data sharing & the Marketplace Share live data without copying it.
    • Secure Data Sharing: providers, consumers and shares
    • Reader accounts
    • Listings and the Snowflake Marketplace
    • Data clean rooms: concepts
    • Cross-region and cross-cloud sharing with replication
  10. 10 Security, RBAC & governance What every enterprise project checks first.
    • System roles, custom roles and role hierarchy design
    • Privileges, future grants and managed access schemas
    • Dynamic data masking and row access policies
    • Object tagging and tag-based masking
    • Network policies, MFA, key-pair auth and SSO overview
  11. 11 Performance tuning & caching Make slow queries fast and explain why.
    • Result cache, warehouse (local disk) cache and metadata cache
    • Reading the Query Profile: spilling, pruning, exploding joins
    • Clustering keys and automatic clustering
    • Search optimization service
    • Query tuning checklist used on real projects
  12. 12 Cost optimization & monitoring Keep Snowflake bills predictable.
    • How compute, storage and serverless costs are billed
    • Resource monitors and budgets
    • ACCOUNT_USAGE views for cost and usage reporting
    • Right-sizing warehouses and auto-suspend tuning
    • Cost optimization case study
  13. 13 Snowpark for Python Python on Snowflake compute.
    • Snowpark sessions and DataFrames
    • Transformations, joins and writing results back
    • Python UDFs, UDTFs and stored procedures
    • Using third-party packages
    • Snowflake Notebooks
  14. 14 dbt with Snowflake (in depth) The transformation tool used on most modern Snowflake projects.
    • dbt project structure, profiles and connecting to Snowflake
    • Sources, ref(), staging / intermediate / mart layering
    • Materializations: view, table, ephemeral, incremental
    • Incremental strategies: merge, append, delete+insert
    • Snapshots for SCD Type 2 history
    • Generic and singular tests, source freshness
    • Jinja, macros and packages (dbt_utils)
    • Seeds, hooks, docs and lineage
    • Environments, Git workflow and CI checks
    • dbt projects running natively on Snowflake: overview
  15. 15 Snowflake + AI The AI features companies are adopting right now.
    • Cortex AI Functions in SQL: AI_COMPLETE, AI_CLASSIFY, AI_FILTER, AI_SENTIMENT, AI_EXTRACT, AI_SUMMARIZE_AGG
    • Model choice, cost and access control for Cortex AI
    • Cortex Search for retrieval over your documents
    • Semantic Views: defining business metrics and dimensions
    • Cortex Analyst: natural-language questions over semantic views
    • Cortex Agents overview
    • Cortex Code (CoCo): AI coding agent in Snowsight and CLI for SQL, dbt and pipeline work
  16. 16 SnowPro Core certification prep Targeted preparation for the SnowPro Core (COF-C03) exam.
    • Exam format, domains and how to register
    • Domain-by-domain revision mapped to this course
    • Practice questions with explanations
    • Common traps and time management
    • Final revision checklist
  17. 17 Capstone projects Build portfolio work you can walk through in an interview.
    • End-to-end pipeline: S3 → Snowpipe → dynamic tables → dbt marts
    • Security layer: RBAC, masking and row access policies
    • AI layer: Cortex summaries and a semantic view
    • Documentation and a GitHub repo for your portfolio
    • Project presentation and review
  18. 18 Interview & resume preparation Turn the skills into offers.
    • Resume and LinkedIn profile review for data engineering roles
    • Top Snowflake and dbt interview questions with model answers
    • SQL and scenario-based problem solving
    • Explaining your projects with impact
    • Mock interviews with feedback

Projects

Portfolio projects you build

Project 1

Retail sales lakehouse

Ingest CSV and JSON files from S3 with Snowpipe auto-ingest, model them in staging and mart layers, and build a sales dashboard-ready schema.

  • S3
  • Snowpipe
  • VARIANT
  • Star schema

Project 2

CDC pipeline with Streams & Tasks

Capture changes from a source table, merge them into a target with SCD Type 2 history, and schedule it all with a task graph.

  • Streams
  • Tasks
  • MERGE
  • SCD Type 2

Project 3

dbt analytics project

A production-style dbt project: sources, incremental models, snapshots, tests, macros, docs and a CI check on GitHub.

  • dbt
  • Incremental
  • Snapshots
  • Tests

Project 4

Capstone: AI-ready data platform

End-to-end: S3 → Snowpipe → dynamic tables → dbt marts → RBAC and masking → Cortex AI summaries and a semantic view for natural-language questions.

  • End-to-end
  • RBAC
  • Cortex AI
  • Semantic Views
Balakrishna Koraganti, Lead Data Engineer | Snowflake & dbt Specialist
SnowPro Core Certified SnowPro Specialty: Gen AI

Your instructor

Balakrishna Koraganti

Lead Data Engineer | Snowflake & dbt Specialist · Hyderabad

Balakrishna has 16+ years of experience building enterprise data platforms, most recently designing Snowflake and dbt pipelines for large financial and healthcare companies. He's SnowPro Core and Gen AI certified and teaches exactly what's used on real projects and asked in interviews.

Experience
16+ years
Certifications
SnowPro ×2
Education
B.Tech, JNTU

Career

  1. Lead Data Engineer · Current role

    Snowflake & dbt platforms for financial and healthcare companies

  2. Senior Data Engineer · A global bank

    12-year tenure building enterprise data platforms

  3. Started career · Virtusa

    Where it all started

Expertise

  • Snowflake Architecture
  • Performance Tuning & Cost Optimization
  • dbt (incremental, SCD Type 2, macros, tests)
  • Snowpipe, Streams & Tasks
  • RBAC & Data Masking
  • Python & AWS
  • Snowflake Cortex AI
View LinkedIn profile (opens in a new tab)

Batches & pricing

Choose your batch

Weekday batch

Mon – Fri · 7:00 – 8:30 AM IST

Best for working professionals: done before the workday starts.

Starts

Weekend batch

Sat – Sun · 10:00 AM – 1:00 PM IST

Longer hands-on sessions for those busy on weekdays.

Starts

Live online classes, taught in English. All timings are in IST. Every class is recorded, so you can catch up if you miss one.
Save ₹5,001 (25% off)

₹14,999 Regular price ₹20,000

Inclusive of all taxes · EMI available

  • Live instructor-led classes
  • Recording of every class
  • Hands-on labs on your own Snowflake account
  • 4 portfolio projects + capstone
  • SnowPro Core exam preparation
  • Resume, LinkedIn & mock interview support
  • Doubt clearing on WhatsApp
  • Certificate of completion

FAQ

Frequently asked questions

Do I need prior experience to join?

Basic SQL (SELECT, JOIN, GROUP BY) is enough. We cover data warehousing fundamentals in the first module. If you have never written SQL, ask us for a free SQL primer before the batch starts.

Are the classes live or recorded?

All classes are live online with the instructor so you can ask questions. Every session is recorded, so you can revise or catch up if you miss a class.

What are the batch timings?

Weekday batch: Monday to Friday, 7:00 to 8:30 AM IST. Weekend batch: Saturday and Sunday, 10:00 AM to 1:00 PM IST. Classes are taught in English.

What is the course fee? Is EMI available?

The fee is ₹14,999, inclusive of all taxes (regular price ₹20,000). EMI options are available. Contact us on WhatsApp or the enrollment form and we will share the details.

Do I need to pay for Snowflake?

No. You will use a free Snowflake trial account for the labs, and we show you how to keep usage within the trial credits.

Will this prepare me for the SnowPro Core certification?

Yes. The curriculum covers the SnowPro Core exam domains and includes a dedicated prep module with practice questions. The exam fee is paid directly to Snowflake and is not included.

Do you provide job placement?

We provide resume and LinkedIn reviews, interview preparation, mock interviews and portfolio projects so you are job-ready. We do not promise or guarantee a job; your effort and practice make the difference.

Can I attend a demo class before enrolling?

Yes. Book a free demo session to meet the instructor, see how classes run and ask any questions.

What if I miss a class?

Every class is recorded and shared, and you can ask doubts on WhatsApp or in the next live session.

Will I get a certificate?

Yes, you receive a CoursesToJob certificate of completion after finishing the course and the capstone project.

Your next role starts with the next batch.

Batch starts 5 Jan 2027. ₹14,999 all-inclusive, emi available.

₹14,999 ₹20,000

Inclusive of all taxes · EMI available

Enroll now