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
¿Quieres hablar con un Asesor sobre este curso?
Usuarios que tenian interés por este curso también también se interesaron por...
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

Logros de este Centro


Usuarios que tenian interés por este curso también también se interesaron por...
Ver más cursos similares