Introduction

• RDBMS
• SQL Server Versions
• SQL Server Components
• New Features
• SQL Server Files

Installation

• System requirements
• Installation Overview
• Selecting Instance
• Authentication Mode
• Service Accounts
• Collation
• Installation Steps
• Upgrading SQL Server
• Built-In Databases

SQL Server Tools

• SQL Server Management Studio
• SQL Server Configuration Manager
• Query Editor
• sqlcmd

Database Design

• RDBMS
• Design Objective
• Design Process
• Keys and Relationships
• E-R Diagram
• Integrity Rules
• Normalization
• Data Types

SQL Operations

• Constraints
• DDL commands
• Queries
• Joins
• EXISTS, INTERSECT and EXCEPT operator
• Subqueries
• Correlated queries
• Table Expressions
• The APPLY Operator
• DML commands

Indexes

• Index Types
• Create, Drop and alter index
• Index Performance
• Index Optimization

Stored Procedures and UDF

• UDF and their types
• Stored procedures and create procedure

Transact-SQL

• Block of Statements
• Data Types
• Variables
• Flow Control
• Error Handling
• Pivoting
• Ranking functions
• Powershell

Concurrency

• Transactions
• Locking
• Isolation Levels
• Row Versioning

Trigger

• Create and execute triggers
• DDL Trigger
• DML Trigger

Optimization

• Partitioning
• Indexing

Performance Tuning

• Degrading Factors
• Monitoring Performance
• SQL Server Profiler
• Database Engine Tuning Advisor
• Resource Governor

XML

• XML Basics
• Store and retrieve XML documents
• XQuery Methods

Security

• Security Basics
• Roles
• Schemas
• Authorization
• Authentication

Administration

• Declarative Management Framework
• Maintenance Plan Wizard
• Backup
• Recovery
• Database Availability

Apply for Certification

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