Introduction
SQL Server management studio
Design and Implementation
SQL Operations
- DDL and DML commands
- Query commands, nested and correlated queries
- EXISTS, INTERSECT and EXCEPT operator
Indexes
Stored Procedures and UDF
- UDF and their types
- Stored procedures and create procedure
- Conditional and loop constructs
- Develop and execute User Defined Functions (UDF) and stored procedures
Transact-SQL
- SQL Server Objects
- Data Types
- Error Handling
- Apply Operator and CTE
- Subqueries, pivoting and ranking functions
- Powershell
Concurrency
Trigger
Optimization
XML
Security
Administration
Apply for SQL Server 2008 Certification Now!!
http://www.vskills.in/certification/Certified-SQL-Server-2008-Programmer