Learners learn how to ingest data into Snowflake at scale using various, powerful techniques. They specifically load data into Snowflake using the Snowflake Marketplace, the Snowflake web interface (Snowsight), the Snowflake CLI, and the powerful COPY INTO SQL command. Learners also understand how to ingest data from external systems using Snowflake native connectors, and how to optimize data ingestion by fully utilizing a virtual warehouse.

Learners perform data transformations using SQL or Snowpark for Python. Learners also understand that they can use Snowpark to perform data transformations with Java and Scala. They also extend their knowledge of data transformations by learning about, creating, and using user-defined functions (UDFs), stored procedures, streams, and Snowflake Dynamic Tables. They also learn how to perform data transformations using these tools outside of Snowflake, specifically in Visual Studio Code using Snowflake's official extension.

Learners understand what a data product is, and what it means to deliver a data product in the context of data engineering. Learners walk through the flow of delivering a dataset using Snowflake Marketplace, build and share a Streamlit in Snowflake application to deliver insights, and deploy a Snowflake Native Application using the Snowflake CLI.

Learners understand what orchestration means, and how to add automation to data pipelines using tasks. They specifically learn about user-managed and serverless tasks, and create tasks to automate calls to stored procedures. They also create and link tasks together to form a task graph, or DAG, and execute individual tasks and entire DAGs.