The Complete Masterclass
Master Snowflake & cloud data warehouse from the ground up
Lo que serás capaz de hacer
Do you want to upgrade your skills and learn how to work with Snowflake professionally ? In this course, you will – step by step – learn everything that is important in Snowflake! Become a master in Snowflake and learn everything from scratch! Why should you take this course? ✓ Understand everything from scratch – step by step, very structured and practice-oriented ✓ Learn all the important features – know when and how to use them properly ✓ Clear explanations and very systematic – theory & practice ✓ Practice everything hands-on – practice & test your knowledge in quizzes & assignments What is in this course? In this course, you will learn everything you need to master Snowflake! This course is giving you the chance to systematically master everything you need to know in Snowflake! ✓ Master all the fundamentals ✓ Master also all the advanced topics ✓ Learn the best practices hands-on ✓ Apply what you’ve learned in a lot of assignments & quizzes ✓ Personal support whenever you have questions This course is right for you if... ... you have never worked with Snowflake and want to learn how to master everything hands-on in just one course. ... OR you already have some basic knowledge and want to dive deeper and become more advanced in the whole universe of Snowflake. This is the one course that covers everything you need to Master Snowflake. Enroll now to get lifelong access and master Snowflake! Not provided by, affiliated with, or sponsored by Snowflake Inc.
- Master all fundamentals & advanced topics
- Helpful for snowflake certification
- Build professional-quality understanding of Snowflake
- Understand the entire Snowflake workflow from end-to end
- Apply your knowlegde in assignments & quizzes hands-on
- Learn from top-rated instructor and professional BI developer
Temario
UNIDAD 1 - Introduction · 4 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Welcome!
- Course Outline
- How to benefit best from the course?
- All course slides & resources
UNIDAD 2 - Getting started · 13 leccionesUNIDAD 2 - Getting started
UNIDAD 2 - Getting started
- Sign up for free trial
- Getting to know the interface
- Understanding Workspaces & Querying Data
- Snowflake architecture
- Architecture
- Setting up warehouse
- Setting up warehouse using SQL
- Setting up warehouse
- Manage warehouses
- Scaling policy
- Exploring tables & databases
- Loading data in snowflake
- Load data
UNIDAD 3 - Snowflake architecture · 10 leccionesUNIDAD 3 - Snowflake architecture
UNIDAD 3 - Snowflake architecture
- What is a data warehouse?
- Cloud computing
- Snowflake editions
- Snowflake pricing
- Data Storage & Transfer Cost
- Monitor Usage
- Resource Monitors
- Setting Up Resource Monitors
- Roles in snowflake
- Architecture
UNIDAD 4 - Loading data · 12 leccionesUNIDAD 4 - Loading data
UNIDAD 4 - Loading data
- Loading methods
- Understanding stages
- Creating stage
- COPY command
- Create a stage & load data
- Transforming data
- Additional transformation techniques
- Copy option: ON_ERROR
- File format object
- Summary
- Loading data
- Create file format object & use copy option
UNIDAD 5 - Copy options · 11 leccionesUNIDAD 5 - Copy options
UNIDAD 5 - Copy options
- Understanding copy options
- VALIDATION_MODE
- Using the copy options
- Working with rejected records
- SIZE_LIMIT
- RETURN_FAILED_ONLY
- TRUNCATECOLUMNS
- FORCE
- Load history
- Copy options
- Using the copy options
UNIDAD 6 - Loading unstructured data · 11 leccionesUNIDAD 6 - Loading unstructured data
UNIDAD 6 - Loading unstructured data
- High-level steps
- Understanding our data
- Creating stage & raw file
- Load raw JSON
- Parsing JSON
- Handling nested data
- Parsing & handling array
- Flatten hierarchical data
- Insert final data
- Querying PARQUET data
- Loading PARQUET data
UNIDAD 7 - Performance optimization · 10 leccionesUNIDAD 7 - Performance optimization
UNIDAD 7 - Performance optimization
- Performance Considerations in Snowflake
- Create dedicated virtual warehouse
- Implement dedicated virtual warehouse
- Scaling up
- Scaling out
- Caching - Theory
- Maximize Caching
- Clustering - Theory
- Clustering - Practice
- Performance optimization
UNIDAD 8 - Loading from AWS · 8 leccionesUNIDAD 8 - Loading from AWS
UNIDAD 8 - Loading from AWS
- Sign up for free trial
- Creating S3 bucket
- Upload files in S3
- Creating policy
- Creating integration object
- Loading from S3
- Handle JSON
- Loading from AWS
UNIDAD 9 - Loading from Azure · 7 leccionesUNIDAD 9 - Loading from Azure
UNIDAD 9 - Loading from Azure
- Sign up for free trial
- Create a storage account
- Create a container
- Create integration object
- Create stage & test connection
- Load CSV file
- Load JSON file
UNIDAD 10 - Loading from GCP · 6 leccionesUNIDAD 10 - Loading from GCP
UNIDAD 10 - Loading from GCP
- Sign up for free trial
- Create a bucket
- Create integration object
- Create stage
- Query & load data
- Unload data
UNIDAD 11 - Snowpipe · 8 leccionesUNIDAD 11 - Snowpipe
UNIDAD 11 - Snowpipe
- What is Snowpipe?
- High-level steps
- Creating stage
- Create & configure pipe
- Configure pipe & notifications
- Error handling for Snowpipe loads
- Manage pipes
- Snowpipe
UNIDAD 12 - Cortex AI & Machine Learning · 14 leccionesUNIDAD 12 - Cortex AI & Machine Learning
UNIDAD 12 - Cortex AI & Machine Learning
- Snowflake Cortex AI - Overview
- AI SQL Functions
- Cortex Search
- Cortex Analyst
- Snowflake ML
- Snowflake Notebooks
- Streamlit in Snowflake
- Hands-on: Overview Of Scenario
- Hands-on: Load The Data
- Hands-on: Text AI
- Hands-on: LLM Function
- Hands-on: Media Al Analytics
- Hands-on: Cortex Service
- Hands-on: Clean Up
UNIDAD 13 - Snowpipe for Azure · 4 leccionesUNIDAD 13 - Snowpipe for Azure
UNIDAD 13 - Snowpipe for Azure
- High-level steps
- Create stage & storage integration
- Create notification integration
- Create pipe and load data
UNIDAD 14 - Time Travel · 9 leccionesUNIDAD 14 - Time Travel
UNIDAD 14 - Time Travel
- What is Time Travel?
- Using time travel
- Time travel
- Restoring data
- UNDROP tables
- Undrop
- Retention time
- Time travel cost
- Time travel
UNIDAD 15 - Fail Safe · 3 leccionesUNIDAD 15 - Fail Safe
UNIDAD 15 - Fail Safe
- Understanding Fail Safe
- Fail Safe storage
- Fail Safe
UNIDAD 16 - Types of tables · 5 leccionesUNIDAD 16 - Types of tables
UNIDAD 16 - Types of tables
- Different table types
- Permanent tables & databases
- Transient tables & schemas
- Temporary tables & schemas
- Types of tables
UNIDAD 17 - Zero-Copy Cloning · 8 leccionesUNIDAD 17 - Zero-Copy Cloning
UNIDAD 17 - Zero-Copy Cloning
- Understanding Zero-Copy Cloning
- Cloning tables
- Cloning schemas & databases
- Cloning with time travel
- Swapping tables
- Swapping (Hands-on)
- Zero-Copy Cloning
- Zero-Copy Cloning
UNIDAD 18 - Data Sharing · 12 leccionesUNIDAD 18 - Data Sharing
UNIDAD 18 - Data Sharing
- Understanding data sharing
- Using data sharing
- Create share through the interface
- Sharing with non-snowflake users
- Creating a reader account
- Creating a database from share
- Set up users for share
- Sharing database & schema
- Secure vs. normal view
- Sharing a secure view
- Share data from multiple databases
- Data Sharing
UNIDAD 19 - Data Sampling · 5 leccionesUNIDAD 19 - Data Sampling
UNIDAD 19 - Data Sampling
- Why data sampling?
- Methods of data sampling
- Sampling data: Hands-on
- Data Sampling
- Data Sampling
UNIDAD 20 - Scheduling Tasks · 9 leccionesUNIDAD 20 - Scheduling Tasks
UNIDAD 20 - Scheduling Tasks
- Understanding tasks
- Creating tasks
- Using CRON
- Understand tree of tasks
- Creating trees of tasks
- Calling a stored procedure
- Task history & error handling
- Tasks with condition
- Tasks
UNIDAD 21 - Streams · 12 leccionesUNIDAD 21 - Streams
UNIDAD 21 - Streams
- Understanding streams
- INSERT operation
- UPDATE operation
- OFFSET in a stream
- Staleness of a stream
- Minimal Set of Changes
- DELETE operation
- Process all data changes
- Combine streams & tasks
- Append-only streams
- Changes clause
- Streams
UNIDAD 22 - Materialized Views · 8 leccionesUNIDAD 22 - Materialized Views
UNIDAD 22 - Materialized Views
- Understand materialized views
- Using materialized views
- Refresh materialized views
- Maintenance costs
- When to use materialized views
- Limitations
- Materialized views
- Materialized views
UNIDAD 23 - Dynamic Data Masking · 6 leccionesUNIDAD 23 - Dynamic Data Masking
UNIDAD 23 - Dynamic Data Masking
- Understanding data masking
- Creating a masking policy
- Unset & replace policy
- Alter an existing policy
- Real life examples
- Data Masking
UNIDAD 24 - Access Management · 14 leccionesUNIDAD 24 - Access Management
UNIDAD 24 - Access Management
- Key concepts
- Roles overview
- ACCOUNTADMIN
- ACCOUNTADMIN in practice
- SECURITYADMIN
- SECURITYADMIN in practice
- SYSADMIN
- SYSADMIN in practice
- Custom roles
- Custom roles in practice
- USERADMIN
- USERADMIN in practice
- PUBLIC
- Access management
UNIDAD 25 - Visualization - Power BI & Tableau · 6 leccionesUNIDAD 25 - Visualization - Power BI & Tableau
UNIDAD 25 - Visualization - Power BI & Tableau
- Data Visualization
- Download & install Power BI
- Connect Power BI & Snowflake
- Working in Power BI
- Download & install Tableau
- Connect Tableau & Snowflake
UNIDAD 26 - Partner Connect - Connecting other tools · 2 leccionesUNIDAD 26 - Partner Connect - Connecting other tools
UNIDAD 26 - Partner Connect - Connecting other tools
- Partner Connect
- Snowflake Marketplace
UNIDAD 27 - Best Practises · 5 leccionesUNIDAD 27 - Best Practises
UNIDAD 27 - Best Practises
- Best practices
- Warehouse Usage
- Table design
- Monitoring
- Retention period
UNIDAD 28 - Bonus · 1 leccionesUNIDAD 28 - Bonus
UNIDAD 28 - Bonus
- Bonus lecture
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
28 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
31 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Nikolai Schuler.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 28 unidades · 223 lecciones · 60 h
- 12 meses de acceso
- 31 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Nikolai Schuler; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
