- Week 1: Introduction, Creating Tables, Common Queries, Inserting, Constraints, DDL
- Week 2: DML, INSERT/UPDATE/DELETE, WHERE, Conditional Expressions
- Week 3: Aggregate Functions, Joins, UNION (ALL)
- Week 4: Views, Derived Attributes (Strings, Temporal, etc.)
- Week 5: SubQueries, Multilevel SubQueries
- Week 6: Transaction, SavePoint, Implicit Commit Statements
- Week 7: Procedures, Functions, Cursors, Nested Call of Stored Subroutines
Each week contains a Practice_WeekX.sql and a Exercise_WeekX.sql file along with the labsheet for that week (obv lol). Practice_WeekX.sql contains all the follow along examples and key points from the labsheet and Exercise_WeekX.sql file contains practice questions along with their solutions provided at the end of the labsheet.
There are a total of 3 schemas (University, Employee, Resteraunt) that have been used while solving questions in the labsheet and schemas for each of them are provided in the root folder. You can copy paste the file into mysql terminal or execute the file from your workbench.
Additionally University database also has 37000+ dummy entries which can be inserted into it by running the largeRelationsInsertFile.sql file.