Web Development With Python and Django

• What exactly is Python?
• Python's root and its ecosystem
• Python Installation & IDEs setting up (Google Colab, Jupyter Notebook, VSCode, PyCharm)
• Python framework & Python syntax
• Hands-on writing code on Google Colab

• Data Types & Variables (String, Integer, Float, Complex, Boolean, None)
• Input and Output Functions
• Working with the format() method, f-strings, & escape sequences
• Basic Arithmetic & Operators
• Type casting, type checking, & validation

• Conditional Statements (if, else, elif)
• Loops (for, while)
• Looping over tuples, strings, & dictionaries
• Special loops in Python (for/else)
• Using nested loops and flow control through conditions
• Resolving real-world problems to improve skills
• Special Statements: pass, continue, break

AI Tool:

• Google Colab - Gemini

Lists:

• Overview & fundamental operations
• Indexing, slicing, & negative indexing
• Looping through lists & conditions
• List methods like .insert(), .append(), .remove(), .sort(), etc.
• List comprehension with conditions

Tuples:

• Introduction & operations
• Indexing, slicing, & looping
• List versus Tuple
• Switching between lists and tuples
• Tuple unpacking

Sets:

• Introduction & set operations
• Adding, removing, & discarding items
• Set operations: union, intersection, and difference
• Frozenset versus set

Dictionaries:

• Introduction to dictionaries & methods like .get(), .update(), .keys(), .pop(), etc.
• Dictionary comprehension
• Nested dictionaries

AI Tool:

• Gemini or Codeium

• Defining functions through def keyword
• Parameters, Arguments, & Return Statements
• Returning multiple values
• Default & keyword arguments
• Anonymous functions (lambda)
• Nested functions & closures
• Scopes in Python: Local and Global

Text File Operations:

• Reading & writing text files
• Modes of file (r, w, a, rb, wb)
• File path handling with the os module

Working with CSV Files:

• Basics of CSV format and operations
• Reading & writing CSV files with csv.reader & csv.writer
• Using dictionaries in CSV files

Working with JSON:

• Introduction to JSON & its structure
• Reading & writing JSON data with the json module
• Parsing JSON strings

AI Tool:

• Using ChatGPT for prompt engineering

• Classes & Objects
• Class versus Object attributes
• Initializing object attributes with __init__()
• self keyword
• Inheritance: single, multiple, and multi-level
• Polymorphism & operator overloading
• Function overriding & encapsulation

AI Tools:

• Pythontutor.com

• Try-except blocks
• Catching specific exceptions
• Using else & finally
• Generating and creating custom exceptions
• Problem-solving strategies

• Lambda Functions
• Generators & Iterators
• List Comprehensions
• Working with *args & **kwargs

Standard Libraries: os, random, math, functools, etc.

Data Manipulation with Pandas

• Working with DataFrames
• Reading & writing CSV files
• Data manipulation techniques

Data Visualization

• Using Matplotlib, Seaborn, and Plotly

AI Tools

• Pandas Profiling

• Designing and changing databases and tables
• CRUD operations (CREATE, SELECT, UPDATE, DELETE)
• Filtering data with the WHERE clause

AI Tools:

• DBeaver for SQL queries
• Optimizing & explaining SQL queries with ChatGPT

• Installing & configuring Git
• Setting up local & remote repositories
• Making commits & branching
• Integrating local repositories to GitHub
• Cloning repositories and pushing

AI Tools

• GitHub Copilot for Git commands

1. Web Scraping + Database + File Operations: Scrape data, store it in SQL, & export to CSV/JSON
2. Desktop Application (Data Entry System): Develop an application to manage data in JSON/CSV format
3. CLI Application with CRUD Operations: Design a CLI app with basic CRUD operations & database integration