SQL DBA TRAINING
ENROLL NOW

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

 

If you want to know more about SQL DBA TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com

ENROLL NOW