| Title | Description | Duration | Outline |
|---|
|
Introduction To Microsoft SQL Server 2000 (Level 1)
|
Provides a hands-on introduction to SQL Server 2000 for experienced Programmers.
Covers database design, creation, and basic SQL Statements.
Level: Introduction
|
1 Day
| |
|
Programming Databases with Microsoft SQL Server 2000 (Level 2)
|
Describes how Views, Stored Procedures, Triggers, User-Defined Functions,
and Transact-SQL work in SQL Server 2000. Presents maintenance, tuning, and security tools.
Level: Intermediate
|
2 Days
| |
|
SQL Server 2000 System and Database Administration
|
Learn all aspects of administering a SQL Server 2000
from installation to configuration,
to maintaining a fast, high performance database server.
Level: Intermediate
|
5 Days
| |
|
SQL Server 2005 Administration
|
Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Level: Intermediate
|
5 Days
| |
|
SQL Server 2005 Analysis Services
|
Learn to use Microsoft SQL Server 2005 Analysis Services (SSAS)
to design and implement OnLine Analytical Processing (OLAP)
cubes and data mining models to support Business Intelligence (BI)
solutions. Includes concepts, procedures and practices
based on real-world experience giving both the novice and experienced
SQL Server 2005 developer the tools to build data warehousing and
decision support system solutions. Learn about end-user tools
including Microsoft Excel 2003/2007 and Microsoft SQL Server
2005 Reporting Services.
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 Integration Services
|
In this course you will learn about the SQL Server Management Studio
(SSMS) and building Database Maintenance Plans.
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 Reporting Services
|
Learn how to use SQL Server 2005
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2005 and SQL Server 2005
Business Intelligence Studio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, and other formats.
Gain a thorough understanding of Reporting Services security,
report snapshots, subscriptions, and the use of custom assemblies.
Discover how to integrate reports into your ASP.NET and other
applications
Level: Intermediate
|
3 Days
| |
|
SQL Server 2005 T-SQL
|
Learn how to build basic queries using Transact-SQL, the language of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and Visual Basic to build database objects.
Level: Intermediate
|
3 Days
| |
|
Advanced SQL Server 2000 Administration
|
Gain a hands-on, in-depth look at SQL Server 2000
by examining relevant internal data structures
and learning practical troubleshooting techniques.
Diagnose and prevent potentially disastrous situations
and learn how to make optimal use of the features of SQL Server 2000
for normal administrative tasks.
Real-world benefits include learning how to perform mission-critical administrative tasks more efficiently,
improving system performance for end users,
and troubleshooting disaster scenarios for data recovery.
Level: Advanced
|
5 Days
| |
|
Extended Features In Microsoft SQL Server 2000 (Level 3)
|
2 Days
| |
|
SQL Server 2000 Advanced Transact-SQL
|
Presents advanced Transact-SQL syntax and techniques.
Level: Advanced
|
4 Days
| |
|
SQL Server 2000 Performance and Tuning
|
You need to know how to tune queries and stored procedures
for optimal performance.
This course thoroughly covers SQL Server 2000 Query Optimizer.
You will learn techniques to write high performance queries,
allowing the optimizer to use the most efficient query plan,
and diagnose and correct performance problems with already existing queries.
Additionally, you will learn to interpret optimizer statistics and how to use simulated statistics.
Finally, you are presented with a benchmarking tuning methodology.
Level: Advanced
|
5 Days
| |
|
SQL Server 2005 Additional Topics
|
This course examines SQL Server 2005 essential application, support,
and maintenance topics - features you can use for high-availability,
stability, reliability, and scalability of databases, plus
enhancements for processing large amounts of data, handling complex
data structures, implementing asynchronous messaging, and working
with XML.
Level: Advanced
|
3 Days
| |
