Python - tannu

Module 1: SQL (Structured Query Language)

• Introduction to Databases

• SQL syntax & data types

• Creating, updating & deleting tables

• SELECT, WHERE, ORDER BY, GROUP BY

• Joins (INNER, LEFT, RIGHT, FULL)

• Subqueries & nested queries

• Aggregate functions

• Views, indexes & constraints

• SQL practice assignments

Module 2: Python Basics

• Introduction to Python & installation

• Variables, data types & operators

• Conditional statements

• Loops (for, while)

• Functions & modules

• Error handling

• Working with lists, tuples, sets & dictionaries

• Basic file handling

• Hands-on exercises & mini tasks

Module 3: Python Programming (Advanced Concepts)

• Object-Oriented Programming (OOP)

• Lambda functions & list comprehensions

• Working with libraries (Pandas, NumPy)

• Data cleaning & preprocessing

• Reading/writing CSV & Excel files

• Basic data analysis workflows

• Real-world Python scripts & automation

Module 4: Excel

• Excel interface & basics

• Formulas & functions (SUM, IF, VLOOKUP, HLOOKUP, INDEX-MATCH)

• Conditional formatting

• Data cleaning tools

• Pivot tables & pivot charts

• Filters, sorting & data validation

• Excel dashboards basics

Module 5: Tableau

• Introduction to Tableau

• Data connection & data sources

• Dimensions & measures

• Charts: bar, line, pie, maps

• Calculated fields

• Filters, parameters & groups

• Creating dashboards

• Publishing and sharing reports

• Visualization best practices