Posted: 18 days ago

SQL Server Excellent elegant it services

Shortlist Click to Shortlist
+91 98865 41264
+91-4152 3314

Send Email Response

  • Course: Banking and Finance
  • Locality: Kasavanahalli
  • You are: Offering professional course
Description for "SQL Server Excellent elegant it services"

SQL Server Excellent 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
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


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

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Banking and Finance course near by Kasavanahalli :
Get similar ads More details
Course - Banking And Finance | Locality - Hosa Road
Posted: 6 days ago   |   Professional courses - Bangalore
Course - Banking And Finance | Locality - Bellandur
Posted: 1 month ago   |   Professional courses - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at