Descripción del curso:
This 2-day role specific course covers how to explore, load, visualize and extract insights from the Snowflake Cloud Data Platform. This course will consist of lecture, labs, and discussions.
Nube
Opciones de financiación para estudiantes están disponibles.
Snowflake Data Analyst Training
*¿Busca un horario flexible (fuera de horario o fines de semana)? Por favor llame o envíenos un correo electrónico: 858-208-4141 o sales@ccslearningacademy.com.
Opciones de financiación para estudiantes están disponibles.
¿Buscas formación en grupo? Contáctenos
- Descripción
- Información adicional
- Esquema del curso
- Objetivos del Curso
- Público objetivo
- Requisitos previos
- Inclusiones
Esquema del curso
Snowflake Architecture and Overview
• Snowflake Overview
• Architecture 101 & ecosystem
• How to use the Snowflake UI
Data Movement
• Ingesting new data into Snowflake Tables
• Working with various SQL Data Types
• Discussing streaming data & using external data lakes
• Ingestion best practices
Querying Data with SQL
• View the Schema
• Filtering data examples & best practices
• Sorting data & performance considerations
• Commonly used functions
• Save & export data output
• Time Travel queries
Query Caching Performance Features
• Result set cache
• Metadata cache
• Query data cache
• Best practices of using caching for performance and cost optimization
Performing Data Analytic Tasks
• Using Snowflakes high-performing approximation and estimation features
• Join and Union queries & tuning techniques
• Perform advanced analytic tasks using additional SQL querying capabilities including subqueries, common table expressions, and analytic functions.
Using Snowflakes SQL Extensibility Features
• User-defined functions
• Stored Procedures
• Regular Views & Secured Views
Working with Semi-Structured Data
• Data source formats
• Support of native data types
• SQL Operations (Grouping, Sorting & more)
• Built-in functions for traversing, flattening, and nesting of semi-structured data
Visualizing Data
• Connecting a BI Tool to Snowflake
• Exploring & Visualizing data outside of Snowflake
Objetivos del Curso
In this class, you will learn:
- Overview of Snowflake key features & architecture
- Perform advanced and high-performing data analytic tasks
- Load and work with new datasets
- Review key SQL extensibility features
- Query and inspect data using SQL core constructs
- Employ best practices for working with semi-structured data
- Discuss query caching performance capabilities
- Visualizing data outside of Snowflake
Público objetivo
Data Analysts/Business Intelligence users should attend this course.
Requisitos previos
Basic knowledge of SQL is required.
Inclusiones
Con CCS Learning Academy, recibirás:
- Instructor-led training
- Manual del estudiante del seminario de capacitación
- Colaboración con compañeros de clase (actualmente no disponible para cursos a su propio ritmo)
- Escenarios y actividades de aprendizaje del mundo real.
- Soporte para la programación de exámenes*
- Disfrute de asistencia para la colocación laboral durante los primeros 12 meses después de finalizar el curso.
- Este curso es elegible para el programa Learn and Earn de CCS Learning Academy: obtenga un reembolso de la matrícula de hasta 50% si se le coloca en un trabajo a través de CCS Global Tech. División de colocación*
- Precios gubernamentales y privados disponibles.*
*Para más detalles llame al: 858-208-4141 o correo electrónico: formación@ccslearningacademy.com; ventas@ccslearningacademy.com
Spanish 
English