Syllabus

Week 1: Introduction to SQL Part I (Duration:5hr)

• What is Database. (1hr)
• What is a Table. (1hr)
• What is Relational Database (RDBMS). (1hr)
• Entity Relationship Logics. (1hr)
• Introduction to Database Objects. (30min)
• What is SQL. (30min)

Week 2: Introduction to SQL Part II (Duration:5hr)

• DML, DDL and DCL. (30min)
• Data Types. (30min)
• Type of Constraints. (30min)
• Indexes. (30min)
• Retrieving Data using SQL. (30min)
• Restricting Data using SQL. (30min)
• Subqueries. (30min)
• Functions. (1.5hr)

Week 3: Introduction to SQL Part III (Duration:2.5hr)

• Type of Joins. (1hr)
• Set Operators. (30min)
• Views. (30min)
• Query Optimization. (30min)

Introduction to ETL Part I (Duration:2.5hr)

• What is ETL. (30min)
• What is Data Warehouse. (30min)
• What is ODS. (30min)
• Introduction to Informatica Power Center. (1hr)

Week 4: Introduction to ETL Part II (Duration:2hr)

• What is Source Qualifier. (30min)
• What is Target Qualifier. (30min)
• What is Transformation. (1hr)

Introduction to Power BI Part I (Duration:3hr)

• What is Power BI. (30min)
• Data Preparation. (30min)
• Data Modelling & Visualization. (1hr)
• What is Dashboard. (1hr)

Week 5: Introduction to Power BI Part II (Duration:2hr)

• Calculate & Filtering. (1hr)
• Publishing Reports. (1hr)

Introduction to Python (Duration:3hr)

• What is Python. (1hr)
• Data Types. (30min)
• Variables in Python. (30min)
• Functions. (1hr)

Week 6: Introduction to Machine Learning (Duration:5hr)

• What is Machine Learning? (1hr)
• Data and It’s Processing. (1hr)
• Supervised learning. (1hr)
• Unsupervised learning. (1hr)
• Natural Language Processing. (1hr)