Note: These are sample SQL files, with various commands based on the employee database
from Github.
- Sample Areas of coverage -
(1) Data types, (2) Tables creation, (3) Database creation, (4) Comments
(5) Insert, (6) Constraints, (7) Select, (8) Update, (9) Aggregate functions
(10) Joins, (11) Union & Union all, (12) Subqueries, (13) Views, (14) Indexes
(15) Stored procedures, (16) Case statement, (17) Functions, (18) Triggers