Snowflake Training

Na inschrijving van de Award Winning E-learning training Snowflake, ontvangt u per e-mail een link om in te loggen in uw leeromgeving waar u een persoonlijk wachtwoord aanmaakt. Eenmaal ingelogd in uw persoonlijke leeromgeving ziet u een overzicht van de cursusonderdelen. Via de inhoudsopgave schakelt u automatisch over naar elk gewenst onderdeel van de training.

Er zit tevens een Voortgangsbewaking bij om eenvoudig te zien hoe ver u bent binnen uw training. U kunt daarbij 1 jaar lang (365 dagen), 24/7 (elke dag en nacht) inloggen om verder te gaan met de training.

Deze Engelstalige training met ondertiteling heeft interactieve, eenvoudig te volgen video's in HD beeldkwaliteit met heldere audio kwaliteit. Daarnaast biedt de training Support en/of een Online Mentor aan als u problemen ondervindt. De training is beschikbaar in elke browser voor zowel PC, Mac, Tablet én Smartphone. Dus zelfs via uw mobiel kunt u handig de training volgen.

De training is inclusief lees- en/of praktijkopdrachten met trainingstest, mits noodzakelijk voor de training. Na afronding van de training krijgt u een Certificaat van Deelname en sluit u zich aan bij de reeds duizenden tevreden cursisten.

Cursusinhoud

• Getting Started with Snowflake
• Data Loading and Unloading in Snowflake
• Advanced Analytics in Snowflake
• Optimizing Query Performance in Snowflake
• Managing and Administering Snowflake
• Secure Data Sharing in Snowflake
• Working with Continuous Data in Snowflake
• Working with Semi-structured Data in Snowflake

Getting Started with Snowflake Getting Started with Snowflake: Using the Snowflake Data Platform

Course: 1 Hour, 58 Minutes

• Course Overview
• The Snowflake Data Platform
• The Snowflake Architecture
• Snowflake Editions
• Snowflake’s Billing Model
• Setting up a Snowflake Free Trial
• Snowflake Warehouses
• Objects in Snowflake
• the Snowflake UI
• Using Snowflake Objects
• Running Basic Queries
• Creating a Simple Warehouse
• Creating Databases and Tables from the UI
• Reading Data into Snowflake
• Moving Tables across Schemas
• Course Summary

Getting Started with Snowflake: Queries, Dashboards, & Tables

Course: 1 Hour, 26 Minutes

• Course Overview
• Using Snowsight
• Creating Objects from Snowsight
• Viewing the Output of Snowsight Queries
• Running Various Queries
• Using daterange and datebucket
• Adding Visualizations to Dashboards
• Partitioning and Clustering
• Types of Tables in Snowflake
• Using Permanent and Temporary Tables
• Utilizing Temporary Tables
• Using Transient Tables
• Course Summary

Getting Started with Snowflake: Using Time Travel & the SnowSQL CLI

Course: 1 Hour, 26 Minutes

• Course Overview
• The Phases of Snowflake Data Storage
• Configuring a Table for Time Travel
• Using Query IDs and Time Offsets for Time Travel
• Cloning Historical Copies of Data Using Timestamps
• Restoring Dropped Tables
• Installing SnowSQL on Mac
• Installing SnowSQL on Windows
• Executing Queries from SnowSQL
• Running Queries in Source Files
• Defining and Using Variables
• Writing Out Query Results to Files
• Course Summary

Data Loading and Unloading in Snowflake Data Loading in Snowflake: Fundamentals of Stages

Course: 2 Hours, 9 Minutes

• Course Overview
• Stages in Snowflake
• Data Loading in Snowflake
• Bulk Loading and Snowflake Stages
• Creating a Warehouse for Loading Data into Snowflake
• Loading Erroneous Data into Snowflake
• Loading Data into Snowflake
• Downloading Query Results from Snowflake
• Recognizing Limitations of the Classic Snowflake UI
• Loading Data into the User Stage of Snowflake
• Loading Data from Stages in Snowflake to a Table
• Using Named Stages in Snowflake
• Using Table Stages in Snowflake
• Using Error Modes for Table Stages in Snowflake
• Creating Named Stages in Snowflake
• Copying Data with Named Stages in Snowflake
• Course Summary

Data Loading in Snowflake: Using External Stages

Course: 1 Hour, 33 Minutes

• Course Overview
• Bulk Loading in Snowflake from Cloud Platforms
• Bulk Loading in Snowflake from Google Cloud Storage
• Creating a Google Cloud Storage (GCS) Bucket
• Setting up a GCP Integration
• Connecting to GCS from Snowflake
• Bulk Loading in Snowflake from Microsoft Azure
• Configuring an Azure Storage Account
• Integrating Blob Storage with Snowflake
• Bulk Loading in Snowflake from Amazon S3
• Setting up Amazon S3
• Integrating with Amazon S3 from Snowflake
• Connecting Snowflake to Amazon S3 Using Access Keys
• Using External Tables in Snowflake
• Course Summary

Data Loading in Snowflake: Unloading Data

Course: 1 Hour, 14 Minutes

• Course Overview
• Data Unloading in Snowflake
• Unloading Data in Snowflake to User Stages
• Unloading Data in Snowflake Using Table Stages
• Unloading Data in Snowflake to Named Stages
• Unloading Data in Snowflake to the GCP
• Unloading Data in Snowflake to Azure
• Unloading Data in Snowflake to Amazon S
• Querying Files in Snowflake Stages
• Querying Table and Named Stages in Snowflake
• Querying External Stages in Snowflake
• Course Summary

Advanced Analytics in Snowflake Advanced Analytics: Performing Analytics Using Snowflake

Course: 1 Hour, 50 Minutes

• Course Overview
• Big Data Analytics in Snowflake
• Performing Join Operations in Snowflake
• Executing Additional Joins in Snowflake
• Using Subqueries
• Snowflake Sampling
• Performing Row and Block Sampling in Snowflake
• Using CTEs within Queries
• Employing Self-joins and Recursive CTEs
• Using the CONNECT BY Clause
• Snowflake Windowing
• Utilizing Rank-related Functions
• Using Ranking and Windowing Functions
• Performing Windowing Operations
• Utilizing Sliding Windows
• Course Summary

Optimizing Query Performance in Snowflake Queries in Snowflake: Getting Started with Performance Optimizations

Course: 1 Hour, 52 Minutes

• Course Overview
• Micro-partitions in Snowflake
• Snowflake Caching
• Loading Data into Tables
• Using Caching in Snowflake
• Disabling Caching
• Querying Data Using the Local Disk Cache
• How Clustering Works in Snowflake
• Overlap Depth of Micro-partitions
• Snowflake Clustering Concepts
• Choosing Clustering Keys
• Using Clustering
• Running Queries on Clustered Data
• Suspending Clustering
• Clustering with Multiple Key Columns
• Course Summary

Queries in Snowflake: Search Optimization, External Table Partitions, & Views

Course: 1 Hour, 32 Minutes

• Course Overview
• Search Optimization in Snowflake
• Enabling Search Optimization
• Using Search Optimization
• Comparing Search Optimization and Clustering
• Partitioning of Snowflake External Tables
• Creating an External Stage and Table
• Partitioning External Tables
• Performing Manual Partitioning on External Tables
• Views in Snowflake
• Creating Views
• Querying Views
• Querying Materialized Views
• Creating and Using Secure Views
• Course Summary

Managing and Administering Snowflake Managing Snowflake: Administering a Snowflake Account

Course: 1 Hour, 28 Minutes

• Course Overview
• Snowflake Parameters
• Viewing Accounts and Users in an Organization
• Creating Snowflake Accounts
• Configuring Parameters in Snowflake
• Using User-level Parameters in Snowflake
• Using Object-level Parameters in Snowflake
• Snowflake Security Configuration
• Using Resource Monitors in Snowflake
• Setting up Single Sign-on (SSO) Using Okta
• Using SSO in Snowflake
• Using Key Pair Authentication with Snowflake
• Masking Data in Columns
• Course Summary

Secure Data Sharing in Snowflake Data Sharing in Snowflake: Implementing Secure Data Sharing

Course: 1 Hour, 48 Minutes

• Course Overview
• Data Sharing in Snowflake
• Secure Sharing Constraints
• Creating Objects for Secure Sharing
• Setting Up a Secure Share
• Accessing Shared Data as a Consumer
• Creating and Sharing Data with Reader Accounts
• Using Snowflake Marketplace
• Viewing Permission Grants on Shareable Objects
• Defining a Secure Share Using Queries
• Creating a Destination Account for Replication
• Setting Up Cross-region Data Replication
• Migrating Objects to a Replica
• Course Summary

Working with Continuous Data in Snowflake

Continuous Data: Ingesting Continuous Data in Snowflake

Course: 48 Minutes

• Course Overview
• Processing Data in Micro-batches
• Continuous Data Ingestion with Snowpipes
• Setting Up a Table and Stage for Data Ingestion
• Creating a Snowflake Pipe
• Ingesting Data with a Snowpipe
• Course Summary

Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake

Course: 1 Hour, 27 Minutes

• Course Overview
• Configuring an Azure Storage Account
• Setting Up an S3 Integration in Snowflake
• Creating an Azure Notification Integration
• Integrating Snowflake with Azure
• Streaming Data from Azure
• Creating an AWS IAM Role
• Configuring an SNS Topic
• Integrating AWS with Snowflake
• Testing the Integration with AWS
• Course Summary

Working with Semi-structured Data in Snowflake Semi-structured Data: Loading and Querying JSON & XML Data in Snowflake

Course: 1 Hour, 20 Minutes

• Course Overview
• Structured, Unstructured, and Semi-structured Data
• Setting Up a Table and Stage for JSON Data
• Accessing Unstructured JSON Data from Snowflake
• Loading Arrays into Snowflake Tables
• Extracting Column Values to a Relational Table
• Performing Load Operations for JSON Data
• Stripping Away Outer Arrays from JSON
• Querying JSON Data and Flattening Nested Data
• Querying XML Data and Flattening Hierarchical Data
• Course Summary

Specificaties

Taal: Engels
Kwalificaties van de Instructeur: Gecertificeerd
Cursusformaat en Lengte: Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur: 21:51 uur
Voortgangsbewaking: Ja
Toegang tot Materiaal: 365 dagen
Technische Vereisten: Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning: Helpdesk en online kennisbank 24/7
Certificering: Certificaat van deelname in PDF formaat
Prijs en Kosten: Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie: Wij beoordelen dit per situatie
Award Winning E-learning: Ja

Tip! Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.