| Title | Description | Duration | Outline |
|---|
|
Introduction To Microsoft SQL Server
|
Provides a hands-on introduction to SQL Server for experienced Programmers.
Covers database design, creation, and basic SQL Statements.
Level: Introduction
|
1 Day
| |
|
Microsoft SQL Server 2008 Integration Services
|
Learn how to use the Integration Services of SQL Server 2008
Level: Introduction
|
3 days
| |
|
Microsoft SQL Server 2008 Reporting Services
|
Learn how to use SQL Server 2008
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2008 and SQL Server 2008
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: Introduction
|
3 days
| |
|
Relational Database Design
|
This course is one common starting point for the entire database curriculum.
The objective of this course is to consider the logical design of relational
databases using a methodology known as semantic data modeling and related
practical techniques.
Level: Introduction
|
2 or 3 Days
| |
|
SSAS Using Microsoft SQL Server 2008
|
Learn how to use the SQL Server 2008 Analysis Services
Level: Introduction
|
2 days
| |
|
Programming Databases with Microsoft SQL Server
|
Describes how Views, Stored Procedures, Triggers, User-Defined Functions,
and Transact-SQL work in SQL Server. Presents maintenance, tuning, and security tools.
Level: Intermediate
|
2 Days
| |
|
SQL Server 2008 for Developers
|
This course shows how to code SQL and PL/SQL statements with and without the
SQL Developer tool. It also covers database design and implementation. It uses
the Oracle database.
Level: Intermediate
|
3 days
| |
|
SQL Server Analysis Tools for Data Analysts
|
Provides an introduction to Data Modeling and the implementation of databases
in SQL Server.
A review of Basic SQL is followed by more advanced topics including temporary tables,
Views, aggregating data, Joins, Cursors, Functions, and Transactions.
Level: Intermediate
|
2 Days
| |
|
SQL Server System and Database Administration
|
Learn all aspects of administering a SQL Server
from installation to configuration,
to maintaining a fast, high performance database server.
Level: Intermediate
|
5 Days
| |
|
Extended Features In Microsoft SQL Server
|
2 Days
| |
|
SQL Server Advanced Transact-SQL
|
Presents advanced Transact-SQL syntax and techniques.
Level: Advanced
|
4 Days
| |
|
SQL Server Performance and Tuning
|
You need to know how to tune queries and stored procedures
for optimal performance.
This course thoroughly covers SQL Server 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
| |
