Day1 → introduction_ DB Design_ ERD_ File Based System_ DB system
Day2 → SQL Mapping_ DB Schema_ SQL statements_ Creating DB
Day3 → SQL Joins_ Normalization
Day4 → Aggregate Function_ Grouping(I&O)_ Union_ Subqueries_ EERD
Day5 → DB Engine_ SQL Services_ Ranking Function_ Transact SQL
Day6 → Database Constraints_ Rules Create DB
Day7 → Variables_ If_ While_Transactions_ functions
Day8 → View_ Index_ Merge Statment_ Pivot tables
Day9 → Sorted Procedures_ Triggers_ XML
Day10 → Backup _ Restores_ Mirroring_ Jobs_ SQL CLR
By: Ahmed Fawzy