Database Handling using Python

Introduction to SQLite

6 topics

• SQLite advantages, features and fundamentals; SQLite datatypes (dynamic type, manifest typing & type affinity: NULL, INTEGER, REAL, TEXT, BLOB)
• Transaction, Rollback, Commit
• Data filtering: Distinct, where, between, in, like, Union, Intersect, Except, Limit, IS NULL
• Having, Group by, Order by, Conditional logic (CASE)
• SQLite joins: Inner, left, cross, self, full outer joins
• SQLite Trigger: concepts of trigger, Before and After trigger (on Insert, Update, Delete); Create, Drop, Disable and Enable trigger

Database backup and CSV handling

4 topics

• SQLite dump: dump specific table into file, dump only table structure
• Dump entire database into file; dump data of one or more tables into a file
• CSV files handling: import a CSV file into a table
• Export a CSV file from a table

Python interaction with SQLite

5 topics

• Module: concepts of module and using modules in Python
• Setting PYTHONPATH, concepts of namespace and scope; concepts of packages in Python
• Importing sqlite3 module: connect() and execute() methods
• Single row and multi-row fetch (fetchone(), fetchall())
• Select, Insert, Update, Delete using execute() method; commit() method

Python interaction with text and CSV

6 topics

• File handling (text and CSV files) using the CSV module; file modes: read, write, append
• Important classes and functions of the CSV module: open(), reader(), writer(), writerows(), DictReader(), DictWriter()
• DataFrame handling using Pandas and NumPy: CSV and Excel extract and write using DataFrame
• Extracting specific attributes and rows from a DataFrame
• Central tendency measures: mean, median, mode, variance, standard deviation
• DataFrame functions: head, tail, loc, iloc, value, to_numpy(), describe()

Data Visualization using dataframe

5 topics

• Importing matplotlib.pyplot and plotting (two-dimensional plots): range(), subplot(), legend(), columns(), len() functions
• Scatter plot: concept, set title, xlabel and ylabel
• Line chart: concept of line plot - plot(), set_title(), legend()
• Histogram chart: concepts of histogram hist(), set title, xlabel and ylabel
• Bar chart: concepts of bar chart bar(), set title, xlabel and ylabel

Previous-year question papers

Published by VNSGU. These open on the university’s own site.

• November 2025Database Handling Using Python-Major
• March 2025MAJOR-1-DATABASE HANDLING USING PYTHON(TH)

Study this subject

Every topic above is a lesson you can read here, in English, Hindi or Gujarati. In Gri-Learn the same topics are graded decks: the self-checks are scored and your weak topics are tracked. Free, with nothing locked.

Already have an account? Sign in