Custom Search
Home > Computer > Hands On Technology Transfer, Inc. > Hands On Training Classes > Microsoft SQL Server 2005 Administration
Provided by: Hands On Technology Transfer, Inc.

Microsoft SQL Server 2005 Administration

Databases and SQL

 Hands On Technology Transfer, Inc.
Training Provided by Hands On Technology Transfer, Inc. This class consists of five days of training that focus on the new features available in SQL Server 2005. You will learn how to install SQL Server 2005; use the SQL Server 2005 client tools to administer databases and create database applications; administer the database engine; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Replication to synchronize data between databases; use SQL Server Reporting Services (SSRS) to create dynamic database reports; perform intelligent and complex queries using SQL Server Full-Text Search (SSFTS); and use SQL Server Service Broker to establish asynchronous communications between database applications. You will also learn how to create international database applications; integrate XML with a database; monitor and improve database and server performance; backup and restore; and optimize data availability for an environment. This course also includes an introduction to using SQL Server Analysis Services (SSAS) to create and manage data warehouse and implement data mining and discusses in detail the new security concepts available in SQL Server 2005. There are several new programmability features available in SQL Server 2005 including integration of the database engine and the .NET Common Language Runtime (CLR). This course focuses on administration issues and discusses the programmability features at a high level. Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques.
This is primarily ilt training
computer labComputer Lab Work
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in Chelmsford, MA,
Contact Hands On Technology Transfer, Inc. for more information
Course Level:basic
Duration:5 days
Training Presented in:English
Click here for more information or to take this course
Microsoft SQL Server 2005 Administration Microsoft SQL Server 2005 Administration Course Overview:

An Overview of SQL Server 2005
  • New Features
    • SQL Server Reporting Services (SSRS)
    • SQL Server Analysis Services (SSAS)
    • SQL Server Integration Services (SSIS)
  • Database Roles
  • Client Tools

Installing SQL Server 2005

  • Preparing For Installation
  • User Interface Setup
  • Installing Express Edition
  • Configuring an New Instance
SQL Server Database Engine
  • Managing Services
  • Managing Servers
  • Database Projects
  • Database Objects

SQL Server 2005 Tools
  • Configuration Utilities
  • SQL Server Management Studio
  • Using the Query Editor
  • Books Online

SQL Server Replication

  • Types of Replication
  • Replication Agents
  • Security and Monitoring
  • Backup and Restore Considerations
  • Replication Wizards and Tools

SQL Server Service Broker
  • Conversations
  • Message Ordering and Coordination
  • Transactional Asynchronous Programming
  • Loosely Coupled Applications
  • Components
  • Administering
SQL Server Maintenance
  • Setting Up Database Mail
  • SQL Server Agent
  • Creating Operators
  • Creating Jobs
  • Creating Alerts
  • Proxies
  • Working with Tasks

Creating Databases
  • Creating Databases
  • Creating and Modifying Tables
  • Indexes, Constraints, Scripts
  • Populating Databases
Controlling Security
  • Overview
  • Catalog Views
  • Security Functions
  • Cryptographic Functions
  • CLR Integration
  • Native XML Web Services
  • Integration Services
  • Analysis Services
  • Replication
  • Reports
  • Notifications
  • Service Broker

International Databases
  • Database Internationalization Overview
  • Unicode Data
  • Date and Time Issues
  • Collations
  • International SQL
  • Integration Services
  • Analysis Services
  • Reports
  • Notifications
  • Service Broker
Working with XML
  • XML Data Type
  • Indexes
  • Schema Collections
  • Generating XML with the “For XML” Clause
  • OpenXML
  • Native XML Web Services

Assuring Data Availability
  • Disaster Recovery
  • Recovery Models
  • High Availability Techniques
  • Backup
  • Restore
  • RAID Arrays
  • Database Mirroring
Monitoring and Performance
  • Windows Performance Monitor
  • SQL Server Profiler
  • Database Engine Tuning Advisor (DTA)
  • Federated Database Servers
  • Partitioned Tables
  • Partitioned Indexes
  • Query Performance Issues
  • Transactions and Locks
  • Best Practices for Native XML Web Services

Programming SQL Server 2005 Scripts
  • Transact-SQL Capabilities
  • CLR Integration Overview
  • Creating and Modifying Stored Procedures
  • User-Defined Functions
  • User-Defined Types
  • DML Triggers
  • DDL Triggers
  • Integration Services
  • Replication Management Objects (RMO)
  • Reports
  • Notifications
SQL Management Objects (SMO) Overview
  • Table-Related SMOs
  • Index and ForeignKey SMOs
  • Stored Procedure and View SMOs

Full-Text Search Architecture
  • Full-Text Search Capabilities
  • Creating a Full-Text Catalog
  • Populating Full-Text Indexes
  • Performing Full-Text Searches
    • FREETEXT
    • FREETEXTTABLE
    • CONTAINS
    • CONTAINSTABLE
About The Training Provider: Hands On Technology Transfer, Inc.
Hands On Technology Transfer, Inc. - Instructor-led IT training in more than 75 cities throughout the United States, Canada and the United Kingdom. Topics include .NET, SQL, Java, UNIX/ Linux, HTML, PHP, Windows Administration and more. Travel packages and on site training are also available to get students the training they need, when and where they want it.
Click here for more information or to take this course
Home > Computer > Hands On Technology Transfer, Inc. > Hands On Training Classes > Microsoft SQL Server 2005 Administration
tcw11-gfc-v396M-11/13/09-12:51:12-()[B]-[A]-[A] -03:35:06