• Task1 - Database schema and ER diagram

• Task2 - DML statements and Handling null along with default values.

• Task3 - Extracting data using where clause, groupby, orderby and having clause.

• Task4 - Aggregate functions and grouping.

• Task5 - Joins and its types.

• Task6 - Subqueries and nested queries.

• Task7 - Views and its Usage.

• Task8 - Stored procedures and trigers.