Introduction to Python, variables and data types Arithmetic and assignment operators Comparison, logical, identity and membership operators Comments and control statements Nested if and elif while and for loops with range Nested loops and jump statements break and continue
Python strings Lists and list methods Tuples Sets Dictionaries Function definition and arguments Return statements Built-in and Lambda functions Python modules
File handling Exception handling Date functions Introduction to NumPy Classes and objects Inheritance and its types Polymorphism Abstraction Python Mini Project
Introduction to SQL Table creation Inserting data SELECT statements Advanced filtering using BETWEEN, IN, LIKE and IS NULL Logical operators: AND, OR, NOT and AS Aggregate functions: COUNT, SUM, AVG, MIN and MAX
GROUP BY and HAVING UPDATE and DELETE operations Constraints: PRIMARY, UNIQUE, NOT NULL, DEFAULT and CHECK FOREIGN KEY constraints SQL Joins: INNER JOIN, LEFT JOIN and RIGHT JOIN SQL Views and Indexes Transactions: COMMIT, ROLLBACK and SAVEPOINT Stored Procedures and Triggers