 = "Guaranteed to Run" |
|
ILT - Instructor-Led Training | MLT - Mentor-led Training | Online Classroom - Live Instructor-led Training Online |
|
| Course | Length/Cost | Location(s) | | Register | Time |
|
Course | Length/Cost | Location(s) | | Register | Time |
|
|
2 Days
$900
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2071 Querying Microsoft SQL Server 2000 with Transact-SQL
Learn to create Transact-SQL queries for SQL Server 2005 and 2000 starting with basic SELECT statements, then advancing to grouping, joins, subqueries, data modification, transactions, and full text indexes.
(Prerequisities: Recommended: Access or knowledge of relational database concepts) |
|
|
5 Days
$2250
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2779 Implementing a Microsoft SQL Server 2005 Database
Learn to implement a SQL Server 2005 solution by creating databases, tables, indexes, views, functions, and stored procedures. Also learn to implement .NET managed code in the database and use Service Broker to build a messaging-based solution.
(Prerequisities: 2071 and 2778, recommended 2780 or equivalent knowledge) |
|
|
5 Days
$2250
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2780 Maintaining a Microsoft SQL Server 2005 Database
Learn the core skills of SQL Server administration including installing and configuring SQL Server, managing database files, performing disaster recovery tasks such as backup and restore, transferring data with SQL Server Integration Services, and maintaining high availability with database mirroring and log shipping.
(Prerequisities: 2071; 2273, or 2274 and 2275 or equivalent knowledge) |
|
|
3 Days
$1350
| Seattle (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
Learn to use the Analysis Services administrative and development tools to create an Analysis Services database and an OLAP cube, and manage an Analysis Services solution.
(Prerequisities: 2778 or 2071, 2780 or equivalent knowledge, experience with Windows services and permissions (2274)) |
|
|
3 Days
$1350
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
Learn to develop, deploy, and manage Integration Services packages using Microsoft SQL Server 2005 Integration Services. Develop solutions to extract, transform, and load (ETL) data.
(Prerequisities: 2071, 2780 or equivalent knowledge, basic experience with Windows Server) |
|
|
3 Days
$1350
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Learn to use the Reporting Services administrative and development tools to create and publish reports, and manage a Reporting Services solution.
(Prerequisities: 2071, experience with Windows services and permissions (2274)) |
|
|
3 Days
$1350
| Bellevue (ILT) | | | 8:00AM-4:00PM |
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
Learn new features of SQL Server 2008 including policy-based management, resource governor, data encryption, and new data types, plus significant enhancements to high availability and Business Intelligence capabilities.
(Prerequisities: 2779 and 2780, or experience developing or administering SQL Server 2005 databases.) |
|
|
5 Days
$2250
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (ILT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
6231 Maintaining a Microsoft SQL Server 2008 Database
Learn the core skills of SQL Server administration including installing and configuring SQL Server, managing database files, performing disaster recovery tasks such as backup and restore, transferring data with SQL Server Integration Services, maintaining high availability, managing security, and performing monitoring, tuning, and troubleshooting.
(Prerequisities: 2778; basic knowledge of Windows Server security configuration, performance monitoring tools, storage devices.) |
|
|
5 Days
$2250
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (ILT) | | | 8:00AM-4:00PM |
6232 Implementing a Microsoft SQL Server 2008 Database
Learn to implement a SQL Server 2008 solution by creating databases, tables, views, indexes, constraints, triggers, functions, and stored procedures. Also learn to manage transactions and locks, implement .NET managed code in the database, and use Service Broker.
(Prerequisities: 2778, recommended 6231 or equivalent knowledge) |
|
|
3 Days
$1350
| Seattle (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Learn to use Analysis Services tools to create an Analysis Services database and an OLAP cube, and manage an Analysis Services solution. Create multidimensional analysis solutions, implement dimensions and cubes, deploy and secure an Analysis Services database, and implement a Data Mining solution.
(Prerequisities: 2778, 6231, experience with Windows services and permissions (2274)) |
|
|
3 Days
$1350
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
Learn to develop, deploy, and manage Integration Services packages, implement control flow and data flow, implement logging, debug and implement error handling, and implement checkpoints and transactions.
(Prerequisities: 2778, 6231, experience with Windows services and permissions (2274)) |
|
|
3 Days
$1350
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Learn to use Reporting Services development tools to create and enhance reports, implement reporting for business users, and configure report publishing and subscriptions.
(Prerequisities: 2778, recommended 6231 or 6232 or equivalent knowledge) |
|
|
3 Days
$1350
| Available for private classes, minimum 6 students |
6317 Upgrading Your SQL Server 2000 DBA Skills to SQL Server 2008
Learn the new features of SQL Server 2008. Plan for a SQL Server 2008 installation, upgrade, and migration. Understand new SQL Server data types. Preepare for and maintain availability of SQL Server data even during server downtime, and implement policy-based management.
(Prerequisities: 2072 and 2073, or equivalent experience developing or administering SQL Server 2000 databases.) |
|
|
3 Days
$1350
| Bellevue (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
Bellevue (MLT) | | | 8:00AM-4:00PM |
Seattle (MLT) | | | 8:00AM-4:00PM |
SQL Server 2005 Reporting Services for Developers
Learn to create reports using Report Builder, Visual Studio 2005, and SQL Server 2005 Business Intelligence Studio, including conditional formatting, parameters, matrix (cross-tab), chart reports, interactive sorting, and drill-down capabilities. Also includes Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies.
(Prerequisities: 2071 or equivalent knowledge and familiarity with the Visual Studio development environment.) |
|
|