Learning Resources
 

 

Introduction
  • RDBMS
  • SQL Server installation, starting and stopping
SQL Server management studio
  • SQL Server management studio Options
  • Query Editor
Design and Implementation
  • Keys and Relationships
  • Normalization
  • Prebuilt Databases
SQL Operations
  • DDL and DML commands
  • Query commands, nested and correlated queries
  • EXISTS, INTERSECT and EXCEPT operator
Indexes
  • Types
  • Create, Drop and alter index
  • Index Performance
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
  • Transactions
  • Locking
Trigger
  • Create and execute triggers
  • DDL and DML triggers
Optimization
  • Partitioning
  • Indexing
  • Resource Governor
XML
  • Store and retrieve XML documents
  • XQuery Methods
Security
  • Roles
  • Schemas
Administration
  • Backup
  • Recovery
  • Database Maintenance

Apply for Certification

https://www.vskills.in/certification/Certified-SQL-Server-2008-Programmer