Instructor Led 2005 Transact-sql Training Classes
From Boston University Corporate Education Center
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
... Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course 2779, Implementing a Microsoft SQL Server 2005 Database. Course 2780, Maintaining a Microsoft SQL Server 2005 Database.
Course Outline Unit 1: Building a Monitoring Solution for SQL Server Performance Issues
This unit provides an opportunity for the student to build a monitoring solution that
more...
Implementing a Microsoft SQL Server 2005 Database
... Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course Outline
Module 1: Creating Databases and Database Files
This module explains how to create databases, filegroups, schemas, and database snapshots.
Lessons
Creating Databases. Creating Filegroups. Creating Schemas. Creating Database Snapshots.
Lab 1: Creating a Database
Creating a
more...
Designing the Data Tier for Microsoft SQL Server 2005
... Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course 2779, Implementing a Microsoft SQL Server 2005 Database. Course 2780, Maintaining a Microsoft SQL Server 2005 Database.
Course Outline Session 1: Choosing Data Access Technologies and an Object Model
This session explains how to choose data access technologies and an object model to support an
more...
Designing Microsoft SQL Server 2005 Server-Side Solutions
... Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL. Course 2779, Implementing a Microsoft SQL Server 2005 Database. Course 2780, Maintaining a Microsoft SQL Server 2005 Database.
Course Outline
Module 1: Selecting SQL Server Services to Support Business Needs
This module explains how to translate business requirements into SQL Server services and
more...
