PROJECT 01
Auto ingest pipeline
Files land in Azure storage and load into Snowflake automatically with Snowpipe, with errors captured and alerted.
StagesSnowpipeFile formats
01 / OVERVIEW
What this course is about
Snowflake is one of the most requested skills in data engineering job posts. I use it every day at work and I hold the Snowflake Advanced Data Engineer certification. In this course you learn how Snowflake works under the hood, load and transform data the way production teams do, automate pipelines with streams and tasks, and keep the bill under control.
You learn by doing: every week has hands-on exercises on Google Classroom, and every module ends with something you built yourself.
01
Understand Snowflake architecture
Storage, compute and services layers, micro-partitions and caching.
02
Load data like production teams
Stages, file formats, COPY INTO and Snowpipe from Azure storage.
03
Handle JSON and Parquet
VARIANT, FLATTEN and lateral joins for semi-structured data.
04
Automate with streams and tasks
Change data capture, task graphs and dynamic tables.
05
Secure and govern data
Role based access, masking and row access policies.
06
Control cost and performance
Warehouse sizing, query profile, clustering and resource monitors.
02 / CURRICULUM
Week by week
A clear plan from the first session to the last. The pace adapts to you: if you already know a topic we move faster, and if something needs more time we take it.
WEEK 1Snowflake architecture5 topics
- Storage, compute and cloud services
- Virtual warehouses and editions
- Snowsight tour
- Databases, schemas and objects
- Micro-partitions
WEEK 2Loading data5 topics
- Internal and external stages
- File formats
- COPY INTO and error handling
- Loading from Azure Blob and ADLS
- Snowpipe auto ingest
WEEK 3Semi-structured data5 topics
- VARIANT, OBJECT and ARRAY
- Querying JSON
- FLATTEN and LATERAL
- Parquet files
- Schema detection
WEEK 4Snowflake SQL in depth5 topics
- QUALIFY and window functions
- MERGE patterns
- Transient and temporary tables
- Secure and materialized views
- Incremental models
WEEK 5Time Travel and cloning5 topics
- Time Travel and UNDROP
- Fail-safe
- Zero-copy cloning for dev and test
- Secure data sharing
- Data retention settings
WEEK 6Streams, tasks and dynamic tables5 topics
- Change data capture with streams
- Scheduled tasks and task graphs
- SCD Type 2 with MERGE
- Dynamic tables
- Monitoring task history
WEEK 7Procedures and UDFs5 topics
- Snowflake Scripting
- Stored procedures
- SQL and Python UDFs
- Error handling and logging
- Metadata driven loads
WEEK 8Snowpark for Python5 topics
- Sessions and DataFrames
- Transformations in Snowpark
- Python stored procedures
- Packages and deployment
- When to use Snowpark vs SQL
WEEK 9Security and governance5 topics
- Role hierarchy and RBAC
- Masking policies
- Row access policies
- Network policies and MFA
- Object tagging
WEEK 10Performance and cost5 topics
- Query profile
- Warehouse sizing and auto-suspend
- Clustering keys and search optimization
- Result and warehouse cache
- Resource monitors and ACCOUNT_USAGE
WEEK 11Orchestration and migration5 topics
- Triggering Snowflake from Azure Data Factory
- dbt basics on Snowflake
- Databricks to Snowflake migration patterns
- Data consistency checks
- CI with Git
WEEK 12Capstone and certification prep4 topics
- End to end Snowflake pipeline
- SnowPro Core study plan
- Snowflake interview questions
- Mock interview with feedback
03 / PROJECTS
What you will build
Real projects you can put on GitHub and explain with confidence in interviews.
PROJECT 02
CDC into SCD Type 2
Track changes with streams and tasks and keep full history in a customer dimension.
StreamsTasksMERGE
PROJECT 03
Cost and performance dashboard
Use ACCOUNT_USAGE views to find expensive warehouses and queries, then fix them and measure the savings.
ACCOUNT_USAGEQuery profileResource monitors
04 / TOOLS
Tools and technologies
The same tools used by data teams in real companies.
SnowflakeSnowsightSnowSQLSnowpark for PythonAzure Blob and ADLS Gen2Azure Data FactorydbtGit
05 / IS IT FOR YOU
Who this course is for
Who it is for
- SQL developers who want a top cloud data warehouse skill
- Data engineers moving from on-prem or Databricks
- BI developers who work with Snowflake data
- Anyone targeting Snowflake jobs or SnowPro certification
What you need
- Good SQL basics (or take SQL Developer first)
- Basic Python helps for the Snowpark weeks
- A free Snowflake trial account, I help you set it up
Roles it leads to
- Snowflake Developer
- Data Engineer
- Analytics Engineer
- Cloud Data Warehouse Developer
06 / HOW YOU LEARN
What you get
Live and one-to-one
Every session is just you and me, never a batch. No recordings, so we can talk openly about your code.
3 sessions a week
Each session is 1 hour 15 minutes, on weekdays, weekends or both. We agree the schedule before starting.
Google Classroom
Assignments, projects, quizzes, interview questions and homework, all organised in one place.
Real projects
You build projects like the ones companies run, and get feedback on your code and design.
Interview preparation
Common questions, live coding practice and mock interviews with honest feedback.
Job placement support
CV, LinkedIn, applications and interviews. I stay with you until you are hired, as long as you do the work.
07 / PRICING
Simple pricing
You pay for your time with me, not per course. All prices are in US dollars.
Estimated total for Snowflake Developer at the typical pace (3 months)
About 600 USD
Full refund if it is not right for you after the first session. Go faster and it costs less.About 600 USD
08 / YOUR MENTOR
Hikmat Ullah
Senior Data Engineer at Algo · Lahore, Pakistan
I build data platforms with Snowflake, Azure Databricks, Azure Data Factory and Microsoft Fabric every day, and I have been mentoring since 2021. I teach what I use at work, and I stay with you until you land the job.
7+years in data
100+students trained
80+placed in jobs
1:1always, never a batch
09 / FAQ
Questions about Snowflake Developer
Do I need to pay for Snowflake?+
No. Snowflake offers a free trial with credits, which is enough for the course if you follow the cost tips we cover. I help you set it up in the first session.
Will this help with SnowPro Core?+
Yes. The course covers the main SnowPro Core areas and we finish with a study plan and practice questions.
Is Snowflake better than Databricks?+
They solve different problems and many companies use both. I work with both daily and we discuss when each one fits, including migrations between them.
How much does it cost?+
200 USD per month whichever course you choose. You can also pay 100 USD every 15 days or 50 USD per week. All prices are in US dollars wherever you live.
What is the refund policy?+
If the training is not right for you after the first session, you get a full refund. After that, payments already used for completed sessions are not refunded, but unused prepaid time can be refunded.
Is there a job guarantee?+
Yes. As long as you attend your sessions and complete the assignments and projects, I keep helping you with CV, LinkedIn, mock interviews and job applications until you are hired.
Can I join from another country or time zone?+
Yes. Students join from many countries. We pick session times that work for your time zone before we start.
10 / KEEP GOING
Related courses
2 months
SQL Developer
From your first SELECT to stored procedures, data models and fast queries.
View course → 3 monthsAzure Databricks Engineer
PySpark, Delta Lake, medallion architecture and Unity Catalog on Azure.
View course → 6 monthsAzure Data Engineer
The complete path: SQL, Python, ADF, ADLS Gen2, Databricks, Synapse and Event Hubs.
View course →START WHEN YOU ARE READY
Start the Snowflake Developer course
Tell me your goals and your time zone. We plan your schedule together, and your first session can start this week.