SQLite Database

SQLite constraints define rules or conditions that apply to tables or columns to ensure the integrity of the data and maintain consistency.

The Python SQLite3 module provides an interface for interacting with SQLite databases from Python programs.

Python DB API outlines a standard interface

SQLite dot commands are special commands that can be used in the SQLite CLI( command prompt) to perform various tasks, such as managing the database schema, setting options

SQLite statements are SQL commands that we use to interact with the database. These are organized into different categories based on the CRUD operations.

SQLite Aggregate Functions perform calculations on sets of values, i.e., group of table rows, and return a single result.

The SQLite UPPER() function converts a string into uppercase letters. We can use this function to convert column text values to uppercase.