Implementación y Administración SQL Server 2008
Curso
En Santiago
Descripción
-
Tipología
Curso
-
Lugar
Santiago
-
Horas lectivas
72h
Dirigido a: Capacitar a los asistentes en la implementación de la plataforma SQLServer 2008, considerando los siguientes aspectos:.
Sedes y fechas disponibles
Ubicación
comienzo
comienzo
Opiniones
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
Implementación y Administración SQL Server 2008