The DISTINCT clause is helpful when there is need of avoiding the duplicate values present in any specific columns/table. When we use distinct keyword only the unique values are fetched.

The cursor object is created by calling the cursor ( ) method of connection. The cursor is used to traverse the records from the result set.

Execute (sql[, parameters]) :
(i) Executes a single SQL statement. The SQL statement may be parameterized (i.e. placeholders instead of SQL literals).
(ii) The SQlite3 module supports two kinds of placeholders: question marks? ("qmark style") and named placeholders: name ("named style").

cursor. description contains the details of each column headings. It will be stored as a tuple and the first one that is 0(zero) index refers to the column name. Using this command you can display the table's Field names.

(i) The WHERE clause can be combined with AND, OR, and NOT operators.
(ii) The AND and OR operators are used to filter records based on more than one condition.

(i) The ORDER BY clause can be used along with the SELECT statement to sort the data of specific fields in an ordered way.
(ii) It is used to sort the result-set in ascending or descending order.

SQlite_master is the master table which holds the key information about your database tables.

The reason behind the triple quotes is sometime the values in the table might contain single or double quotes.

(i) A cursor in SQL and databases is a control structure to traverse over the records in a database. So it's used for the fetching of the results.
(ii) The cursor object is created by calling the cursor( ) method of connection. The cursor is used to traverse the records from the result set.

The fetchall() method is used to fetch all rows from the database table.
result = cursor. fetchall()

To populate the table "INSERT" command is passed to SQLite."execute" method executes the SQL command to perform some action.
Example:
Sql_command =" " INSERT INTO student (Rollno, Sname, Grade, Gender, Average, birth_date) values (NULL, "Akshay", "B", "M", "87.8", "2001-12-12");" " cursor.execute(sql_command)

If a column of a table is declared to be an INTEGER PRIMARY KEY, then whenever a NULL is used as an input for this column, the NULL will be automatically converted into an integer which will be one larger than the highest value so far used in that column.

Create a connection using connect() method and pass the nanie of the database file.
Example:
#connecting to the database
connection = sqlite3.connect ("Academy.db")
#cursor
cursor = connection.cursor()

Users of database can be human users or programmers, other programs or applications.