In this Snowflake course you learn how the platform is built and how to load, query and secure data. It is aimed at data engineers and analysts who know basic SQL. You work with virtual warehouses, stages and COPY INTO, query structured and semi-structured data, set up roles and keep credit usage in view with auto-suspend and resource monitors.
What you’ll take away.
- Explain Snowflake's three layers: database storage, compute in virtual warehouses and cloud services
- Stage files and load them into tables with COPY INTO
- Query structured and semi-structured data with SQL, such as JSON in a VARIANT column
- Control access through roles and privileges and set up a read-only role
- Size warehouses sensibly, use auto-suspend and cap credit usage with resource monitors
Your training in detail
- Who is it for?
- Data engineers, analysts and BI developers who load and query data in Snowflake or run the platform for their team.
- Prerequisites
- Basic SQL: SELECT, JOIN and GROUP BY. Experience with a relational database helps. No prior Snowflake knowledge is needed.
- Format & planning
- Indicative range: 2 to 4 learning days, depending on prior experience, desired depth and practical scope. Duration is set only after discussing requirements.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Architecture and interface: separate layers for storage and compute, virtual warehouses as independent compute clusters, the cloud services layer for sign-in, metadata and query optimisation, and the Snowsight web interface.
Objects and loading: databases and schemas, internal and external stages, file formats such as CSV, JSON and Parquet, bulk loading with COPY INTO and an overview of Snowpipe.
SQL on structured and semi-structured data: the VARIANT, OBJECT and ARRAY data types, reaching nested JSON values through path notation, casting and FLATTEN for nested lists.
Access and sharing: roles, privileges and the role hierarchy, system-defined roles such as SYSADMIN and SECURITYADMIN, and an overview of Secure Data Sharing, where no data is copied between accounts.
Operations and cost: warehouse sizes, auto-suspend and auto-resume, credits and resource monitors, Time Travel for earlier states of the data, and cloning tables, schemas and databases without copying the data (zero-copy cloning).
Suggested exercise: You load one CSV and one JSON file into tables through a stage, write an evaluation query across both, create a read-only role and check how many credits your warehouse used along the way.
Exams, licences & credentials
This is not an exam course and not official Snowflake training. Attending alone does not award a vendor certification. Check exam requirements directly with Snowflake.
Vendor references & review date
Sources checked on 2026-11-18. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
- Snowflake Docs: Key concepts and architecture ↗
- Snowflake Docs: Overview of data loading ↗
- Snowflake Docs: Querying semi-structured data ↗
- Snowflake Docs: Overview of access control ↗
- Snowflake Docs: Secure Data Sharing ↗
- Snowflake Docs: Overview of warehouses ↗
- Snowflake Docs: Resource monitors ↗
- Snowflake Docs: Time Travel ↗
- Snowflake Docs: Cloning objects ↗
Your learning content
These objectives describe the training topic. The specific syllabus, duration, dates, trainer and price are agreed before booking.
As training for your team
You can request "Data platforms and analytics with Snowflake" as training for your team only, live online. Content, examples and scope are agreed around your tasks. Date and total price are stated in the offer.
Frequently asked questions
Do I need my own Snowflake account for the training?
We clarify that before the training. For the exercises you need access that lets you create warehouses, databases and roles. Whether you use your company's account or a separate practice account is agreed when you enquire.
Does the course prepare for a Snowflake certification?
No, it is not an exam course. The focus is practical work with architecture, loading, querying, roles and cost. If you are planning an exam, compare the agenda with Snowflake's current exam guide.
What should I know beforehand?
Basic SQL is enough: you should be able to query, join and group tables. Experience with cloud storage such as Amazon S3, Google Cloud Storage or Microsoft Azure helps once external stages come up, but it is not required.
Does Data platforms and analytics with Snowflake include a certificate?
This is not an exam course and not official Snowflake training. Attending alone does not award a vendor certification. Check exam requirements directly with Snowflake.
