 = "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 |
|
|
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 |
2778 Writing Queries Using Microsoft SQL Server 2008/2005 Transact-SQL
Learn the essentials of SQL language to query and filter data, join multiple tables, work with subqueries, and perform data modifications. Also learn more advanced SQL to query XML and full-text indexes, use stored procedures and views, and write complex queries.
(Prerequisities: Understand relational databases and the concept of data normalization) |
|
|
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.) |
|
|
1½ Hours
Free
| Bellevue (ILT) | | | 3:00PM-4:30PM |
Bellevue (ILT) | | | 10:30AM-12:0 |
Bellevue (ILT) | | | 10:00AM-11:30AM |
Seminar - SQL Server 2008 - Improving Database Security and Reliability
Learn how Microsoft SQL Server 2008 provides a secure, highly-available, scalable data platform for mission critical applications, reduces application development costs, and enables organization-wide Business Intelligence. Free attendance is limited to three people per company. |
|
|