Course Overview
Why Choose This Course?
Everything you need to become successful
Expert Trainers
Learn from industry professionals with years of experience
Industry Certificate
Get certified and boost your career prospects
Course Curriculum
Comprehensive modules designed for complete learning
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
Course Demo Video
Watch this demo video to get an overview of what you'll learn in this course.
Book Free Demo Class