Python & MYSQL

Course Curriculum

• PYTHON
• Module 1: Introduction to Python – Environment setup, Basic I/O
• Module 2: Conditional Branching Control Statements – if, else, elif
• Module 3: Conditional Looping Control Statements – while, do-while, for
• Module 4: Arguments – Default, Keyword, Arbitrary
• Module 5: Functions – Recursion, Lambda Function
• Module 6: Data Structures – List, Tuple, Stack, Queue
• Module 7: Data Structures – Dictionary, Set in detail
• Module 8: Modules and Packages – User program as modules and packages
• Module 9: Files – Different types of files, File operations
• Module 10: Errors and Exception Handling – Errors, try, except, finally
• Module 11: Exceptions – try, finally, User-defined exceptions
• Module 12: Object-Oriented Programming – Class, Object, Inheritance, Polymorphism
• Module 13: Reference Types – Iterator, Generator
• Module 14: Reference Types – Closure, Decorators
• Module 15: Thread – Multithreading
• Module 16: Graphical User Interface – Textbox, Listbox, Option button, Menu, Canvas
• Module 17: Database Connectivity – MySQL, Create table, Insert table, View table
• Module 18: Networking – Client and server programs
• Module 19: Standard Library – Support for advanced libraries
• Module 20: Creating a Simple Web Application
• Module 21: Form Handling and Basic CRUD Operations
• Module 22: Using Libraries – NumPy and Pandas
• Module 23: Introduction to Flask
• Module 24: Sending Emails with smtplib
• Module 25: Mini Project
• MYSQL
• Module 1: Overview of MySQL – Introduction, Features, Advantages, Installation, Data Types, Variables
• Module 2: User Management – Create User, Drop User, Show Users, Change User Password
• Module 3: Databases – Create Database, Select Database, Show Database, Drop Database
• Module 4: Tables & Views – Create Table, Drop Table, Alter Table, Show Table, Truncate Table, Temporary Table, Copy Table, Views
• Module 5: MySQL Queries – Queries, Constraints, Insert Query, Update Query, Delete Query, Select Query, Insert On Duplicate Key Update
• Module 6: MySQL Indexes – Create Index, Drop Index, Show Index, Clustered Index, Clustered vs Non-Clustered Index
• Module 7: MySQL Clauses – WHERE, AND, OR, LIKE, LIMIT, ORDER BY, GROUP BY, HAVING, DISTINCT, UNION, UNION ALL
• Module 8: MySQL Flow Functions – IF(), IFNULL(), NULLIF(), CASE, IF Statement
• Module 9: MySQL Joins – Join, Inner Join, Outer Join, Cross Join, Self Join, Delete Join, Union vs Join
• Module 10: MySQL Keys – Primary Key, Foreign Key, Unique Key, Composite Key