Sql Server syllabus

------------------Day-1----------------------

Step1-About management studio
Step2-Creating tables
          Altering tables
          Adding new columns
          Altering existing columns
          Data type Decrease/Increase
Step3-Insert data into tables
          Simple insert
          Columns by insert
          Bulk insert
          Insert using union
Step4-Identity and its properties .


------------------Day-2--------------------------

Step1-Inserting data from existing tables to newly created table
Step2-inserting data from one table to other table (both should be existing)
Step3-Creating new tables from existing table
          With data
          Without data
Step4-Creating relationships
Step5-creating constraints
Step6-Learn foreign key value errors
Step7-On cascade delete
Step8-Drop
          Truncate
          Delete

 ----------------Day-3-----------------

  Step1-Joins
                   Inner join
                   Outer join
                   Cross join
                   Self join
Step2-Sql syntax
Step3-Sub Queries(inline views)
Step4-Correlated sub queries
Step5-Views
Step6-Difference between views & inline views
Step7-Group by
          Having
          Order by

 --------------------Day-4-------------------------

Step1-Procedures
                            -In parameters
                            -Out parameters


Step2-Functions
                        -Predefine functions
                        -Built in functions
                        -UDF
                               -Table functions
                               -Scalar functions
Step3-CTE

------------------------- Day-5---------------------

Step1-While loop
Step2-If conditions
Step3-Using all those prepare procedures
Step4-String Manipulations
Step5-Dynamic SQL
                              -Exce
                              -Sp_excesql

--------------------------Day-6-------------------------

Step1-Triggers
                       -DML Triggers
                       -DDL Triggers
Step2-Cursors
Step3-Temp tables
Step4-Eliminate Cursors with temp tables




------------------Day-7---------------------------

Step1-Data migration
Step2-Dbcc commands
Step3-Tunning Queries
Step4-Tunning Wizard
Step5-Simple DBA roles
          Backups
          Restores
          Jobs