Training Course:Microsoft SQL Server 2005 AdministrationSchool/Trainer:2KO International Limited
Cape Town, South Africa
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' 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
...''
Please go to the school's official website for training price and schedule:
http://www.i2ko.com/
Phone:+27 (0)21 418 4874
School Address:
Westcor House, 124 Waterkant Street , corner de Smit Street, Green Point
Cape Town 8005
Jobs & Resumes: Cape Town
Houses & Roommates: Cape Town
Travel Agencies: Cape Town
Search other schools for Microsoft SQL Server 2005 Administration training resources.
Other training courses offered by 2KO International Limited:
Joomla
CompTia Linux+
Microsoft Office
Excel 2003
Word 2003
MCSE 2003
MCSA
MCSD .NET
MCDBA
Microsoft Exchange Server 2003
Microsoft SQL Server 2005 Programming
Oracle 10g DBA OCA
C#
Access 2007
Office 2007
Access 2000 MOS
Excel 2007
PowerPoint 2003
Windows Vista
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.
Tips:
In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal. |
|
| 
