SQL DBA Training in Hyderabad

   

 

 

www.unitedglobalsoft.com

 #307, 5th Floor, Liberty Plaza,
opp: Stanza,Himayat Nagar,
Hyderabad - 500029.

Introduction to the sql server:

•  
• 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

1. Complete restoration
2. Point in Time restoration
3. Restoration Options

OLTP and OLAP

Import and Export

SSIS

1. Migrations
2. SSIS Vs DTS Packages
3. Transformations

Up gradation

Replication

• Publisher
• Publication
• Subscriber
• Subscription
• 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

1. Through SSMS
2. 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