Advanced Python

Chapter-1 (Multithreading)
1. Implementing Multithreading in Python
2. Different ways of Creating user-defined Threads in Python
3. Program: Creating a Thread without extending any class – target function not taking any
arguments
4. Program: Creating a Thread without extending any class – target function taking some arguments
5. Program: Demo on creating our own Thread by extending Thread class 6. Program: Demo on
creating multiple Threads
7. Synchronization
8. Program: Without Synchronization
9. Program: With Synchronization – using Locks
10. Program: Producer Consumer Threads – Problem (Buggy Program)
11. Program: Producer Consumer Threads – Problem – Solution – using Condition class
12. Program: Producer Consumer Threads – Problem – Solution – using Queue class
Chapter-2 (Socket/Network Programming)
1. What is a Computer Network
2. Different Types of Networks
3. Clients and Servers
4. Sockets
5. Program: Knowing the IP Address of a website
6. Program: To get different parts of the web URL
7. Program: Reading the source code of a Web Page
8. Program: Downloading a web page from internet
9. Program: Downloading an image from internet
10. Socket Programming in Python
11. Program: Socket Programming in Python – Client-Server Demo
12. Program: Socket Programming in Python- creating a chat application – demo
Chapter-3 (Sending Email)
1. Sending Email from Python code - Ex1
2. Sending Email from Python code – Ex2 (Sending to Multiple Receivers)
3. Sending Email from Python code – Ex3 (Sending message with a subject)
4. Sending Email from Python code – Ex4 (Sending message with File Attachment)
Chapter-4 (Python XML and JSON Processing)
1. Program: Python XML Processing Demo1
2. Program: Python XML Processing Demo2 - findall()
3. Program: Python XML Processing Demo3 - iter()
4. Program: Python JSON Processing Demo1
5. Program: Python JSON Processing Demo2 – traversing the details of all Employees
6. Program: Python JSON Processing Demo3 - getting a particular key’s value
7. Program: Python JSON Processing Demo4 - getting nth key’s value in an array
8. Program: Python JSON Processing Demo5 - len()
Chapter-5 (Python Database Programming – accessing MySQL Database)
1. Program: Establishing a connection with the MySQL Database and fetching all records in a table
2. Program: Get a particular Record(s) in a table
3. Program: Add/Insert Record
4. Program: Update a Record
5. Program: Delete a Record
6. Program: Establishing a connection with a public MySQL Database Engine Server and fetching all
records in a table
Chapter-6 (Python Database Programming – accessing Oracle Database)
1. Establishing a connection with the Oracle Database and fetching all records in a table
2. Program: Add/Insert Record
3. Program: Update a Record
4. Program: Invoking a stored procedure in Oracle DB
5. Program: Invoking a stored procedure in Oracle DB with “out” parameters
6. Program: Invoking a stored function in Oracle DB
Chapter-7 (Python Database Programming – accessing MongoDB Database)
1. Program: Establishing a connection with the MongoDB Database and fetching all documents in a
collection
2. Program: To exclude the _id field in a find query in pymongo
3. Program: Get a particular Document(s) in a Collection – condition with logical operator
4. Program: Get a particular Document(s) in a Collection – condition with equality
5. Program: Add a Document to a MongoDB Database Collection
6. Program: Update a Document
7. Program: Delete a Document
8. Setting up a Remote live public MongoDB Database
9. Installing Mongo DB Compass Tool and connecting to the MongoDB Atlas Server 10.
Program: Python Program accessing the MongoDB Live Server
Chapter-8 (Python and Firebase Database Integration)

Round-1
1. What is Firebase
2. Setting up the Firebase Database
3. Choose Firebase database type
4. Program: To add a new Record/Object in Firebase database (Connecting to Firebase using
Python)
5. Program: Get all records from Firebase
6. Program: Get a particular record from firebase
7. Program: Update a record in Firebase
8. Program: Delete a record in Firebase
Round-2
1. Firebase – Authentication Steps Demo
2. Program1: Establishing authenticated connection to the Firebase database
3. Program: Adding data to the Firebase database – using Authentication
4. Program: Add records with Custom ids
5. Program: Getting data from the Firebase database – using Authentication
Chapter-9 (Python accessing SQLite database)
1. What is SQLite Database
2. Checklist for Choosing the Right Database Engine
3. Python Programs accessing SQLite Database
4. Program: Creating a database
5. Program: Adding some data to the SQLite Database
6. Program: Fetching 1st record from the SQLite Database
7. Program: Fetching all records from the SQLite Database
8. Program: Demo on inserting multiple records at once
9. Program: Demo on where condition
10. Program: Demo on update record
11. Program: Demo on delete record
Round-3 (Designs)
1. Program: Spirograph Design1
2. Program: Spirograph Design2
Chapter-11 (Creating user-defined packages)
1. Creating a user defined Package in Python and using it
2. Installing the User defined Packages globally on the Machine
3. Publish User defined Packages in Python to the whole World