Career Training >> Information Technology Training >> SQL Server Training >> Microsoft SQL Server 2005 Administration Training Seminar
Course ID: 9463 | Course Duration: 5 Days
Course Dates: 
 
Career Training
 

Microsoft SQL Server 2005 Administration Training Class

Course ID: 9463 		 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

Microsoft SQL Server 2005 Administration Training Seminar

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.

 
     
     
  Course Details  
     
     
  Agenda  
 

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
 
     
     
  Pre-requisites  
  Familiarity with SQL programming, database concepts, Windows desktop navigation and software installation techniques.  
     
  Comments  
  All Canadian events for this course are listed in Canadian dollars and may be subject to Canadian taxes in addition to the listed price.  
     
     
 
On-Site Training Bring this Microsoft SQL Server 2005 Administration training class in-house at your facility. Request More Information Request More Information On Microsoft SQL Server 2005 Administration
 
Career Training
 
 
Career Training
  Microsoft SQL Server 2005 Administration Training Course Dates and Locations  
     
  Course ID: 9463 | Course Duration: 5 Days  
     
  Locations:  
     
  User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info		   Print/Fax
Register
10/20/2008 $2,495.00    Bakersfield, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    Fresno, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    Modesto, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    Oakland, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    Sacramento, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    San Francisco, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/20/2008 $2,495.00    San Jose, CA Register Online For The 10/20/2008 Event Request More Information   Register By Fax For The 10/20/2008 Event
10/27/2008 $2,495.00    Phoenix, AZ Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Tucson, AZ Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Irvine, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Los Angeles, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Riverside, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    San Diego, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Santa Clarita, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Santa Monica, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Temecula, CA Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Albuquerque, NM Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Las Cruces, NM Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    Las Vegas, NV Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
10/27/2008 $2,495.00    El Paso, TX Register Online For The 10/27/2008 Event Request More Information   Register By Fax For The 10/27/2008 Event
11/03/2008 $2,495.00    Little Rock, AR Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Shreveport, LA Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Oklahoma City, OK Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Tulsa, OK Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Austin, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Corpus Christi, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Fort Worth, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Houston, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    Irving, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
11/03/2008 $2,495.00    San Antonio, TX Register Online For The 11/03/2008 Event Request More Information   Register By Fax For The 11/03/2008 Event
 
     
 
On-Site Training Bring this Microsoft SQL Server 2005 Administration training class in-house at your facility. Request More Information Request More Information On Microsoft SQL Server 2005 Administration
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

  
     
  Or, select a category to view more Information Technology courses

  
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

  
     
Career Training
 
   
 
 
Career Training
   
Career Training
 
 
 
 


Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace