Duration: 45 days

Online  Fee: 15,000

Classroom Fee: 6000

Introduction to SQL Server 2005/2008

  • Overview on RDBMS and Beyond Relational
  • System Databases
  • Distribution Database
  • What’s New in SQL Server 2008
  • What is difference between SQL2000,2005 and 2008

Introduction of Computer

  • Installation of SQL Server 2005/2008
  • H/W Requirements
  • S/W Requirements
  • Multiple Instances
  • User Databases
  • SSMS Environment
  • Trouble Shooting Techniques
  • Installation of SQL2000,2005 and 2008

Upgrading to SQL Server 2005/2008

  • Upgrading the server by applying service packs
  • Upgrading the server by Appling hot fixes
  • In-place up gradation from SQL Server 2005 to 2008
  • Upgrade Advisor

Pages & Extents

  • Pages
  • Extents
  • Types of Extents
  • Managing Extent Allocation
  • Tracking Free Space

File & File groups

  • Database files
  • How to rename the database
  • Primary Data files
  • Secondary Data files
  • Log files
  • Database File groups (Primary & User-defined)
  • How to rename the data files and log files.
  • How to change the collation settings.
  • How to change the database from multi user to single_user mode.
  • How to change the database to read-only mode.
  • How to add .ndf(next data file) file while data file disk is full.
  • How to monitoring the Disk spaces and failed connected server

Memory Architecture

  • 32-bit Vs 64-bit Architecture
  • Dynamic Memory Management
  • Effects of min and Max server memory
  • Using AWE

Configuring SQL Server

  • Configuring Network protocols from SQL Server Manager
  • Configuring features by using SQL Server surface area Manager
  • Configuring other settings through sp_configure
  • Dedicated Administrator Connection (DAC)
  • Connecting to DAC

Managing Services

  • Starting and Stopping Services through Configure Manger
  • Net Command
  • Start Up Parameter
  • Starting SQL Server in single user mode
  • Default Parameter and Advanced Parameter

Migrating SQL Server

  • Difference between in-place & Side by Side
  • Migrating by using Back and restore method
  • Migrating logins
  • Migrating Jobs
  • Migrating DTS Packages to SSIS
  • Import & Export

Security, Automation

  • How to create logins
  • How to assign databases for logins
  • How to mapping the logins from Production server to Standby server
  • What is the difference between Server Roles and Database Roles
  • What is Schema
  • How to create Schema and How to assign Schema for Tables
  • How to give column level permissions to particular tables
  • What is Orphan Users
  • How to check the Orphan User Report
  • How to fix the Orphan Users

Automating Administrative tasks

  • About SQL Server Agent
  • Creating Jobs, Alerts and Operators
  • Scheduling the Job
  • Creating Maintenance Plans
  • Working with Job activity monitor

Monitoring SQL Server

  • Monitoring SQL server process by activity monitoring
  • Monitoring Job activities by Job activity monitoring
  • Monitoring SQL Server Error Logs/Windows by log file viewer
  • Creating Maintenance Plans
  • Working with Job activity monitor

High Availability and Replication

Backup & Restore

  • Recovery Models (Simple,Full & Bulk-Logged)
  • How backups works
  • Types of Backups
  • Full Backup
  • Diff Backup
  • T-Log Backup
  • Copy Only
  • Mirror
  • Tail-Log
  • Compressed Backups
  • Restoring Modes (With Recovery, No Recovery, Read Only/Stan by)
  • Performing Restore(Point-in-time recovery)

Log Shipping

  • Log Shipping Architecture
  • Building DRS for Log-Shipping
  • Pre-requisites/log-shipping process
  • Deploying Log Shipping
  • Working with Log Shipping Monitor
  • Log shipping role changing
  • Removing Log Shipping
  • How to run the script when DR server is out of sync

Database Mirroring(HOT Standby)

  • Overview of database mirroring
  • Operating modes in database mirroring
  • Pre-requisites for database mirroring
  • Deploying database mirroring
  • Fail-over from principle to mirror
  • Working with database mirroring monitor
  • Advantages and Disadvantages of database mirroring
  • Database snapshots
  • Using Database snapshots for reporting purpose

Replication

  • Replication overview
  • Replication models (Snapshot/Transnational/Merge)
  • Replication agents
  • Configuration distributor
  • Deploying transaction replication for high availability
  • Working with database mirroring monitor
  • Creating Subscriptions (Homogeneous/Heterogeneous)
  • Monitoring replication by using replication monitor
  • Scripting replication

Clustering SQL Server

  • What is a cluster
  • Types of clustering
  • SQl server clustering concepts
  • Installing and configuring SQL server 2005 clustering

Performance Tuning & Indexing

  • Index architecture
  • How to optimally take advantages of indexes
  • Clustered & Non-clustered Indexes
  • Index fragmentation
  • Index defragmentation options/Update statistics
  • SQL profile
  • DTA (Database Engine Tuning Adviser)

Advantages of SQL DBA

  • How to detach and attach database from one server to another server
  • How to copy database from one server to another server
  • Blocking and Ded locks
  • DR Drills (When primary servery is down then how to make secondary server as primary)
  • How to switch over and switch backup of servers
  • DBCC Commands
  • How to shrinking Primary File, Secondary File and Log file (.ndf, .mdf and .ldf)
  • How to create linked server from SQL server to Oracle server
  • How to generate the script from databases
  • Explain about database sizes and over all databases of project

New features of Harding levels in SQl DBA

  • Server level Harding
  • Database Level Harding

We are providing Free Tool for SQL Basics