MAESTRIA EN PROGRAMACION Y ADMINISTRACION SQLServer 2008 (60 HORAS)

Objetivo:

Capacitar a los asistentes en la implementación de la plataforma SQLServer 2008, considerando los siguientes aspectos: • Instalación y configuración de la plataforma SQLServer 2008 • Administración de las bases de datos • Respaldos y recuperación • Administración de la seguridad • Recuperación de desastres • Replicación y alta disponibilidad • Procesamiento de XML • Implementación de procedimientos almacenados Esta maestría considera la revisión de conceptos teóricos y la aplicación práctica en cada una de sus unidades.

Tópicos:

Pre requisitos:
 Este programa de entrenamiento tiene los siguientes pre-requisitos:
      ·    Conocimientos básicos del sistema operativo Microsoft Windows
·    Conocimientos de SQL
·    Conceptos generales de los servidores Microsoft
·    Conocimientos generales de bases de datos relacionales
 
PRIMERA PARTE :
 
Objectives
 After completing this module, students will be able to use TRANSACT SQL and:
• Create databases and database files.
• Create data types and tables.
• Use XML-related features in Microsoft SQL Server 2008.
• Plan, create, and optimize indexes.
• Implement data integrity in Microsoft SQL Server 2008 databases by using      constraints.
• Implement data integrity in Microsoft SQL Server 2008 by using triggers.
• Implement views.
• Implement stored procedures.
• Implement functions.
• Implement managed code in the database.
• Manage transactions and locks.
• Use Service Broker to build a messaging-based solution.
 
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:
 
Objectives
After completing this part of master course, students will be able to:
• Install and configure SQL Server 2008.
• Manage database files.
• Backup and restore databases.
• Manage security.
• Transfer data into and out of SQL Server.
• Automate administrative tasks.
• Replicate data between SQL Server instances.
• Maintain high availability.
• Monitor SQL Server.
• Troubleshoot SQL Server.
• Tune SQL Server for Performance.
 
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 
·    Practice: Maintaining High Availability 
 
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
·    Practice: Troubleshooting and Performance Tuning

Track IT
Entrenamiento y capacitación

Huerfanos 786 Oficina 910 Piso 9
Santiago de Chile.
Teléfono: (56)(2)5824530

Envíenos sus consultas y cometarios a:

Asesores de Capacitación:

Asesor Capacitación

Patricia Falcon

Solange Cerda

Consultas

Contacto