SQL Server DBA 2008 Training : Course Details

Duration: 50 Hours Price : Contact Sales

SQL SERVER 2005/2008 Administration

An Overview of SQL Server 2005/2008

Available Features and Tools
New Capabilities
SQL Services
Product Licensing
Product Editions

Configuring and Installing

Preparing for Installation
Creating Users for Service Accounts
Choosing Appropriate File Locations
Choosing Instance Names
Installing SQL Server 2008
Choosing Appropriate Features
Specifying Service User Accounts
Choosing Licensing Mode
Choosing Appropriate Collation
Installing Multiple Instances
Upgrading to SQL Server 2008
Service Packs and hot fix
Configuring the Surface Area of SQL Server

Using SQL Server 2005/2008 Management Tools

SQL Server Management Studio
SQL Server Configuration Manager
SQL Server Books Online
SQLCMD

Databases/File Groups

System Databases
Creating and Populating Databases
Describing Data File Structure
Describing Log File Structure and Function
CAPACITY PLANNING
Creating File groups
Configuring File stream Storage
Creating and Using Database Snapshots
Moving a Database to Another SQL Server

Backups and Restore Choosing Appropriate Database

Recovery Model Option
Describing Automatic Recovery
Choosing an Appropriate Backup Strategy
Determining Backup File Contents
Designing a Database Recovery Plan
Using Backup Compression
Use of File groups in a Backup Strategy
Restoring the Master Database
Rebuilding System Databases
Configure Data Compression

Automating Tasks Creating Maintenance Plans

Job Creation and Execution
Creating Schedules for Jobs
Configuring and Using Database Mail

Importing and Exporting Data Using the Import/Export Wizard

Using Integration Services to Import Data

Security SQL Server Security Architecture

Defining Principals and Securables
Using the Security Hierarchy
Creating Logins and Users
Applying Password Policies to SQL Logins
Creating Roles
Granting Permissions
Using SQLCMD to Test Permissions
Creating and Using Certificates
Setting Execution Context
Encrypting Data
Encrypting Databases

SQL SERVER Architecture SQL Server Database Engine Architecture

High Availability
Four Nines
SLA
High Availability Factors

Mirroring

Endpoints creation
Configuring Mirroring
Mirroring Modes

Log Shipping

Setup the Log Shipping
Disaster Recovery Examples
Troubleshooting
Out of Sync

Replication

What is SQL Replication?
SQL Server Replication Concepts
Types of Replication
SQL Server Roles
Pieces of SQL Replication Model
Players of SQL Replication Model
Creating Replication Admin Account
Creating Agent Accounts
Adding Replication Accounts to Database
Creating Publication
Creating Push Subscription

SQL Server Failover Clustering

Windows Clustering
Clustering Types
MSCS
Installing SQL SERVER Clustering
Troubleshooting

Performance and Tuning - Using the Windows Performance Tool to Detect the Cause

Bottleneck
Using SQL Server Profiler
Using Dynamic Management Functions
Interpreting Management Studio
Using Activity Monitor
Rebuilding and Reorganizing Indexes
Using the Database Engine Tuning Advisor
Generating and Interpreting Query Plans

Configuring the Resource Governor

Shopping Cart Software

Quick Contact