infyni

Snowflake Cloud Data Warehouse live

Unlock the power of Snowflake Cloud Data Warehouse with our live course. Led by industry experts, this program provides hands-on experience and insights into utilizing Snowflake for effective data management and analytics.

Live Course

Live Class: Thursday, 25 Jan

Duration: 40 Hours

Enrolled: 0

Offered by: infyni

Live Course
$2500 50% off

$1250

Enroll Now

About Course

Dive into the world of modern data management with our Snowflake Cloud Data Warehouse Live course. Led by industry experts, this live program is designed to demystify Snowflake, the leading cloud-based data warehouse solution. Participants will gain hands-on experience in data warehousing, learn to harness the power of Snowflake's features, and understand best practices for efficient data processing and analytics. Whether you're a data professional, analyst, or business leader, this course empowers you to harness the full potential of Snowflake for data-driven decision-making.

Skills You Will Gain

Introduction to Snowflake Setting Up Snowflake Data Loading and Unloading SQL for Snowflake Data Modeling Managing Users and Roles Optimizing Query Performance Snowflake Functions and Stored Procedures Data Sharing and Collaboration Security and Compliance Snowflake Integration with BI Tools Automation with Snowflake Tasks Backup and Recovery Monitoring and Troubleshooting Best Practices for Snowflake Deployment

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
1 Snowflake Architecture 1.0

  • Introduction

  • Creating Snowflake Account 
  • Testing Snowflake
  • Understanding the Web UI Components
  • Installing SnowSql
  • Using Command Line Interface
  • In-Dept
  • nowflake Architecture 2.0

  • Introduction to DATA Loading in Snowflake
  • Bulk Loading DATA / Big Data
  • Data Load - Copy - Bulk Load
  • Apply transformation while Loading
  • Loading COMPRESSED file from AWS S3 to Snowflake
  • Additional Data Load and Transformations
  • Internal Stages
  • Types of Internal Stages (User, Table)
  • External Stages
  • Results Cache
  • Local Cache
  • Disk Cache
  • Creating Cluster Tables
  • Cluster Tables with expressions
  • Order By Clause
  • Manual re-clustering
  • Best practices in Micro-Partitioning and Clustering
  • Multi-Cluster Virtual Warehouses
  • Launching New Clusters
  • Using Dedicated Virtual Warehouses
  • Scale Out - Auto Scale
  • Best practices in choosing the Virtual Warehousing strategy
  • Establishing Secure Connection AWS-Snowflake
  • AWS IAM Roles
  • Loading data to AWS
  • Creating Table, External Stage Objects
  • File Format Objects
  • Creating INTEGRATION Objects in Snowflake
  • Data Loading from AWS to Snowflake
  • CSV Data Loading from AWS to Snowflake
  • Parquet Data Loading from AWS to Snowflake
  • JSON Data Loading from AWS to Snowflake
  • Nested Data Loading from AWS to Snowflake
  • XML Data Loading from AWS to Snowflake
  • Query Management and Optimization
  • Concurrency Control
  • Continuous Data Loading
  • SNOWPIPES
  • Configure AWS S3 for Snowpipes
  • AWS Events
  • SQS Queue
  • Permanent Tables
  • Transient Tables
  • Temporary Tables
  • Set Data Retention Timings
  • Query Historical Data
  • Cloning Historical Objects
  • Time Travel for Data Recovery
  • Detailed Overview, Features by Snowflake
  • Clone Database, Pipes, Streams, Tasks& Stages
  • Clone Schema & Tables
  • Cloning Table Storage Metrics
  • Cloning Using Time Travel
  • Swap Tables
  • Tasks and Task Tree
  • Implement a Standalone Task
  • Stored Procedures using Tasks
  • Streams in Snowflake
  • Standard Streams
  • Appen Only Streams
  • Best Practices
  • From SNOWPIPE-to-TEMP_TABLES-to-STREAMS-to-Tasks-to-Permanent Tables in SNOWFLAKE
  • Secure data Sharing
  • Sharing with other Snowflake users
  • Sharing with non-Snowflake Users
  • Creating READER ACCOUNTS
  • Snowflake Approach to Access Control & Key Concepts
  • Role Hierarchy in Snowflake
  • ACCOUNTADMIN Roles
  • SECURTIYADMIN Roles
  • SYSADMIN Roles
  • Custom Roles
  • Public Roles
  • Creating multiple accounts in Snowflake
  • Concept of Organizations
  • Billing Management
  • ORGADMIN ROLE
  • Connect Power BI with Snowflake
  • Creating Graphs and Charts
  • Anaconda / Spyder Setup, Installing Snowflake python connectors
  • Building python apps for querying Snowflake
  • Storage Costing
  • CREDITS compute Costing
  • Data Transfer Costing
  • Used Case on Snowflake costing

...
Omar Khan
About Instructor

19+ years of IT Industry with core experience in design and implementation of Data Warehousing and Data Integration Solutions on Business Intelligence, ETL, Big Data on AWS and Snowflake Cloud Data Warehousing. Expertise in implementing data warehousing and data integration solutions. Expertise in Databases like Snowflake, Big Data Hadoop, Oracle ODI(ETL), Cognos BI, Actuate BI. Conducted training for professionals across industries and business houses, both at their workplaces and through online channels

0

Rating

0

Review

0

Student

2

Courses