|
6231: Maintaining a Microsoft SQL Server 2008 Database (Lisboa)
Entidade formadora:
Locais de formação: Galileu Lisboa
Carga horária: 27h.
Preço: contacte-nos para mais informações
Data(s) de início: 15 de Fevereiro
Modalidade: Presencial
|
|
|
Descrição
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.
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
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
