Call Us: +91-9000011489

Register for Free Demo

Introduction

  • History of versions
  • Editions of SQL server
  • Installation
  • SSMS environment

SQL server Architecture
Server Configuration

  • SQL server configuration manager
  • Starting and stopping of SQL server
  • Default Port
  • Authentication modes

Database Configuration and Maintenance

  • System Databases & User databases
  • Physical database architecture
    • Physical files
      • Primary, Log files, Secondary Files
    • Pages, Extents
    • Transaction Log
  • Database Options
    • Recovery Options
    • Auto Options
    • Access
    • Parameterization (2008)
  • Collation sequences
  • Maintain database integrity : Constraints
  • Moving of Database
    • Attach and Detach

Designing Indexes

  • Index architecture
  • Designing Indexes
    • Clustered Index
    • Non Clustered index
    • Index Options : Fill Factor
  • Maintaining Indexes
    • Tuning Indexes
    • Fragmentation
    • Index Reorganize and Index Rebuild

Security

  • Surface area configuration
  • Logins, Users
  • Securable and Object permission

Backups and Restore

  • Backups
    • Full, Differential, Transaction Log
  • Restore 
  • Recovery Models
  • Maintaining Transaction Log

Dealing with Flat Files

  • BCP
  • Bulk Insert
  • Open Row set
  • Open data source

Automation

  • SQL server Agent
  • Jobs
  • Schedules
  • Database Mail setup
  • Trouble Shooting database mail

High Availability

  • Replication
    • Snap Shot
    • Transactional
    • Merge
  • Mirroring
  • Log Shipping
  • Clustering

Optimizing Performance

  • Available Tools
  • SQL Profiler
  • DTA
  • DBCC Commands
  • DMV’s
  • System Stored Procedures
  • Index Performance Tuning
  • Query Tuning
    • Execution Plans
    • Table Scan, Index Scan, and Index Seek
  • Locks
  • Transactions concept and Isolation levels