Python SQLite Database

A relational database management system

A graphical user interface

A programming language

A web development framework

CREATE DATABASE

CREATE TABLE

CREATE SCHEMA

CREATE DATABASE TABLE

A unique identifier for each row in a table

A foreign key in a related table

A column that stores binary data

A special type of index for sorting data

ADD

UPDATE

DELETE

INSERT

CREATE TABLE table_name (first_col, second_col, third_col)

CREATE table_name TABLE (first_col, second_col, third_col)

CREATE table_name (first_col, second_col, third_col) TABLE

CREATE (first_col, second_col, third_col) TABLE table_name

SELECT

GET

FETCH

RECEIVE

To filter the results based on a condition

To order the results by a specific column

To group the results by a specific column

To join tables together

A data structure that improves the speed of database queries

A column that stores unique identifiers for each row

A special type of table used for storing binary data

A foreign key in a related table

INT

CHAR

TEXT

DATETIME

DELETE removes individual rows, while TRUNCATE removes all rows at once

DELETE removes all rows, while TRUNCATE removes individual rows

DELETE is a DDL command, while TRUNCATE is a DML command

DELETE is a DML command, while TRUNCATE is a DDL command