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
