Distritos

Maintaining a MSFT SQL Server 2008 Database (LX)

GALILEU
  • Tipo: Curso
  • Método: Presencial
  • Duração: Flexível/Não determinada
  • Preço: A consultar

Maintaining a MSFT SQL Server 2008 Database (LX)

OBJECTIVOS

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

DESTINATÁRIOS

This course is intended for IT Professionals who administer and maintain SQL Server databases.

PRÉ-REQUISITOS

Before attending this course, students must have:
•Basic knowledge of the Microsoft Windows operating system and its core functionality.
•Working knowledge of Transact-SQL.
•Working knowledge of relational databases.
•Some experience with database design.

 

PROGRAMA

Installing and Configuring SQL Server
•Lesson 1: Preparing to Install SQL Server
•Lesson 2: Installing SQL Server
•Lesson 3: Configuring a SQL Server Installation

Managing Databases and Files
•Lesson 1: Planning Databases
•Lesson 2: Creating Databases
•Lesson 3: Using Policy-Based Management

Disaster Recovery
•Lesson 1: Planning a Backup Strategy
•Lesson 2: Backing Up User Databases
•Lesson 3: Restoring User Databases
•Lesson 4: Performing Online Restore Operations
•Lesson 5: Recovering Data from Database Snapshots
•Lesson 6: System Databases and Disaster Recovery

Managing Security
•Lesson 1: Overview of SQL Server Security
•Lesson 2: Protecting the Server Scope
•Lesson 3: Protecting the Database Scope
•Lesson 4: Protecting the Server Scope
•Lesson 5: Auditing Security

Transferring Data
•Lesson 1: Overview of Data Transfer
•Lesson 2: Introduction to SQL Server Integration Services

Automating Administrative Tasks
•Lesson 1: Automating Administrative Tasks in SQL Server
•Lesson 2: Using SQL Server Agent
•Lesson 3: Creating Maintenance Plans
•Lesson 4: Implementing Alerts
•Lesson 5: Managing Multiple Servers
•Lesson 6: Managing SQL Server Agent security

Implementing Replication  
•Lesson 1: Overview of Replication
•Lesson 2: Managing Publications and Subscriptions
•Lesson 3: Configuring Replication in Some Common Scenarios

Maintaining High Availability
•Lesson 1: Introduction to High Availability
•Lesson 2: Implementing Log Shipping
•Lesson 3: Implementing Database Mirroring
•Lesson 4: Implementing Server Clustering
•Lesson 5: Using Distributed High Availability Solutions

Monitoring SQL Server
•Lesson 1: Viewing Current Activity
•Lesson 2: Using SQL Server Profiler
•Lesson 3: Monitoring with DDL Triggers
•Lesson 4: Using Event Notifications

Troubleshooting and Performance Tuning
•Lesson 1: Troubleshooting SQL Server
•Lesson 2: Performance Tuning in SQL Server
•Lesson 3: Using Resource Governor
•Lesson 4: Using Data Collector

O seu pedido de informação foi enviado correctamente. Obrigado.

Peça mais Informações

Locais da Formação

  • Local: GALILEU Lisboa

    Turno: Todo o dia

    Datas: Inicio: 2012-03-19 Fim: 2012-03-23

Cursos em Destaque