Personal training advice

Live online training for international teams.For businesses
EnquireFind my course
Data Science

Data platforms and analytics with Snowflake

Snowflake course: understand the architecture, load data through stages, query structured and semi-structured data, set up roles and keep costs in check.

Price on request · Dates by arrangement

Enquire about trainingAsk on WhatsApp

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.

IntermediateDE / ENBusiness training · Live online

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
Snowflake

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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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).

PRACTICE & TRANSFER

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.

Your learning content

These objectives describe the training topic. The specific syllabus, duration, dates, trainer and price are agreed before booking.

Individual offer: Availability and delivery are confirmed on enquiry.

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.

How team training works

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.

KEEP LEARNING

Related topics in this field

View all topics
Data Science

Data analytics

Data analytics training: frame analytical questions, check data quality, analyse data with Python and pandas and present findings clearly to decision makers.

Prices on requestDates by arrangementView course details ↗
Data Science

Data engineering

Data engineering training: design data pipelines with Airflow, Spark and dbt, model data cleanly and run and test pipelines so they stay reliable.

Prices on requestDates by arrangementView course details ↗

Also relevant

Guides

NextNowa Guide

Your training guide

What would you like to learn next?

Ask about courses, learning paths or advice. I will help you find your next step.

Automated guidance using reviewed information. No booking or funding confirmation. Please avoid sensitive data.