Advanced Python – Object Oriented and DataBase (MySQL) Interface Concepts and Practice
This Python course introduces learners to Object-Oriented Programming (OOP) and MySQL integration, preparing them to build scalable, real-world applications. With interactive exercises and a project-based approach, students will design classes, manage data, and develop a complete Python application using OOP and MySQL. Ideal for beginners with basic Python knowledge advancing to intermediate level.
Course Structure
Review of Python Fundamentals
Conditional Statements and Looping statements, lists, strings, tuples, dictionary, Sets, working with functions (Library & User defined) ,exception handling, installation of Anaconda /VSCode/Colab platform
Object Oriented Programming in Python
Concept of class, object and instances, constructor, class attributes and destructors, real time use of class in live projects, inheritance, adding and retrieving dynamic attributes of classes and storing objects in Binary Files.
Database Interaction in Python
SQL Database connection, creating and searching tables, executing SQL commands (insert, update, delete and alter), programming using database connectivity
Text and Binary file operations in Python
Understanding read functions (read, readline and readlines) and write functions (write and writelines), manipulating file pointer using seek and tell, binary file creation and programming using pickle.load() and pickle.dump(), working with lists, tuples and objects in binary files
Use of Regular Expressions
Powerful pattern matching and searching, password, email, url validation using regular expression, pattern finding programs, finding and replacing strings
Sample Projects (Binary Files & SQL)
Bank Management System, Admission Process Handling System.