Python & SQL Practical File – Index
S. No. Section Question / Program Title
1 Python Programming
1.i Program to enter two numbers and print the arithmetic operations like +,
−, *, /, // and %.
[Link] Program to find whether an inputted number is perfect or not.
[Link] Program to check if the entered number is Armstrong or not.
[Link] Program to find factorial of the entered number.
1.v Program to print Fibonacci Series up to n terms.
[Link] Program to check if a string is palindrome using loop.
[Link] Program to show outputs based on entered list.
[Link] Program to enter numbers in a list using split() and use all list functions.
[Link] Program to print Floyd’s Triangle in decreasing order.
1.x Program to find factorial using user-defined module fact().
[Link] Program to read data from file and show file handling utilities.
[Link] Program to append data to file using writelines() function.
[Link] Program to count occurrences of a particular word in a file.
[Link] Program to read data from file and append words starting with letter ‘T’.
[Link] Program to implement stack operations (PUSH, POP, Traversal) using
list.
[Link] Program to display unique vowels present in a word using Stack.
[Link] Program to add, delete and display elements from a queue using list.
2 SQL Commands
2.i SQL queries based on MOVIE table.
[Link] SQL commands for creating database “Sports” and tables TEAM and
MATCH_DETAILS.
[Link] SQL queries based on STOCK table.
[Link] Explanation and examples of COMMIT, ROLLBACK, ORDER BY, NULL,
HAVING, WHERE.
2.v SQL queries for arithmetic, string, and date functions.
3 SQL Connectivity with
Python
3.i Program to show MySQL database connectivity in Python.
[Link] Program to perform operations on Employee table through
MySQL–Python connectivity.
[Link] Menu-based Python–MySQL connectivity script for PRODUCT table in
SHOP database.
[Link] Python program to fetch all records from Mobile Stock table.