Day 1- Introduction to MS SQL Server
Day 2- SQL Server installation
Day 3- What is RDBMS?
Day 4- Normalization
Day 5- De-Normalization
Day 6- ACID Property
Day 7- Variables and Data Types
Day 8- Writing basic queries
Day 9- Writing Advance Queries
Day 10- SQL Server Constraints
Day 11- Aggregate Functions
Day 12- Sub Queries
Day 13- Joins
Day 14- Indexes
Day 15- Views
Day 16- Stored Procedures
Day 17- Triggers
Day 18- User Defined functions
Day 19- Linked Server
Day 20- Cursor
Day 21- Collation
Day 22- Transactions
Day 23- Privileges
Day 24- Sql Server Logins
Day 25- Sql Server Roles
Day 26- Sql Server BackUp
Day 27- Why Temporary Table
Day 28- Why Table variable
Day 29- Some useful queries
Day 30- Useful tips