👩💻 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
...