Implementación y Administración SQL Server 2008

Trackit Entrenamiento y Desarrollo
En Santiago

$650.000
+ IVA
¿O prefieres llamar ahora al centro?
25824... Ver más
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • Curso
  • Santiago
  • 72 horas de clase
Descripción


Dirigido a: Capacitar a los asistentes en la implementación de la plataforma SQLServer 2008, considerando los siguientes aspectos:.

Información importante
Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
Consultar
Santiago
Huerfanos 786 of.910, , 8320193, Santiago, Chile
Ver mapa

Opiniones

Todavía no hay opiniones de este curso

Temario

Module 1 Creating Databases and Database Files

1: Creating Databases 1-3

2: Creating Filegroups

3: Creating Schemas

4: Creating Database Snapshots

  • Practice: Creating Databases and Database Files

Module 2 Creating Data Types and Tables

1: Creating Data Types

2: Creating Tables

3: Creating Partitioned Tables

  • Practice: Creating Data Types and Tables

Module 3 Creating and Tuning Indexes

1: Planning Indexes

2: Creating Indexes

3: Optimizing Indexes

  • Practice: Creating and Optimizing Indexes

Module 4 Implementing Data Integrity by Using Constraints and Triggers

1: Data Integrity Overview

2: Implementing Constraints

3: Implementing Triggers

  • Practice: Implementing Data Integrity by Using Constraints and Triggers

Module 5 Using XML

1: Using the xml Data Type

2: Retrieving XML by Using FOR XML

3: Shredding XML by Using OPENXML

4: Introducing XQuery

5: Creating XML Indexes

6: Implementing XML Schemas

  • Practice: Using XML

Module 6 Implementing Views

1: Introduction to Views

2: Creating and Managing Views

3: Optimizing Performance by Using Views

  • Practice: Implementing Views

Module 7 Implementing Stored Procedures

1: Using Stored Procedures

2: Creating Parameterized Stored Procedures

3: Working with Execution Plans

4: Handling Errors

  • Practice: Implementing Stored Procedures

Module 8 Implementing Functions

1: Creating and Using Functions

2: Working with Functions

3: Controlling Execution Context

  • Practice: Implementing Functions

Module 9 Programming with TRANSAC SQL

1: Implementing conditions with IF...ELSE
2: Looping with WHILE and GOTO
3: Creating code blocks with BEGIN...END
4: Returning data using RETURN
6: Debugging T-SQL in Management Studio

Segunda parte:

Module 1: Installing and Configuring SQL Server 2008

1: Preparing to Install SQL Server 2008

2: Installing SQL Server 2008

3: Configuring a SQL Server 2008 Installation

  • Practice: Installing and Configuring SQL Server 2008

Module 2: Managing Databases and Files

1: Planning Databases

2: Creating Databases

3: Using Policy-Based Management

  • Practice: Managing Databases and Files

Module 3: Disaster Recovery

1: Planning a Database Backup Strategy

2: Backing Up User Databases

  • Practice A: Disaster Recovery - Part A

3: Restoring User Databases

4: Performing Online Restore Operations

5: Recovering Data from Database Snapshots

6: System Databases and Disaster Recovery

  • Practice B: Disaster Recovery - Part B

Module 4: Managing Security

1: Overview of SQL Server Security

2: Protecting the Server Scope

3: Protecting the Database Scope

4: Managing Keys and Certificates

5: Auditing Security

  • Practice: Managing Security

Module 5: Transferring Data

1: Overview of Data Transfer

2: Introduction to SQL Server Integration Services

  • Practice: Transferring Data

Module 6: Automating Administrative Tasks

1: Automating Administrative Tasks in SQL Server 2008

2: Using SQL Server Agent

3: Creating Maintenance Plans

4: Implementing Alerts

5: Managing Multiple Servers

6: Managing SQL Server Agent Security

  • Practice: Automating Administrative Tasks

Module 7: Implementing Replication

1: Overview of Replication

2: Managing Publications and Subscriptions

3: Configuring Replication in Some Common Scenarios

  • Practice: Implementing Replication

Module 8: Maintaining High Availability

1: Introduction to High Availability

2: Implementing Log Shipping

3: Implementing Database Mirroring

4: Implementing Server Clustering

5: Using Distributed High Availability Solutions

Module 9: Monitoring SQL Server

1: Viewing Current Activity

2: Using SQL Server Profiler

3: Monitoring with DDL Triggers

4: Using Event Notifications

  • Practice: Monitoring SQL Server

Module 10: Troubleshooting and Performance Tuning

1: Troubleshooting SQL Server

2: Performance Tuning in SQL Server

3: Using Resource Governor

4: Using Data Collector


Compara este curso con otros similares
Ver más cursos similares