Python and MySQL

DETAILED MODULE-WISE SYLLABUS

BASIC PYTHON PROGRAMMING COURSE


Introduction to Python & Installation
Topics Covered:

• Introduction to Programming
• What is Python?
• Applications of Python
• Python Features and
Advantages
• Installing Python (Windows / Mac)
• Installing IDE (IDLE / VS Code)
• Writing and running first Python program
• Python syntax rules
• Keywords and identifiers

Practical:
• First program: Hello World
• Simple input and output programs

Assignment:
• Create programs using print() and input()

Data Types & Variables
Topics Covered:

• Variables and Naming Rules
• Integer
• Float
• String
• Boolean
• Type Conversion
• Input from User
• Output Formatting

Practical:
• Student Details Program
• Area Calculation Programs

Assignment:
• Create Programs Using Different Data Types


Operators & Conditional Statements
Topics Covered:

• Arithmetic Operators
• Comparison Operators
• Logical Operators
• Assignment Operators
• if
• if-else
• if-elif-else
• Nested if

Practical:
• Even or Odd Number
• Largest of Three Numbers
• Grade Calculator

Assignment:
• Decision-Making Based Programs

Loops
Topics Covered:
• Introduction to Loops
• for Loop
• while Loop
• range() Function
• Nested Loops
• break and continue Statements
Practical: • Multiplication Table • Pattern Programs • Sum of Numbers Assignment: • Loop-Based Logic Building Exercises

Functions
Topics Covered:
• Introduction to Functions
• Creating Functions
• Function Parameters
• Return Statement
• Advantages of Functions

Practical:
• Calculator Using Functions
• Function to Check Prime Number

Assignment:
• Modular Programming Exercises

Lists
Topics Covered:
• Introduction to Lists
• Creating Lists
• List Indexing and Slicing
• append()
• insert()
• remove()
• pop()
• Iterating Through Lists

Practical:
• Student Marks List
• Find Maximum and Minimum

Assignment:
• List Manipulation Programs

Tuples
Topics Covered:

• Introduction to Tuples
• Tuple vs List
• Tuple Indexing and Slicing
• Tuple Operations

Practical:
• Tuple Data Storage
• Access and Display Tuple Elements

Assignment:
• Programs Using Tuple Data

Strings
Topics Covered:
• Introduction to Strings
• String Indexing and Slicing
• upper()
• lower()
• replace()
• find()
• split()

Practical:
• String Manipulation Programs
• Palindrome Checking

Assignment:
• Text-Based Programs

Dictionary

Topics Covered:
• Introduction to Dictionary
• Key-Value Pairs
• Creating Dictionary
• Accessing Elements
• Dictionary Methods

Practical:
• Student Record System
• Store and Retrieve Data

Assignment:
• Dictionary-Based Programs

Revision, Project & Test
Topics Covered:

• Revision of All Modules
• Logical Problem Solving
• Mini Project Development

Practical:
• Student Management System
• Calculator Application
• Number Guessing Game

Assignment:
• Practical Test
• Project Evaluation

Teaching Methodology:
• Concept Explanation
• Live Coding
• Practical Sessions

Course Benefits:
• Strong Programming Foundation
• Logical Thinking Skills
• Problem Solving Ability

Certification:
• Certificate After Course Completion

BASIC MYSQL DATABASE PROGRAMMING COURSE

Introduction to Databases & MySQL

Topics Covered:

• What is Database
• DBMS vs RDBMS
• Features of MySQL

My SQL Installation & Tools

Topics Covered:

• MySQL Installation
• MySQL Workbench
• Connecting to Database

Database & Table Basics

Topics Covered:

• Creating Tables
• Data Types
• Constraints
(Primary Key, Not Null, Unique)

Insert Update Delete Data

Topics Covered:

• INSERT Statement
• UPDATE Statement

Select Queries

Topics Covered:

• SELECT Statement
• WHERE Clause
• AND / OR
• LIKE Operator

Sorting And Data Filtering

Topics Covered:

• ORDER BY
• LIMIT

Aggregate Functions (Basic)

Topics Covered:

• COUNT
• SUM
• MIN / MAX

Joins(Basics)

Topics Covered:

• LEFT JOIN
• RIGHT JOIN

Subqueries & Views (Basic)

Topics Covered:

• Creating Views
• Using Views

Revision & Assessment

Topics Covered:

• Query Practice
• Mini Project
• Final Assessment