Docstoc

Print To File

Document Sample
Print To File Powered By Docstoc
					Adminstering a Microsoft SQL Server 2000 Database

Duración: 5 Días            Código del Curso: M2072


Temario:
This 5-day instructor led, hands-on course provides students with the knowledge and skills required to install, configure, administer, and
troubleshoot the client-server database management system of Microsoft SQL Server 2000



Dirigido a:
This course is intended for system administrators who wish to learn the skills necessary to install and maintain Microsoft SQL 2000



Objetivos:

 Describe SQL Server architecture                                         Restore databases

 Plan for a SQL Server installation, and then install an instance of      Monitor and optimize SQL Server performance
 SQL Server
                                                                          Transfer and migrate data into databases
 Manage files and databases, including determining resource
 requirements                                                             Maintain the high availability of SQL Server

 Choose a login security method, configure login security, plan           Describe how to replicate data from one SQL Server to another
 and implement database permissions, and describe how to help
 protect SQL Server in an enterprise network

 Perform and automate administrative tasks and create custom
 administrative tools

 Back up databases and implement a backup strategy




Prerequisitos:                                                            Exámenes y certificación
Delegates are required to meet the following prerequisites:               Recommended as preparation for exam(s):

 M2151, Microsoft Windows 2000 Network and Operating System                 70-228, System Administration for Microsoft SQL Server 2000
 Essentials or equivalent knowledge
 M2152, Implementing Microsoft Windows 2000 Professional and
 Server or equivalent knowledge
 An understanding of basic relational database concepts
 M2071, Querying Microsoft SQL Server 2000Familiarity with the
 role of the database administrator




Siguientes cursos recomendados:
The following courses are recommended for further study:

 M2073, Programming a Microsoft SQL Server 2000 Database




M2072                                             www.globalknowledge.es             info.cursos@globalknowledge.es             (34) 91 425 06 60
Contenido:

SQL Server Overview                             Performing Administrative Tasks              Transferring Data
line                                            line                                         line
   What Is SQL Server                              Configuration Tasks                          Introduction to Transferring Data
   SQL Server Integration                          Routine SQL Server Administrative Tasks      Tools for Importing and Exporting Data in
   SQL Server Databases                            Automating Routine Maintenance Tasks         SQL Server
   SQL Server Security                             Creating Alerts                              Introduction to DTS
   Working with SQL Server                         Troubleshooting SQL Server Automation        Transforming Data with DTS
                                                   Automating Multiserver Jobs
Planning to Install SQL Server                                                               Maintaining High Availability
line                                            Backing Up Databases                         line
   Hardware Installation Considerations         line                                            Introduction to Availability
   SQL Server 2000 Editions                        Preventing Data Loss                         Increasing Availability Using Failover
   Software Installation Considerations            Setting and Changing a Database              Clustering
   Methods of Installing SQL Server                Recovery Model                               Standby Servers and Log Shipping
   Verifying the Installation                      SQL Server Backup
   Configuring SQL Server Enterprise Manager       When to Back Up Databases                 Introducing Replication
   Troubleshooting                                 Performing Backups                        line
                                                   Types of Backup Methods                      Introduction to Distributed Data
Managing Database Files                            Planning a Backup Strategy                   Introduction to SQL Server Replication
line                                               Performance Considerations                   SQL Server Replication Agents
   Introduction to Data Structures                                                              SQL Server Replication Types
   Creating Databases                           Restoring Databases                             Physical Replication Models
   Managing Databases                           line
   Placing Database Files and Logs                 SQL Server Recovery Process
   Optimizing the Database Using                   Preparing to Restore a Database
   Hardware-based RAID                             Restoring Backups
   Optimizing the Database Using Filegroups        Restoring Databases from Different
   Optimizing the Database Using Filegroups        Backup Types
   with Hardware-based RAID                        Restoring Damaged System Databases
   Capacity PlanningPerformance
   Considerations                               Monitoring SQL Server for Performance
                                                line
Managing Security                                  Why to Monitor SQL Server
line                                               Performance Monitoring and Tuning
   Implementing an Authentication Mode             Tools for Monitoring SQL Server
   Assigning Logins to Users and Roles             Common Monitoring and Tuning Tasks
   Assigning Permissions to Users and Roles
   Managing Security Within SQL Server
   Managing Application Security
   Managing SQL Server Security in the
   Enterprise




Más información:
Para más información o para reservar tu plaza llámanos al (34) 91 425 06 60
info.cursos@globalknowledge.es
www.globalknowledge.es

Global Knowledge Network Spain, C/ Retama 7, 6ª planta, 28045 Madrid




M2072                                           www.globalknowledge.es           info.cursos@globalknowledge.es            (34) 91 425 06 60

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:7/29/2012
language:English
pages:2