home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Maintaining a SQL Server 2005 database

Intended for

SQL Server administrators.

Background

Before attending this course, students must have competency in the following areas:

Training method

Lecturing with labs.

Course leader

RealDolmen.

Duration

3 days.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of SQL Server 2005.

After completing this course, students will be able to:

  • Describe SQL Server architecture.
  • Plan for a SQL Server installation, and then install an instance of SQL Server.
  • Manage files and databases, including determining resource requirements.
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to secure SQL Server in an enterprise network.
  • Perform and automate administrative tasks and create custom administrative tools.
  • Back up databases and restore databases.
  • Monitor and optimize SQL Server performance.
  • Transfer and migrate data into databases.
  • Maintain the high availability of SQL Server.
  • Describe how to replicate data from one SQL Server to another.

Main topics

  • SQL Server overview organisation requirements
  • Planning to install SQL Server
  • Managing database files
  • Managing security
  • Performing administrative tasks
  • Backing up databases
  • Restoring databases
  • Monitoring SQL Server for performance
  • Transferring data
  • Maintaining high availability
  • Introducing replication