SQL DBA CLASSROOM TRAINING IN HYDERABAD

SQL DBA CLASSROOM TRAINING IN HYDERABAD

INTRODUCTION TO THE SQL SERVER:

Microsoft SQL Server is a relational database server, developed by Microsoft. it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network.

DBMS
RDBMS
Data Models
Introduction to SQL SERVER
History of SQL SERVER
Software And Hardware Requirements
IP Configuration, Domain Creation
Client-Server Architecture
IIS Configuration
Installation Process
Services, Checks after installation
Architecture of SQL SERVER 2005
Server startup process
TOOLS IN SQL SERVER 2005

Management Studio(SSMS)
BI Tools(BIDS)
Configuration Tools
Performance Tools(Profiler)

ENABLING REMOTE CONNECTIONS

TCP/IP
Named Pipes
CHANGING PORT NUMBERS

AUTHENTICATIONS

Windows Authentications
SQL Server Authentications.

SECURITIES

Logins
Users
Roles
Password Management
Database Assignment
Privileges
Schema
DATABASES

System Databases
User Databases
DATABASE DESIGNING

Creating Database
Altering Database
FILES AND FILE GROUPS

Data Files
Log Files
Primary File Group

MEMORY ARCHITECTURE

Data Pages
Header and Description
Extents
TRANSACTIONS IN SQL SERVER

Commit
Rollback
Buffer
Checkpoint
RECOVERY MODELS

Full
Bulk Logged
Simple
Non Logged Operations

COMPATIBILITY

2005
2000
7.0
BACKUPS AND PLANNING

Full
Differential
Transaction Log
Files and File Groups
Temporary
Jobs and Schedules
Back up Device
Append and Over write
RESTORATIONS

Complete restoration
Point in Time restoration
Restoration Options
OLTP AND OLAP

IMPORT AND EXPORT

SSIS
Migrations
SSIS Vs DTS Packages
Transformations
UP GRADATION

Replication

Publisher
Publication
Subscriber
Sub
scription
Distributor
Agents
Snap Shot Publication
Transactional Publication
Merge Publication
Replication monitor
LOG SHIPPING

Primary Servers
Secondary Servers
Monitoring Servers
Jobs and Schedules
Blocking of Jobs
High Availability
MIRRORING

Principle Server
Mirror Server
Witness Server
Mirror_Error
Stand by Server
SQL SERVER AGENT

Jobs
Schedules
Alerts
Operators
Error Logs
DATABASE MAIL

MAINTENANCE PLAN

Through SSMS
Through SSIS
Overview of ClusteringPerformance Tuning
PERFMON
SQL LITESPEED
SQL DIAGNOSTIC MANAGE
LOG READER
DBCC
SYSTEM STORED PROCEDURES
REGULAR, WEEKLY AND MONTHLY ACTIVITIES
TROUBLE SHOOTING
INTERVIEW STUFF