2072 Administering a SQL Server 2000 Db (3-10 Pm)

Curso

En Tijuana, Baja California

$ 7,950 IVA inc.

Descripción

  • Tipología

    Curso

  • Lugar

    Tijuana, baja california

  • Horas lectivas

    40h

Descripción

Objetivo del curso: 2072 Administering a Microsoft SQL 2000 Server Database. Este curso le brinda el conocimiento y; así habilidades necesarias para instalar, configurar, administrar y dar soporte al manejar las bases de datos cliente-servidor de Microsoft® SQL Server(tm) 2000. Destinatarios del curso: This course provides you with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft® SQL Server? 2000.

Instalaciones y fechas

Ubicación

Inicio

Tijuana, Baja California (Baja California)
Blvd. Sanchez Taboada # 10116-105 Plaza Ejecutiva Del Rio, 22320

Inicio

Consultar

A tener en cuenta

2071 Querying Microsoft SQL Server 2000 with Transact-SQL 2151 Microsoft Windows 2000 Network and Operating System Essentials 2152B Implementing Mic

Preguntas & Respuestas

Plantea tus dudas y otros usuarios podrán responderte

¿Quién quieres que te responda?

Sólo publicaremos tu nombre y pregunta

Programa académico

Course Outline: 2072 Administering a Microsoft SQL Server 2000 Database

Learning Method: Instructor-led Classroom Learning

Duration: 5.00 Day(s)

Overview:
This 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.


Pre-requisite(s): 2071 Querying Microsoft SQL Server 2000 with Transact-SQL
2151 Microsoft Windows 2000 Network and Operating System Essentials
2152B Implementing Microsoft Windows 2000 Professional and Server

Outline: Top

Lesson 1: SQL Server Overview

What Is SQL Server
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server


Top

Lesson 2: Planning to Install SQL Server

Hardware Installation Considerations
SQL Server 2000 Editions
Software Installation Considerations
Methods of Installing SQL Server
Verifying the Installation
Configuring SQL Server Enterprise Manager
Troubleshooting


Lesson 3: Managing Database Files

Introduction to Data Structures
Creating Databases
Managing Databases
Placing Database Files and Logs
Optimizing the Database Using Hardware-based RAID
Optimizing the Database Using Filegroups
Optimizing the Database Using Filegroups with Hardware-based RAID
Capacity Planning
Performance Considerations


Lesson 4: Managing Security

Implementing an Authentication Mode
Assigning Logins to Users and Roles
Assigning Permissions to Users and Roles
Managing Security Within SQL Server
Managing Application Security
Managing SQL Server Security in the Enterprise


Lesson 5: Performing Administrative Tasks

Configuration Tasks
Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks
Creating Alerts
Troubleshooting SQL Server Automation
Automating Multiserver Jobs


Top

Lesson 6: Backing Up Databases

Preventing Data Loss
Setting and Changing a Database Recovery Model
SQL Server Backup
When to Back Up Databases
Performing Backups
Types of Backup Methods
Planning a Backup Strategy
Performance Considerations


Lesson 7: Restoring Databases

SQL Server Recovery Process
Preparing to Restore a Database
Restoring Backups
Restoring Databases from Different Backup Types
Restoring Damaged System Databases


Lesson 8: Monitoring SQL Server for Performance

Why to Monitor SQL Server
Performance Monitoring and Tuning
Tools for Monitoring SQL Server
Common Monitoring and Tuning Tasks


Lesson 9: Transferring Data

Introduction to Transferring Data
Tools for Importing and Exporting Data in SQL Server
Introduction to DTS
Transforming Data with DTS


Top

Lesson 10: Maintaining High Availability

Introduction to Availability
Increasing Availability Using Failover Clustering
Standby Servers and Log Shipping


Lesson 11: Introducing Replication

Introduction to Distributed Data
Introduction to SQL Server Replication
SQL Server Replication Agents
SQL Server Replication Types
Physical Replication Models


Llama al centro

¿Necesitas un coach de formación?

Te ayudará a comparar y elegir el mejor curso para ti, y podrás financiarlo en cómodas cuotas mensuales.

2072 Administering a SQL Server 2000 Db (3-10 Pm)

$ 7,950 IVA inc.