Acesso rápido

• Calendário
• Cursos
• Certificações
• Solicite uma visita
• Fale conosco

Central de atendimento:
55 (11) 3521 1111

Module 1: Installing and Configuring SQL Server 2005
This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.
Lessons
• Preparing to Install SQL Server
• Installing SQL Server 2005
• Managing a SQL Server 2005 Installation
Lab 1:
• Installing and Configuring SQL Server 2005
• Performing an Installation
• Managing SQL Server

Module 2: Managing Databases and Files
This module explains how to manage databases and files.
Lessons
• Planning Databases
• Creating Databases
• Managing Databases
Lab 2:
• Managing Databases and Files
• Creating a Database
• Monitoring and Managing Filegroup Usage
• Viewing Database Metadata

Module 3: Disaster Recovery
This module explains how to plan and implement a backup and restore strategy.
Lessons
• Planning a Backup Strategy
• Backing Up User Databases
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Database and Disaster Recovery
Lab 3:
• Disaster Recovery
• Implementing a Backup Strategy
• Restoring and Recovering a Database
• Performing Piecemeal Backup and Restore Operations
• Restoring the master Database

Module 4: Managing Security
This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.
Lessons
• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Managing Keys and Certificates in SQL Server
Lab 4:
• Managing Security
• Creating Logins and Assigning Server-Scope Permissions
• Creating and Managing Users
• Using a Certificate to Protect Data

Module 5: Monitoring SQL Server
This module explains how to monitor SQL Server performance and activity.
Lessons
• Viewing Current Activity
• Using System Monitor
• Using SQL Server Profiler
• Using DDL Triggers
• Using Event Notifications
Lab 5:
• Monitoring SQL Server
• Monitoring SQL Server Performance
• Tracing SQL Server Activity
• Implementing DDL Triggers

Module 6: Transferring Data
This module explains how to transfer and transform data.
Lessons
• Overview of Data Transfer
• Introduction to SQL Server Integration Services
• Using SQL Server Integration Services
• Features of SQL Server Integration Services
Lab 6:
• Transferring Data
• Creating an SSIS Package
• Deploying an SSIS Package
• Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data

Module 7: Automating Administrative Tasks
This module explains how to use the SQL Server Agent to automate administrative tasks.
Lessons
• Automating Administrative Tasks in SQL Server 2005
• Configuring the SQL Server Agent
• Creating Jobs and Operators
• Creating Alerts
• Managing Multiple Servers
• Managing SQL Server Agent Security
Lab 7:
• Automating Administrative Tasks
• Configuring SQL Server Agent
• Creating Operators and Jobs
• Creating Alerts

Module 8: Implementing Replication
This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.
Lessons
• Overview of Replication
• Implementing Replication
• Configuring Replication in Some Common Scenarios
Lab 8:
• Implementing Replication
• Creating a Publication
• Creating a Subscription
• Implementing HTTP Merge Replication

Module 9: Maintaining High Availability
This module explains how to implement high availability technologies with SQL Server 2005.
Lessons
• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Implementing Log Shipping
• Implementing Peer-to-Peer Replication
Lab 9:
• Configuring Database Mirroring to Support Failover
• Implementing Distributed High Availability

Parceiros:

• Ir para NewHorizons.com
• Trabalhe conosco
• Quem somos
• Localização