SQL Server

Accord info Matrix Pvt.Ltd
In Chennai

Rs30001-40000
You can also call the Study Centre
99402... More

Important information

  • Course
  • Chennai
  • 2 hours of class
  • Duration:
    2 Months
  • When:
    Flexible
Description

Accord Soft Offers Best SQL Server 2005 DBA Training in Chennai. We offer Internships in Real-Life Business Applications of our clients. Students are given Practical Training in the below mentioned syllabus. The syllabus can be customized according to individual needs.

COURSE ADVANTAGES

SQL Server 2005 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course providesyou with the skills you need to install SQL Server, create and modify storage structures, manage security, and backup and recover databases.

Important information
Venues

Where and when

Starts Location Timetable
Flexible
Chennai
No: 2, 3rd floor, Above Wangs Kitchen, Opp. to New Life A.G.Church, Little Mount, Anna Salai, Anna Salai, 600015, Tamil Nadu, India
See map

What you'll learn on the course

Online Index Maintenance
Using the Database Tuning Advisor
Rebuilding an Index
Index Fragmentation
Lock Options
Manage Database Permissions

Teachers and trainers (1)

Accord info Matrix Pvt.Ltd
Accord info Matrix Pvt.Ltd
Trainer

Course programme

  • At the end of this course you will be able to:

    • Install Microsoft SQL Server 2005 and the associated bundled tools
    • Understand the many tools that facilitate effective Database Administration
    • Monitor the smooth running of the Database Server
    • Maintain the Database and Indexes
    • Setup and control Database Security
    • Cope effectively with Database Disaster Recovery
    • Implement High Availability and Replication
    • Use relevant TSQL commands
    • Understand the basics of Integration Services
    • Implement SQL Server Full-text search

    SQL Server 2005 Database Administration Training

    SQL SERVER 2005 OVERVIEW
    • Availability and Scalability Features
    • Security Features
    • Data Management Features
    • Administration and Maintenance Features
    • Development Features
    • To enable SQLiMail Testing mail delivery
    INSTALLING SQL SERVER 2005
    • Installing Microsoft SQL Server
    • System Requirements
    • Preparing for a SQL 2005 Installation
    • Installation Checklist
    • Setup Features
    • Using the System Consistency Checker
    • Unattended Installation
    • Installation Sequence
    • Installation Maintenance
    • Upgrading from previous versions of SQL Server
    • To verify the Installation
    • Administrative Tools
    UPGRADING TO SQL SERVER MANAGEMENT STUDIO
    • Management Studio Windows
    • Registered Servers
    • Object Explorer
    • Review Database Objects
    • Modify Database Properties
    • Create Database Scripts
    • The Maintenance Plans Node
    • Solution Explorer
    • Query Editor
    • Template Explorer
    • Dynamic Help
    • SQL Server 2005 Services node
    • SQL Server 2005 Network Configuration node
    • SQL Server 2005 Native Client Configuration node
    • Dedicated Administrative Connection
    • SQL Server Management Studio SQLCMD Mode
    • Using SQL Management Objects
    • SMO Object Model
    MONITORING THE DATABASE SERVER
    • Managing Metadata Views
    • Metadata Storage
    • System Views
    • Information Schema
    • Catalog Views
    • Sys All
    • Dynamic Management Views
    • System Stored Procedures
    DATABASE AND INDEX MAINTENANCE
    • Index Management New Index Features
    • Creating Indexes
    • Online Index Maintenance
    • Lock Options
    • Included Columns in Indexes
    • Partitioned Tables and Indexes
    • XML Index Support
    • Altering an Index
    • Rebuilding an Index
    • Reorganising an Index
    • Disabling an Index Dropping an Index
    • Index Fragmentation
    • Using the Database Tuning Advisor
    SECURING SQL SERVER 2005
    • Implementing Securables
    • New Security Features
    • Principals Securables
    • Permissions
    • Permission Types Managing Logins
    • Managing Users
    • Managing Schemas Schema Definition
    • Using Schemas
    • Managing Execution Context
    • Managing Permissions
    • Manage Server Permissions
    • Manage Server-Scope Securable Permissions
    • Manage Database Permissions
    • Manage Database-Scope Securable Permissions
    • Managing Certificates
    SQL SERVER DISASTER RECOVERY
    • Disaster Recovery
    • SQL 2005 Disaster Recovery Feature
    • Enhanced Features Database Snapshots Creating a Snapshot
    • Common Snapshot Applications
    • Undeleting table rows Undoing a table update
    • Recovering a dropped object
    • Backup and Restore
    • Backup Changes Restore Changes
    • Media Integrity Changes
    • Recovering the MASTER Database
    • Create a mirrored backup
    • Restore from the backup mirror
    • Create a snapshot
    • Restore the snapshot data
    • Automate the creation of daily snapshots
    DATABASE AVAILABILITY
    • SQL 2005 Data Availability
    • Database Mirroring
    • The Witness Server and Automatic Failover
    • Configuring Database Mirroring
    • Transaction Safety Level
    • Operating Modes
    • Mirroring Security
    • Monitoring Mirroring
    • Database States for Database Mirroring
    • Prepare the Servers Configure Mirroring
    • Verify Principal and Mirror Access
    • Execute the Mirror Failover
    • Verify Mirror and Witness Status
    • Terminating the Mirror Session
    REPLICATING INFORMATION
    • Replication Enhancements
    • Stand-alone Replication Monitor
    • HTTP Synchronisation for Merge Replication
    • Subscriber Initialisation
    • Replicating DDL Statements
    • Modified User Interface
    • Replication Management Objects
    • To Configure Publishing and Distribution
    • Configuring Peer-to-Peer Replication
    • Create a Publication
    • Create a Subscription with RMO
    SQL SERVER 2005 INTEGRATION SERVICES
    • Creating the Database Objects
    • Creating a Package Using Business Intelligence Studio
    • Integration Services Project Template
    • OLE DB Command object
    • Column Mappings
    • Adding a Data Viewer
    MONITORING AND PERFORMANCE
    • SQL Server Profiler
    • Optimal Data Storage
    • Diagnostic Tools Query Analyzer
    • Database Engine Tuning Advisor
    • Index Optimisation
    • Federated Database Servers
    • Partitioned Indexes
    • Lock optimsation

Compare this course with other similar courses
See all