Python and MySQL Training Scheme of Work for 30 Days

 

Day	Topic	Details	Video Link
1	Introduction to Python	Installing Python, IDE setup, basic syntax	Python Basics
2	Variables and Data Types	Understanding variables, data types (int, float, str, bool)	Variables and Data Types
3	Operators	Arithmetic, comparison, logical, and assignment operators	Operators
4	Control Flow - Conditional Statements	if, elif, else statements	Conditional Statements
5	Control Flow - Loops	for loops, while loops, break, continue	Loops
6	Functions	Defining and calling functions, return statement	Functions
7	Project Day	Simple calculator or temperature converter	Project: Calculator
8	Lists	Creating lists, accessing elements, list methods	Lists
9	Tuples and Sets	Understanding tuples and sets, differences from lists	Tuples and Sets
10	Dictionaries	Creating dictionaries, accessing and modifying values	Dictionaries
11	File Handling	Reading from and writing to files	File Handling
12	Exception Handling	try, except, finally, raising exceptions	Exception Handling
13	Object-Oriented Programming (OOP)	Classes and objects, inheritance, polymorphism	OOP Basics
14	Project Day	Create a basic class-based project (e.g., a simple game)	Project: OOP
15	Modules and Packages	Importing modules, creating packages	Modules and Packages
16	Working with Libraries	Using popular libraries (e.g., NumPy, Pandas)	Libraries
17	Project Day	Data analysis project using Pandas	Project: Data Analysis

 

MYSQL TRAINING SCHEME

Day	Topic	Details	Video Link
18	Introduction to MySQL	Installing MySQL, basic SQL syntax, MySQL Workbench	MySQL Basics
19	Database Design	Creating databases, understanding tables, primary keys	Database Design
20	CRUD Operations	INSERT, SELECT, UPDATE, DELETE statements	CRUD Operations
21	Data Types and Constraints	Different data types, applying constraints	Data Types and Constraints
22	Joins and Relationships	INNER JOIN, LEFT JOIN, RIGHT JOIN, understanding relationships	Joins and Relationships
23	Aggregations and Grouping	COUNT, SUM, AVG, GROUP BY, HAVING	Aggregations
24	Subqueries and Nested Queries	Writing subqueries, nested queries	Subqueries
25	Indexes and Optimization	Creating indexes, optimizing queries	Indexes and Optimization
26	Stored Procedures and Functions	Creating and using stored procedures and functions	Stored Procedures
27	Triggers and Events	Creating and using triggers, scheduling events	Triggers
28	User Management and Security	Creating users, setting permissions, securing the database	User Management
29	Backup and Recovery	Backup strategies, restoring databases	Backup and Recovery
30	Final Project	Develop a complete database-driven application using Python and MySQL	Project: Full Application