Administering a Microsoft SQL Server 2000 Database

In Hammersmith

Price on request

Description

  • Typology

    Course

  • Location

    Hammersmith

  • Duration

    5 Days

Description

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. Describe how to secure SQL Server in an enterprise network. Perform and automate administrative tasks and create custom administrative.
Suitable for: It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Facilities

Location

Starts

Hammersmith (London)
See map
Suite 339/341, Grove House, 27 Hammermsith Grove, w60ne

Starts

On request

To take into account

Delegates should have attended course 2151 Microsoft Windows 2000 Network and Operating System Essentials and course 2152 Implementing Microsoft Windows 2000 Professional and Server or have the equivalent knowledge and skills. Delegates should also have an understanding of relational database concepts and knowledge of basic Transact-SQL syntax.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

Aims and Objectives
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. Describe how to secure SQL Server in an enterprise network. Perform and automate administrative tasks and create custom administrative tools. Monitor and optimise performance. Back up databases and implement a backup strategy.

Target Audiences
It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Prerequisites
Delegates should have attended course 2151 Microsoft Windows 2000 Network and Operating System Essentials and course 2152 Implementing Microsoft Windows 2000 Professional and Server or have the equivalent knowledge and skills. Delegates should also have an understanding of relational database concepts and knowledge of basic Transact-SQL syntax.

Course Content
Module 1: SQL SERVER OVERVIEW
Module 2: INSTALLING SQL SERVER
Module 3: MANAGING DATABASE FILES
Module 4: MANAGING SECURITY
Module 5: PERFORMING ADMINISTRATIVE TASKS
Module 6: BACKING UP DATABASES
Module 7:RESTORING DATABASES
Module 8:MONITORING SQL SERVER FOR PERFORMANCE
Module 9:TRANSFERRING DATA
Module 10: MAINTAINING HIGH AVAILABILITY
Module 11: INTRODUCING REPLICATION

Administering a Microsoft SQL Server 2000 Database

Price on request