Indian Institute of Technology Kanpur

Python

Indian Institute of Technology Kanpur

Programming & Software Systems

About Programme

Learn Core Python, MySQL, Python-MySQL Integration, and Generative AI with Python in 36 Live Sessions

Certification on successful completion of the program.
Live instructor-led sessions with real-time doubt solving and feedback.
Complete Python training covering core fundamentals, intermediate concepts, MySQL integration, and Generative AI with Python in one structured program.
Hands-on assignments, guided projects, and an AI-powered capstone to build a job-ready Python developer portfolio.

What you'll learn

Build a strong foundation in Python including variables, data types, control flow, functions, file handling, exception handling, and core data structures like lists, tuples, sets, and dictionaries.
Apply intermediate Python concepts including advanced comprehensions, generators, date and time handling, and regular expressions through hands-on projects like an expense tracker and contact book.
Write MySQL queries for database setup, CRUD operations, aggregate functions, joins, and subqueries to manage and retrieve data from relational databases.
Connect Python applications to MySQL using MySQL Connector, implement parameterized queries to prevent SQL injection, manage transactions, and build a complete CLI-based Library Management System.
Integrate Generative AI into Python applications using OpenAI and Gemini APIs, work with chat completions and role-based prompts, and build AI-powered tools like a summariser, Q&A bot, and an AI library assistant.

Skills you'll gain

Core Python ProgrammingIntermediate Python - Generators, Comprehensions, RegexFile Handling and Exception ManagementMySQL Database Design and QueryingPython-MySQL Integration and TransactionsSQL Injection Prevention with Parameterized QueriesLLM and Prompt Engineering BasicsOpenAI and Gemini API IntegrationAI Tool Development with PythonGit and GitHub Version Control

Programme Content

Topics Covered

  • Python Basics
  • Variables, Data Types and Operators
  • Strings, Numbers and Formatting
  • Conditional Statements and Loops
  • Lists, Tuples, Sets and Dictionaries

  • Functions & File Handling
  • Functions - args, kwargs, lambda
  • Modules, File Handling and Exceptions

    • Download Full Curriculum

    Topics Covered

  • Advanced Python
  • Advanced Comprehensions
  • Generators and yield
  • Date and Time Handling
  • Regular Expressions

  • Projects
  • Expense Tracker Project
  • Contact Book Project

    • Download Full Curriculum

    Topics Covered

  • Database Concepts
  • Database Setup and Configuration
  • DDL and Table Constraints
  • CRUD Operations
  • Aggregate Functions and GROUP BY
  • Joins and Subqueries

    • Download Full Curriculum

    Topics Covered

  • Integration & Security
  • MySQL Connector and Database Connection
  • Parameterized Queries - Prevent SQL Injection
  • Transactions - commit and rollback

  • Project
  • Library Management System (CLI Project)

    • Download Full Curriculum

    Topics Covered

  • GenAI Fundamentals
  • Introduction to LLMs and Prompt Engineering
  • OpenAI and Gemini API Integration
  • Chat Completions and Role-Based Prompts

  • AI Projects
  • AI-Powered Library Assistant (Capstone)
  • Building AI Tools - Summariser, Q&A Bot

    • Download Full Curriculum

    Program Certificate

    Earn a career certificate

    Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

    Other programs in this subject area you might find useful

    Same topic, Similar duration - Broader exploration across all institutes

    Contact us for the further details

    Speak with an Advisor

    1. Pedagogy (case method, experiential learning, coaching, simulations)
    2. Target Audience
    3. Programme Objective
    4. Faculty Information
    5. Testimonials
    6. Programme Benefits
    7. Brochure

    Prashansa Uttam

    Programme Advisor

    +91 9403890085contact@echomind.oneMon – Fri, 9am – 5pm IST

    Indian Institute of Technology Kanpur

    Executive Education Office

    NA
    NA
    NA
    https://www.iitk.ac.in
    Kanpur, India

    Tell us about your program enquiry

    Fill out the form below and our team will get back to you within 24 hours.

    Python | IIT Kanpur