👩‍💻 75+ SQL Practice Questions

❍ Oracle
❍ MySQL
❍ SQL Server
❍ PostgreSQL
❍ SQLite

⇩

Topics covered:

➊ Table
➋ Constraints
➀ Primary Key
➁ Unique
➂ Not Null
➃ Default
➄ Check
➅ Foreign Key
➌ Insert, Update, Delete
➍ Select

➊ Table

➀ Create a Table with a few fields by specifying their data types.

➁ Add a field to an existing table.

➂ Modify a field's data type of a table.

➃ Rename a field's name.

➄ Remove a field from a table.

➅ Rename a table's name.

➆ Drop a table.

➋ Constraints

➀ Primary Key
➁ Unique
➂ Not Null
➃ Default
➄ Check
➅ Foreign Key

➋.➀ Primary Key

➤ Create a Table with
➀ a single field as the primary key
➁ 2 or, more fields as the primary key
...

➤ Add a primary key to an existing table
➂ for a single field
➃ for 2 or, more fields
...