+91-80999 02123201-710-8393

SQL DBA Online Training

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

  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

Address

#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings

Testimonials

The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment

Keerthi
Hyderabad.

I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment


Mushtak Shaik
Hyderabad.