SQL Server Excellent training.in elegant it services

SQL Server Excellent training.in elegant it services

Introduction to SQL Server 2008
Overview on RDBMS and Beyond Relational
Big picture of SQL Server 2008
Components & Services of SQL Server 2008
Roles of production DBA
System Databases
Master, Model, MSDB, Tempdb & Resource
SQL Server 2008 Editions & Capacity Planning
Principal Editions [Enterprise, BI, Standard]
Specialized Editions [Web]
Breadth Editions [Developer, Express]
Hardware Requirements
OS and Software requirements
Pages & Extents
Pages
Extents [Uniform & Mixed]
Managing Extent Allocations
Tracking Free Space
Files and File groups
Database Files
Primary data files
Secondary data files
Log Files
Database File groups [Primary & User-defined]
T-Log Architecture
Transaction Log Logical Architecture
Transaction Log Physical Architecture
Recovery phases [Analysis, Redo & Undo]
Checkpoint Operation
Write-Ahead Transaction Log
Managing T-log
Truncating and shrinking the log file
Managing T-Log issues by using DBCC commands

Module-2 Installing, Upgrading, Configuration, Managing services and Migration
SQL server 2008 Installation
Planning the System/Pre-Requisites
Installing SQL server 2008
Best Practices on Installation
Uninstalling SQL server
Common Installation Issues
Upgrading to SQL server 2008 R2/2008
Upgrading the server by applying service packs
Upgrading the server by applying Hot fixes
In-Place Up gradation from SQL server 2005 to 2008
Pre-Upgrade Checks
Upgrade advisor
Best Practices to follow while upgrading
Managing services
Server/Engine Connectivity issues
Security/Firewall access issues
Starting and Stopping Services through
Configuring SQL Server
Configuring Network Protocols from SQL Server configuration manager
Configuring other settings through SP_Configure
Configuring Memory Settings
Configuring Database Settings
Tempdb configuration
Best Practices on tempdb & Database settings
Migrating SQL Server
Side-By- Side Migration Techniques
Difference between in-place & Side by Side Migration/Upgradation
Advantages/Disadvantages of In-Place to Side-by-Side
Migrating Databases
1 Migration by using Attach and Detach Method
2 Migration by using Back and restore method
3 Migration by using Copy Database Wizard
Migrating Logins [Fixing Orphaned Users]
Creating and migrating linked servers
Migrating Jobs

Thanks&Regards

Elegant IT Services,
#352, 2nd Floor, Aswath Nagar,Varthur main road,
Opp Safal Fresh,Near Railway Fly Over
Maratha halli,Bangalore - 560037.Ph:-9886541264/87