Table of Content
 

 

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