
Overview
Module 1:
1. Basics of SQL
2. Hands on basic SQL
3. Advance Analytical SQL
4. Hands on Advanced SQL
Module 2:
1. Overall Concepts of Data Warehousing
2. Types of SCDs are their Use cases
3. Different Architectures of Storing and Utilizing data
4. Use cases of OLTP and OLAP as per industry trend
Module 3:
1. What is ETL and Its role in Analytics?
2. Overview on ETL Tool- IICS (Informatica Intelligent Cloud Services)
3. Understanding the development with IICS
4. Understanding different types of transformations in IICS
5. Different Optimization strategies through IICS
6. 4 Hands on practice session on IICS
Module 4:
- Tableau Basics
- Tableau- Use cases for Data Visualization
Module 5:
1. Doubt clearing session
2. 3 days Interview Preparation with Assignments
3. Mock Interview (2 Mock interviews of 30 mins for each candidate)
Course Features
- Lectures 11
- Quizzes 0
- Duration 6 weeks
- Skill level Beginner
- Language English
- Students 1492
- Certificate No
- Assessments Yes