Data Analytics with Snowflake eLearning
De Data Analytics with Snowflake LearningKIT leert je hoe je Snowflake effectief inzet voor data-analyse en -beheer. In drie tracks ontdek je hoe je Snowflake opzet, queries uitvoert, dashboards maakt en functies zoals Time Travel gebruikt. Je leert data laden vanuit Google Cloud, Azure en AWS, en data veilig wegschrijven naar interne of externe opslag. Ook verdiep je je in performance-optimalisatie, clustering en het werken met continue en semi-gestructureerde data. Daarnaast biedt de training verdieping in geavanceerde analyses binnen Snowflake. Tot slot leer je hoe je Snowflake beheert en objecten veilig deelt. Na afronding ben je klaar om Snowflake slim en veilig toe te passen.
Overview
In the Data Analytics with Snowflake LearningKIT, you will explore Snowflake, how to set up Snowflake, execute queries using the snowflake web interface, and perform various operations like time travel and Fail-safe in snowflake. You will also explore the loading data into Snowflake, integrate Snowflake with Google Cloud Storage, Azure Blob Storage, and Amazon S3, unloading data from Snowflake to all types of internal as well as external storage. You will also learn performance optimization and clustering, working with continuous data and semi-structured data, and performing advanced analytics in Snowflake. You will also explore how to manage and administer snowflake and how to securely share snowflake objects with other snowflake users.
- 12 Months Online Access
- 21+ hours of content
- 1 Assessments
- Tips & Tricks
Track 1: Getting Started with Snowflake
In this track, the focus will be on uisng the Snowflake platform, working with queries, dashboards, tables, and using Time Travel and SnowSQL CLI.
Courses (4 hour +):
- Getting Started with Snowflake: Using the Snowflake Data Platform
- Getting Started with Snowflake: Queries, Dashboards, & Tables
- Getting Started with Snowflake: Using Time Travel & the SnowSQL CLI
Track 2: Working with the Snowflake Data Platform
In this track, the focus will be on Snowflake. You will explore Snowflake data loading and queries.
Courses (8 hours +)
- Data Loading in Snowflake: Fundamentals of Stages
- Data Loading in Snowflake: Using External Stages
- Data Loading in Snowflake: Unloading Data
- Queries in Snowflake: Getting Started with Performance Optimizations
- Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Track 3: Advanced Analytics with Snowflake
In this track, the focus will be on Snowflake continuous data, analytics, and managing Snowflake.
Courses (8 hours +)
- Continuous Data: Ingesting Continuous Data in Snowflake
- Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake
- Advanced Analytics: Performing Analytics Using Snowflake
- Semi-structured Data: Loading and Querying JSON & XML Data in Snowflake
- Managing Snowflake: Administering a Snowflake Account
- Data Sharing in Snowflake: Implementing Secure Data Sharing
Assessment:
• Final Exam: The Snowflake Data Platform