Snowflake Advanced 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
CategorĂ­a:

Descargar PDF de detalles del curso

DescripciĂłn del curso:

This 3-day course covers advanced Data Movement, Performance, Security, Agile Development and Data Sharing design considerations and best practices in the Snowflake Cloud Data Platform. This advanced course will consist of lecture, demos, and labs.

Formato

Dirigido por un instructor

Tema

Longitud

Esquema del curso

Week 1:

Introductions
Arquitectura

  • Recap
  • Compute

Clustering

  • Natural Clustering
  • Auto Clustering Service
  • Explicit Clustering

Almacenamiento en caché

  • Query Result Cache
  • Metadata Cache
  • Warehouse Cache

Deployment Approaches
Loading data

  • Best Practices
  • Transforming Data
  • Unloading Data

Semi-Structured Data

  • FLATTEN Data
  • Applications
  • Advanced Topics

Week 2:

Snowpipe
Data Lake Support
Querying

  • Constructing Efficient Queries
  • Pruning
  • Grouping and Sorting

Continuous Data Protection

  • Viaje en el tiempo
  • Cloning

Streams and Tasks

  • IntroducciĂłn
  • Streams
  • Tareas
  • Streams and Tasks Together

Agile Database Development

  • Recap
  • Replication

Global Snowflake

  • Overview
  • Replication

Week 3:

Data Sharing

  • Advanced Sharing Topics
  • Secure Objects

Clients

  • PitĂłn
  • Pandas
  • SQLAlchemy
  • Spark

Managing Security

  • Overview
  • Encryption Key Management

SCIM

  • Overview
  • SCIM for Okta
  • SCIM for Active Directory

Access Control

  • Authorization
  • Privileges
  • Users
  • Roles

Performance

  • Tuning Metrics
  • Bottleneck Scenarios
  • concurrencia
  • Concurrency Scenarios
  • Concurrency Issues

Monitoring

  • ACCOUNT_USAGE Share
  • Compute
  • Storage
  • Serverless Services
  • Resource Monitors

Materialized Views
Newer SQL Features

  • Procedimientos almacenados
  • Collations
  • CTEs and CONNECT BY

Objetivos del Curso

By the end of this course, you will be able to:

  • Evaluate Snowflakes advanced architectural concepts
  • Employ strategies and best practices for agile development
  • Discuss Snowflakes various ingestions methods for streaming data
  • Develop a methodology for performance tuning
  • Design a comprehensive program for ensuring user, network & data security
  • Share data in or outside of your organization securely

PĂşblico objetivo

Who should attend this course?

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

Requisitos previos

Students should have completed Fundamentals training or have previous working knowledge of Snowflake.

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

 

Carro de la compra
es_CRSpanish