SQL Training – Bellevue, or at your location.
Seminar - Increasing Security and Reliability in SQL Server 2008
Microsoft SQL Server 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization.
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Learn the essentials of SQL language to query data 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.
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008
Upgrade your SQL Server 2005 skills to SQL Server 2008. Learn new features including policy-based management, resource governor, data encryption, and new data types. Also learn about significant enhancements to high availability and Business Intelligence capabilities.
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.
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.
6317 Upgrading Your SQL Server 2000 DBA Skills to SQL Server 2008 DBA Skills
Upgrade your SQL Server 2000 database administration (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, prepare for and maintain availability of SQL Server data even through server downtime, and implement policy-based management.
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
Learn to use the Reporting Services development tools to create and enhance reports, implement reporting for business users, configure report publishing and subscriptions,and use the Reporting Services management and administrative tools.
2071 Custom: Querying Microsoft SQL Server 2005 and 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.
8778 Custom: Writing Advanced Queries Using Microsoft SQL Server 2005
Learn new SQL 2005 enhancements including advanced query techniques and new XML functionality.
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.
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.
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.
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.
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 how to create reports with conditional formatting, parameters, matrix (cross-tab) and chart reports, interactive sorting, and drill-down capabilities. Also gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies.
2071 Custom: Querying Microsoft SQL Server 2005 and 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.
2072 Administering a Microsoft SQL Server 2000 Database
Install, configure, administer and troubleshoot SQL Server 2000 relational database management system.
2073 Programming a Microsoft SQL Server 2000 Database
Implement a database solution with SQL Server 2000 relational database management system.