Who should attend
Data analysts, data engineers, ETL developers, BI professionals and QA/data testers.
Prerequisites
SQL fundamentals and basic data warehouse concepts are recommended.
Learning outcomes
- Explain Snowflake architecture and core objects.
- Create databases, schemas, tables, stages and virtual warehouses.
- Load and unload structured and semi-structured data.
- Query and transform data using Snowflake SQL.
- Understand role-based access, compute cost and performance basics.
- Build a small data loading and analytics workflow.
Detailed curriculum
8 modules01Snowflake platform and architecture
- Cloud data platform overview and use cases
- Storage, compute and cloud services layers
- Virtual warehouses and separation of storage/compute
- Databases, schemas, tables and views
- Editions, regions and account concepts at a high level
02Account objects and SQL environment
- Snowsight worksheets and navigation
- Databases, schemas and object naming
- Creating tables, views and common data types
- Virtual warehouse creation, sizing, suspend and resume
- Context, role and warehouse selection
03Data loading and stages
- Internal and external stages
- File formats for CSV, JSON and Parquet
- PUT/COPY INTO workflow concepts and supported client paths
- Load history, rejected records and validation modes
- Unloading data and export patterns
04Semi-structured data
- VARIANT, OBJECT and ARRAY concepts
- Loading JSON data
- Dot/bracket path navigation and FLATTEN
- Casting and extracting typed values
- Handling nested and inconsistent structures
05SQL transformations and analytics
- Joins, aggregations, CTEs and window functions
- MERGE and incremental upsert patterns
- Streams and Tasks concepts for change processing/automation
- Views and materialized view concepts
- Data quality and reconciliation SQL
06Security and governance
- Role-based access control and role hierarchy
- Users, roles, grants and ownership
- Database/schema/table privileges
- Secure views and data sharing concepts
- Masking, row access policies and governance overview
07Performance and cost management
- Warehouse sizing and workload isolation
- Query Profile and execution insights
- Pruning, micro-partitions and clustering concepts
- Caching and query optimisation basics
- Credit consumption, resource monitors and cost controls
08End-to-end project and administration
- Create a small database and target schema
- Load sample CSV and JSON data
- Transform raw data into curated tables
- Automate a repeatable task using Tasks where available
- Prepare access, cost, validation and handover documentation
How you will practise
Learn through instructor-led sessions using realistic, live applications. Then apply each concept through guided assignments on a separate hands-on practice application, with feedback to help you build practical skills and confidence.
Practical exercises and labs
- Create database/schema/table objects and a virtual warehouse.
- Load CSV and JSON files from a stage into target tables.
- Flatten nested JSON and build analytical SQL queries.
- Review Query Profile and apply basic cost/performance controls.
Capstone project
Build a Snowflake mini-warehouse: stage and load sample data, transform raw to curated tables, create analytical views, configure roles/grants and document cost/performance considerations.
Tools and technologies
Snowflake trial or training account, Snowsight and sample files. Availability of features may depend on account edition and trial limits.
Assessment approach
- Module-wise knowledge checks or short practical tasks.
- Hands-on exercise review using an agreed checklist or rubric.
- Final project demonstration and explanation of design decisions, test evidence or outputs, as applicable.
- Completion criteria, attendance requirements and any certificate conditions must be separately approved and published by TrainingRite.
Schedule and fees
Upcoming batch schedules are shared by our TrainingRite team. Please submit an enquiry and our team will contact you by email or phone with the latest schedule. TrainingRite does not publish course fees or discounts on the website. Our counselling team will share the applicable course fee and other details with you by email or phone after you submit an enquiry.
Frequently asked questions
Who should join this course?
Data analysts, data engineers, ETL developers, BI professionals and QA/data testers.
Do I need prior experience?
SQL fundamentals and basic data warehouse concepts are recommended.
Is the training online?
TrainingRite programmes are delivered online.
Will I get hands-on practice?
Sessions are instructor-led and use realistic applications. You then apply each concept through guided assignments on a separate practice application.
How can I enquire about fees and the next batch?
Fees and batch schedules are not published on the website. Submit the enquiry form on this page and our counselling team will share them with you by email or phone.