
Explore how Snowflake handles AI analyses across structured and unstructured data, enabling data agents and machine learning workflows in a secure, governed AI environment on enterprise data.
Set up a snowflake account and start a 30-day free trial with $400 in credits, no credit card required, access the main interface, cortex command line, and region options.
Navigate Snowflake databases, schemas, and tables, and learn data ingestion, drag-and-drop uploads, and sample datasets for clear sales insights, and manage roles and access controls.
Explore how Snowflake's virtual warehouses use compute clusters as partitions to scale on demand. Scale up and down instantly, suspend when idle, and enable Cortex AI integration.
Explore Snowflake Cortex’s credit-based, serverless AI workflow that charges credits for each request, enabling automatic tracking of summarisation, sentiment analysis, and text embedding via LLAMA3 models.
Explore Snowflake, a cloud data warehouse that stores data in tables and uses create table, insert, and select. Learn data types, copy into loading, and clustering to optimize queries.
Explain how Snowflake handles semi-structured data using the Variant type, enables JSON storage, and lets you query with dot notation, Flatten, and GetPath to extract nested fields.
Snowflake's micropartitions enable automatic partitioning, rich metadata, and metadata pruning, with clustering, reclustering, and partition elimination driving scalable, cost-efficient analytics.
Master how Snowflake handles data analysis with aggregation and window functions, using sum, avg, count, min, max, and the over clause to compute running totals without collapsing rows.
Explore Snowflake's role-based access control by assigning permissions to roles granted to users. Practice least privilege, role switching, hierarchical role inheritance, and using predefined system roles like account admin.
Enable secure data sharing in Snowflake, providing live data access across cross-region and cross-cloud sharing, with data remaining in the provider's account and governed by role-based access control.
Share live data across organisations using Snowflake’s metadata layer, enabling instant updates without data movement, via data shares, the Snowflake marketplace, or data exchange, with governance and RBAC.
Explore Snowflake governance and usage tracking, including access and query history, data masking and row-level security, tag-based classification, lineage, resource monitoring, and secure data sharing for compliant, transparent analytics.
Master design patterns for efficient snowflake data, queries, and semi-structured handling. Implement elt, raw-staging-curated layers, micropartitions, and time travel for speed and cost control.
master production in Snowflake by right-sizing warehouses, using auto-suspend and auto-resume, and flattening JSON, Avro, Parquet into structured columns, with a least-privilege role hierarchy and thoughtful clustering.
Disclosure: This course contains the use of artificial intelligence.
Welcome to the definitive guide to Snowflake, the world’s leading AI Data Cloud platform. In today’s data-driven economy, traditional warehousing is no longer enough. Businesses now require the ability to scale compute instantly, govern data globally, and integrate Artificial Intelligence directly into their SQL workflows. This course is designed to take you from a complete beginner to a confident Snowflake professional capable of managing enterprise-level data environments.
We begin with the Foundations, breaking down Snowflake’s unique multi-cluster shared data architecture. You will learn how to navigate the Snowsight interface and manage the core objects: Databases, Schemas, and Tables. From there, we dive into the "engine room" of Snowflake—Virtual Warehouses. You will master scaling strategies, auto-suspension, and performance optimization to ensure your workloads are both fast and cost-effective.
What sets this course apart is our deep dive into Snowflake Cortex. You won't just learn how to move data; you will learn how to use built-in AI functions for sentiment analysis, summarization, and translation directly within your SQL queries. We explore AI-powered data workflows, showing you how to use AI for data cleaning, preparation, and automated pipeline generation.
The latter half of the course focuses on Data Engineering and Analytics. We cover advanced SQL techniques, Window Functions, and query optimization. We also tackle the "unsexy" but vital side of data: Security and Governance. You will master Role-Based Access Control (RBAC), Snowflake Horizon, and FinOps principles to keep your cloud costs under control. Finally, we explore "magic" features like Time Travel, Zero-Copy Cloning, and Micro-partitioning. By the end of this masterclass, you will have the practical skills to build, secure, and optimize a modern data stack that is ready for the AI era.