Microsoft SQL Server 2005 Administration

Hands On Technology Transfer, Inc.
Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha, etc., United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Students Will Learn:Database Engine Management
Reporting Services
Integration Services
Notification Services
CLR Integration
XML Integration
Analysis Services
Replication

Description: 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); use SQL Server Notification Services (SSNS) to push data updates to subscribing users; 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; 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 discusses the programmability features at a high level.

Students who are new to database concepts and fundamental SQL programming should attend the 3-day course Relational Database Design prior to this course.

Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT’s 3-day SQL Programming course, or equivalent knowledge, is helpful but not required.

Microsoft SQL Server 2005 Administration Course Overview:
An Overview of SQL Server 2005
New Features
Database Roles
Client Tools
Installing SQL Server 2005
Preparing For Installation
Setup User Interface
Installing Express Edition
Configuring an New Instance

SQL Server Database Engine
Managing Services
Managing Servers
Database Projects
Database Objects
SQL Server Integration Services (SSIS)
What Happened To DTS?
What is ETL?
Integration Services Projects
SSIS Objects
Expressions

SQL Server Analysis Services (SSAS)
OLAP vs. OLTP
Data Warehousing
Data Mining
Architecture
Analysis Services Projects
Analysis Services Scripting Language (ASSL)
XML for Analysis (XMLA)
Predictive Mining Model Language (PMML)
Data Mining Extensions (DMX)
Multidimensional Expression Language (MDX)
SQL Server Replication
Overview
Replication Types
Agents
Implementing
Administering
Enhancements

SQL Server Reporting Services (SSRS)
Overview
Creating, Managing, and Delivering
Administering
SQL Server Full-Text Search (SSFTS)
Overview
Architecture
Writing Queries
Administering

SQL Server Notification Services (SSNS)
Overview
Subscription Management
Event Collection
Subscription Processing
Formatting and Delivery
SQL Server Service Broker
Overview
Conversations
Message Ordering and Coordination
Transactional Asynchronous Programming
Loosely Coupled Applications
Components
Administering

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
Unicode Data
Date and Time Issues
Collations
International SQL
Integration Services
Analysis Services
Reports
Notifications
Service Broker
Full-Text Searches

Working with XML
Data Type
Indexes
Schema Collections
For XML
OpenXML
Native XML Web Services
Data Availability
Disaster Recovery
High Availability
Backup
Restore

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
Transact-SQL
CLR Integration Overview
Stored Procedures
User-Defined Functions
User-Defined Types
DML Triggers
DDL Triggers
SQL Management Objects (SMO)
Integration Services
Replication Management Objects (RMO)
Reports
Notifications

...''

Phone:1-800-413-0939

School Address:

Hands On Technology Transfer, Inc.
14 Fletcher Street
One Village Square, Suite 8
Chelmsford, MA 01824 USA


Jobs & Resumes: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha
Houses & Roommates: Boise, Cincinnati, Cleveland, Kansas City, Memphis, Milwaukee, Minneapolis, Oklahoma City, Omaha

C# 2.0 Programming for Windows Applications
Windows Applications Programming for Experienced C# Programmers
Visual Basic.NET 2.0 Programming for Windows Applications
Windows Applications Programming for Experienced Visual Basic.NET Programmers
ASP.NET 2.0 Programming for Experienced C# Programmers
ASP.NET 2.0 Programming for Experienced Visual Basic.NET Programmers
Advanced C# Programming with the .NET 2.0 Framework
Advanced Visual Basic.NET Programming with the .NET 2.0 Framework
SQL Programming
Relational Database Design Concepts
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Reporting Services
SQL Server 2005 Business Intelligence Application Development
SQL Server 2005 Business Intelligence: Integration Services and Analysis Services
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory and Security Design
MCSE 2003 Certification
MCSA 2003
MCDBA

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.