Bangkok--23 Nov--Software Park
Date/ Time: 14-18, 21-22 December 2009
Venue: Training / Seminar Room, 3rd Floor, Software Park Building Cheangwattana, Pakkred Nontaburi
Registration Fee: 17,120 Baht (Incl. Vat7%)
Course Overview
This seven-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.
Course Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases.
Course Contents
Module 1: Installing and Configuring SQL Server the students will be introduced to planning for a SQL Server installation.
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
Module 2: Managing Databases and Files
- Planning Databases
- Creating Databases
- Using Policy-Based Management
Module 3: Disaster Recovery
- Planning a Database Backup Strategy
- Backing Up a User Database
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
Module 4: Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Managing Keys and Certificates
- Auditing Security
Module 5: Transferring Data
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
Module 6: Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server
- Using SQL Server Agent
- Creating Maintenance Plans
- Implementing Alerts
- Managing Multiple Servers
- Managing SQL Server Agent Security
Module 7: Implementing Replication
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
Module 8: Maintaining High Availability
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Server Clustering
- Using Distributed High Availability Solutions
Module 9: Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
- Monitoring with DDL Triggers
- Using Event Notifications
Module 10: Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
- Using Resource Governor
- Using Data Collector
Module 11: Creating Databases and Database Files
- Creating Databases
- Creating Filegroups
- Creating Schemas
- Creating Database Snapshots
Module 12: Creating Data Types and Tables
- Creating Data Types
- Creating Tables
- Creating Partitioned Tables
Module13: Creating and Tuning Indexes
- Planning Indexes
- Creating Indexes
- Optimizing Indexes
Module 14: Implementing Data Integrity by Using Constraints and Triggers
- Data Integrity Overview
- Implementing Constraints
- Implementing Triggers
Module 15: Using XML
- Using the XML Data Type
- Retrieving XML by Using FOR XML
- Shredding XML by Using OPENXML
- Introducing XQuery
- Creating XML Indexes
- Implementing XML Schemas
Module 16: Implementing Views
- Introduction to Views
- Creating and Managing Views
- Optimizing Performance by Using Views
Module 17: Implementing Stored Procedures
- Using Stored Procedures
- Creating Parameterized Stored Procedures
- Working With Execution Plans
- Handling Exceptions
Module 18: Implementing Functions
- Introducing Functions
- Working with Functions
- Controlling Execution Context
Module 19: Implementing Managed Code in the Database
- Introduction to the SQL Server Common Language Runtime
- Importing and Configuring Assemblies
- Creating Managed Database Objects
Course Benefits
- Install and configure SQL Server.
- Create and maintain database backup.
- Create and maintain user accounts, permissions and tasks.
- Automate administrative tasks.
- Create and manage database and their related components.
- Implement data integrity by using constraints, triggers and XML Schemas.
- Create and Maintain indexes.
- Design, create and maintain managed code by using stored procedures and functions.
For more information please contact:
Rungnapa Kheowpimpa
Technology Transfer Department
Software Park Thailand
Tel: 02-583-9992 ext. 1423
Fax: 02-583-2884
E-mail:
[email protected]