Training in SQL Server 2008: Database Administration

Ahana Systems & Solutions (P) Ltd.
In Bangalore

Price on request
You can also call the Study Centre
91802... More
Compare this course with other similar courses
See all

Important information

  • Training
  • Bangalore
  • Duration:
    1 Day
Description

Important information
Venues

Where and when

Starts Location
On request
Bangalore
105/22, Ist floor, 50 Feet Road Hanumanth Nagar, Near Nirmala Store Bus Stop, Banashankari, 560050, Karnataka, India
See map

Course programme

In this program, students will study the following lessons:

Lesson 1: Installation & Configuration of Structured Query Language Server

* Preparation for installing Structured Query Language Server
* Installation of Structured Query Language Server
* Configuration of a Structured Query Language Server Installation

Lesson 2: Management of DB & File systems

* DB Plan
* DB Creation
* Usage of Policy-Based Administration

Lesson 3: Failure Revival

* Scheduling a Support Plan
* Support for User DB
* Restoration of User DB
* Performance of Online Restoration Tasks
* Data Recovery from DB Snapshots
* System DB & Failure Revival

Lesson 4: Security Management

* Summary of Structured Query Language Server Security
* Server Range Protection
* Protection of the DB Range
* Protection of the Server Range
* Inspecting Security

Lesson 5: Transfer of Data

* Summary of Data Transmission
* Preface of Structured Query Language Server Integration Services

Lesson 6: Automatic Managerial Functions

* Automatic Managerial Functions in Structured Query Language Server
* Usage of Structured Query Language Server Mediator
* Preservation Strategy Creation
* Alert Implementation
* Management of Numerous Servers
* Management of S.Q.L. Server Mediator security

Lesson 7: Replication Implementation

* Summary of Replication
* Journals & Payments Management
* Configuration of Replication in Usual Circumstances

Lesson 8: High Accessibility Maintenance

* Summary High Accessibility
* Log Delivery Implementing
* DB Mirroring Implementing
* Server Clustering Implementing
* Circulated High Accessibility Solutions Usage

Lesson 9: Supervising S.Q.L. Server

* Screening of Existing Activity
* S.Q.L. Server Profiler Usage
* Supervision with D.D.L. Triggers
* Event Announcements Usage

Lesson 10: Troubleshooting & Performance Tuning

* Troubleshooting S.Q.L. Server
* Performance Modification in S.Q.L. Server
* Resource Governor Usage
* Information Collector Usage


Compare this course with other similar courses
See all