Database Fundamentals
Concept of Database transaction, Committing and revoking a transaction using COMMIT and ROLLBACK AND SAVEPOINT.
Grouping Records: GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(), COUNT(); using COUNT(*), DISTINCT clause with COUNT; Group Functions in case of Null Values.
Creating a Table with PRIMARY KEY, Foreign Key, Unique and NOT NULL constraints, Viewing Constraints, Using DESC command to view constraints.
Displaying Data From Multiple Tables: Cartesian product, Union, Intersection and Equi-Join ALTER TABLE for
Deleting column(s), modifying data type(s) of column(s),
Adding a constraint, enabling constraint, dropping constraints.
DROP Table for deleting a table or a database.