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

30+ resources to learn

❍ SQL
❍ PL/SQL
❍ NoSQL

⇩

➊.➀ freeCodeCamp

@mike_dane via @freeCodeCamp

➤ SQL Tutorial for

➊.➁ Web Dev Simplified (WDS)

@DevSimplified

➤ Learn SQL in 60

➊.➂ Programming with Mosh

@moshhamedani

➤ MySQL Tutorial for

➊.➃ Kevin Stratvert

@kevstrat

➤ SQL Tutorial for