MS SQL Server

Microsoft SQL Server could be a on-line database management system developed by Microsoft Corporation. Its primary operate is to store and retrieve information as requested by alternative software package applications, on a similar laptop or alternative computers across the network. There square measure many editions of MS SQL Server for various quite uses.

Module 1: SQL & TSQL

  • Installation of SQL SERVER 2008
  • Configuring of SQL SERVER 2008
  • Hardware requirement for SERVER 2008
  • Software requirement for SERVER 2008
  • Introduction to RDBMS System Database
  • E-R Diagrams
  • Normalization
  • Introduction to TSQL
  • Select Command
  • DDIs
  • DMIs
  • Sub-Queries
  • Working with Tables
  • Correlated Sub queries
  • Transactions
  • Constraints
  • Views
  • Stored Procedures
  • Functions
  • Triggers
  • Cursors
  • Indexes

Module 2: Admin & Architecture

  • Introduction to Admin & Architecture
  • Memory Architecture
  • Storage Architecture
  • Database Creation
  • Database Creation with wizard and & with T-SQL
  • Up grading Database
  • Migration of Database
  • Introduction to Managing Filegroups
  • Datafiles
  • Logfiles
  • Managing Logins & Users
  • System Tables and Views & Linked Servers
  • Using System Stored Procedure and DBCC Commands
  • Import & Export
  • Attach and Detach Databases
  • BCP Command

Module 3: Backup and Recovery, High Availability Configuration, Disaster Recovery Options

  • Introduction to Database Backup
  • Partial Backup
  • Full Backup
  • Defrential Backup
  • Data Encrypyion
  • Managing Database Snapshots
  • Jobs and Alerts
  • Restoration and Recovery ( with all Options)
  • Managing Log Shipping (Wizard and scripting)
  • Managing Database Mirroring (Wizard and scripting)
  • Managing Replication

Module 4: Optimization

  • Introduction to Locking
  • Dead Locks
  • Transaction Isolation Levels
  • Introduction to Tuning
  • SQL Tuning
  • Index tuning
  • Performance Tuning Goals
  • Tuning Methodology
  • SQL Profiler
  • Resourse Governer. Policy Management
  • Introduction to Views
  • Dynamic Management Views
  • Instance Tuning
  • I/O tuning
  • OS Tuning

Quick Enquiry Form