Our Cloud and Analytics professionals build managed solutions that address complex data centric business problems. We are cloud agonistic and have a range of solutions to provide business intelligence insights. We help clients ingest, organize, transform, interpret and visualize data. We’ll work with you to build a solution that fits your business, giving you what you need to make better business decisions every day.

Snowflake Training

ExpertLogix offers instructor-led classes and self-directed learning in Snowflake to build career in data engineering. Our well planned training gets you started on Snowflake and build skills for advanced data projects. We explain Snowflake concepts in easy to understand manner through hands-on labs, Exercises and Projects. Our goal is to make you Snowflake expert by providing explanation of Snowflakes basic to advanced concepts. We strive to prepare our candidates for Snowflake Certification and help them in getting job of their choice through job search assistance and mock interviews.

Session-1 ( Overview and Introduction) –

• Getting Started
• UI Overview
• Snowflake Warehouse
• Databases & Schema
• Snowflake Roles
• Access Control

Session-2 ( Working with Data )-

• DDL
• Tables — Create, Truncate, Drop
• DML — Insert, Update, Delete
• SQL — where, group by…
• Functions — String, Date, Logical, Analytical
• Joins
• Views

Session-3 (Loading, Unloading & Pipe)-

• Loading Data — Stages, External Tables, Integrations
• Unloading Data — UI, Programmatically
• SnowSQL
• SnowPipe

Session-4 (Architecture and Advanced Concepts)-

• Snowflake Architecture
• Tasks & Streams
• Stored Procedures

Session-5 (Data Sharing)-

• Data sharing
• Cloning
• Secured Views

Session-6 (Data Security and Recovery)-

• Fail Safe
• Time Travel
• Data Masking
• Mini Project

Session-7 (Optimization and Tuning)-

• Optimization — Clustering, Explain Plan
• Performance Tuning — Micro Partitioning
• Caching
• Materialized Views

Session-8 (Credits)-

• Preparation — Certification, Mock Interview

For Corporates

Enhance skills of performance and productivity of your team

Corporate Training

• Industry specific Customized course curriculum
• Live Instructor-led training through online platforms or Client office facility
• Hands on Labs
• Resources shared for continued learning
• Guidance on certification