SQL SERVER DATABASE ADMINISTRATION

Training

In Pune

Price on request

Description

  • Type

    Training

  • Location

    Pune

  • Duration

    1 Week

Facilities

Location

Start date

Pune (Mahārāshtra)
See map
25, Baner Road, Balewadi, 411045

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Background
The goal of this course is to cover the SQL 2005 Database architecture and internal mechanisms such that the participant is able to perform basic Data Base Administration tasks such as database creation, start-up and shutdown, backup, recovery and database management.

The course also covers Microsoft SQL Database networking basics and the utility programs

Objectives:
The primary objective of this SQL Server DBA training is to provide each participant with the knowledge and secrets to be successful as a practicing SQL Server DBA. The participant will gain confidence in their SQL Server DBA knowledge and learn the tricks and traps of the SQL Server.

After completion of program the participant will successfully install and configure a working SQL Server database, create tablespaces and files, manage security and user access, and create tables and write SQL Server queries
The History of SQL Server and relational databases
· Relational database history
· The evolution of SQL Server
· SQL Server and ANSI standards
Installing and configuring SQL Server
· Pre-installation steps
· Installing SQL Server
· Configuring the run-time SQL Server system
· Patching SQL Server - Service packs

SQL Server data storage management
· SQL Server file management architecture
· Creating database files
· Creating SQL Server log files
· Using SQL Server file groups

Managing data with the DTS utility
· Using DTS to export and import SQL Server table data
SQL Server Security management
· Windows security management for the server
· Windows authentication mode
· SQL Server rights and role management

SQL Server Backup & Recovery
· Overview of SQL Server backup & recovery
· Incremental backups
· Restoring a SQL Server database
· Standby database overview
· Shipping SQL Server log files to standby databases

SQL Server database Replication
· Microsoft replication architectures
· Creating a replication topology
· Configuring SQL Server replication

SQL Server Job scheduling
· Common database scheduled jobs
· Configuring SQLMail
· Setting SQL Server and server alert thresholds
· Creating customized error conditions
· Scheduling multi-step job streams
Performance Tuning for the SQL Server DBA
· SQL Server monitoring for performance
· SQL Server startup parameter tuning
· T-SQL tuning
· SQL tuning for SQL Server
· Diagnosing storage and system problems
· Diagnosing session and O/S issues

SQL SERVER DATABASE ADMINISTRATION

Price on request