Training

Skills You’ll Gain

TDP participants can expect to gain a variety of the following in-demand skills:

Snowflake

How to use Snowflake to build, deploy, manage & maintain a data warehouse on top of the cloud. You will be able to load & transform data in Snowflake, scale virtual warehouses for performance and concurrency, share data and work with Semi-Structured Data.

Azure

Azure services; PowerShell overview; creating and configuring Azure Virtual Machines; managing blobs and containers; configuring and connecting to SQL databases

ETL Design Techniques

Managing ETL strategies; performing initial and incremental loads; CDC, check sum, and time stamp techniques; data profiling, cleansing, validation, and verification

Online Transaction Processing

Database design, data warehouse design, gathering business requirements, ER diagrams, development approaches, data model perspectives, dimensional modeling, loading data

Power BI

Determining dashboard layouts based on information needs; utilizing different visualizations; implementing filters and grouping; creating scorecards with KPIs

SQL Server

Basic and advanced SQL Server programming and administration; SQL Server integration, analysis, and reporting services

Tableau

Building interactive reports per business requirements; creating trend lines, forecast models, and linear graphs with band lines; publishing reports onto the cloud