Online Sql Server 2005 eLearning
Sql Server 2005 Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Installing SQL Server 2005

Installing SQL Server 2005 Microsoft
To install SQL Server 2005 and upgrade to SQL Server 2005 from previous versions
more...
Installing SQL Server 2005
Configuring SQL Server 2005

Configuring SQL Server 2005 Microsoft
To configure a SQL Server instance and create a database, configure logins, users, and schemas for a database, and set up a linked server configuration
more...
Creating and Implementing Database Objects in SQL Server 2005

Creating and Implementing Database Objects in SQL Server 2005 Microsoft
To create and implement key database objects in SQL Server 2005
more...
Retrieving Data and Running Queries in SQL Server 2005

Retrieving Data and Running Queries in SQL Server 2005 Microsoft
To perform relational data and XML data management tasks, and work with assemblies and transactions in SQL Server 2005
more...
SQL Server 2005 Messaging and Querying Tools

SQL Server 2005 Messaging and Querying Tools Microsoft
To implement Service Broker components and use full-text search in SQL Server 2005
more...
Managing and Maintaining SQL Server 2005 Databases

Managing and Maintaining SQL Server 2005 Databases Microsoft
To manage and maintain SQL Server 2005 databases
more...
SQL Server 2005 Database Performance and Optimization

SQL Server 2005 Database Performance and Optimization Microsoft
To monitor and optimize database performance using SQL Server utilities
more...
Monitoring and Diagnosing Database Problems in SQL Server 2005

Monitoring and Diagnosing Database Problems in SQL Server 2005 Microsoft
To monitor and resolve database blocks, and connect to the server using a dedicated administrator connection (DAC)
more...
SQL Server 2005 High Availability and Disaster Recovery

SQL Server 2005 High Availability and Disaster Recovery Microsoft
To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005
more...
SQL Server 2005 Backup and Restores

SQL Server 2005 Backup and Restores Microsoft
To back up and restore a database in SQL Server 2005
more...
Designing a Database Server Infrastructure for SQL Server 2005

Designing a Database Server Infrastructure for SQL Server 2005 Microsoft
To specify the appropriate requirements for implementing SQL Server 2005, identify suitable instance and physical storage strategies, and determine the appropriate way to design a database consolidation plan, given a SQL Server scenario
more...
Designing an Application Solution for SQL Server 2005

Designing an Application Solution for SQL Server 2005 Microsoft
recognize how to design and build a database model and a physical database, and how to secure it
more...
Designing Database Objects

Designing Database Objects Microsoft
recognize how to design database objects according to your requirements
more...
Programming with SQL Server 2005

Programming with SQL Server 2005 Microsoft
recognize how to implement SQL Server 2005 programming features to work with database data
more...
Using XML

Using XML Microsoft
recognize how to use, implement, retrieve and manipulate XML data in SQL Server 2005 using XQuery language
more...
CLR Integration

CLR Integration Microsoft
recognize how to use CLR integration in SQL Server 2005 to create, implement and work with data, and how to execute .NET assemblies to achieve this
more...
Database Testing and Code Management

Database Testing and Code Management Microsoft
recognize how to implement version control, unit testing and performance benchmarking and improvements in SQL Server 2005
more...
Developing Applications that Use SQL Server Support Services

Developing Applications that Use SQL Server Support Services Microsoft
recognize how to develop and deploy SQL Service Support solutions with Notification Services and Service Broker
more...
Developing Applications that Use SQL Server Business Intelligence Services

Developing Applications that Use SQL Server Business Intelligence Services Microsoft
recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements
more...
Database Deployment and Data Distribution

Database Deployment and Data Distribution Microsoft
recognize how to design, deploy and utilize database deployment and database distribution solutions
more...
Designing Access to SQL Server Data

Designing Access to SQL Server Data Microsoft
recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data
more...
Designing Efficient Application Access

Designing Efficient Application Access Microsoft
recognize how to efficiently utilize client libraries for database access using automation management objects, server Network Interface and MARS for queries and row management
more...
Designing Queries in SQL 2005

Designing Queries in SQL 2005 Microsoft
recognize how to design and execute queries in SQL Server 2005, utilizing XQuery and the XML Data Modification Language
more...
Designing a SQL Server 2005 Cursor Strategy

Designing a SQL Server 2005 Cursor Strategy Microsoft
recognize how to design and implement an appropriate cursor strategy in SQL Server 2005
more...
Designing a SQL Server 2005 Transaction Strategy

Designing a SQL Server 2005 Transaction Strategy Microsoft
recognize the different levels of isolation and granularity to manage concurrency and execute a transaction strategy in SQL Server 2005
more...
SQL Server 2005 Error Handling Techniques

SQL Server 2005 Error Handling Techniques Microsoft
recognize how to design code for validating input, for error handling and for user-defined messages in SQL Server 2005
more...
Optimizing Query Performance and Index Strategies

Optimizing Query Performance and Index Strategies Microsoft
recognize how to optimize query performance and indexing strategies in SQL Server 2005
more...
Optimizing Storage in SQL Server 2005

Optimizing Storage in SQL Server 2005 Microsoft
recognize how to optimize database storage and SQL Server performance
more...
Scaling Applications and Resolving Performance Issues

Scaling Applications and Resolving Performance Issues Microsoft
recognize how to scale out applications to enterprise level and troubleshoot and identify performance issues that result
more...
Designing Security for a Database Server Infrastructure for SQL Server 2005

Designing Security for a Database Server Infrastructure for SQL Server 2005 Microsoft
To identify business security requirements, select the appropriate authentication method, and specify a security design for different levels of the SQL Server environment
more...
Designing the Physical Database for SQL Server 2005

Designing the Physical Database for SQL Server 2005 Microsoft
To identify physical database requirements, select the appropriate strategy for designing database objects, and determine suitable database naming standards and change control procedures
more...
Designing a Database Server High Availability Solution for SQL Server 2005

Designing a Database Server High Availability Solution for SQL Server 2005 Microsoft
To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution
more...
Designing a Database Failover Solution for SQL Server 2005

Designing a Database Failover Solution for SQL Server 2005 Microsoft
To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a database
more...
Designing a Database Server Data Recovery Solution for SQL Server 2005

Designing a Database Server Data Recovery Solution for SQL Server 2005 Microsoft
To select the appropriate data backup and recovery solution for a SQL Server 2005 database
more...
Optimizing SQL Server 2005 Performance

Optimizing SQL Server 2005 Performance Microsoft
To identify ways of optimizing the performance of SQL Server 2005
more...
Optimizing a Database Data Recovery Plan for SQL Server 2005

Optimizing a Database Data Recovery Plan for SQL Server 2005 Microsoft
To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario
more...
Monitoring and Maintaining a Database in SQL Server 2005

Monitoring and Maintaining a Database in SQL Server 2005 Microsoft
To monitor a database, automate database maintenance tasks, and configure reporting services for SQL Server 2005
more...
Managing Database Data in a SQL Server 2005 Environment

Managing Database Data in a SQL Server 2005 Environment Microsoft
To recognize how to create and deploy SSIS packages, and enforce data quality and data integrity in a SQL Server 2005 database
more...
Managing Data Between Servers and Databases

Managing Data Between Servers and Databases Microsoft
To recognize how to manage change, configure and work with linked servers, and manage and tune replication in SQL Server 2005
more...
Managing and Maintaining Database Security in SQL Server 2005

Managing and Maintaining Database Security in SQL Server 2005 Microsoft
To identify strategies for auditing database security at the server and user levels, and determine the appropriate way to protect against and respond to different types of attack on SQL Server
more...
MICROSOFT SQL SERVER 2005 DESIGNING DATABASE SOLUTIONS

MICROSOFT SQL SERVER 2005: DESIGNING DATABASE SOLUTIONS Microsoft
more...
MICROSOFT SQL SERVER 2005 DESIGNING OPTIMIZING DATA ACCESS

MICROSOFT SQL SERVER 2005: DESIGNING & OPTIMIZING DATA ACCESS Microsoft
more...
MICROSOFT SQL SERVER 2005 IMPLEMENTATION AND MAINTENANCE

MICROSOFT SQL SERVER 2005: IMPLEMENTATION AND MAINTENANCE Microsoft
more...
MICROSOFT SQL SERVER 2005 INFRASTRUCTURE DESIGN

MICROSOFT SQL SERVER 2005: INFRASTRUCTURE DESIGN Microsoft
more...
MICROSOFT SQL SERVER 2005 DATABASE MAINTENANCE

MICROSOFT SQL SERVER 2005: DATABASE MAINTENANCE Microsoft
more...
From Software Training Academy, Inc
ADO NET for Windows Applications Using C

...tting. It is current to .NET 2. 0, Visual Studio 2005 and SQL Server 2005.
For students pursuing MCTS certification, the course provides helpful preparation for Exam 70-526: Microsoft .NET Framework 2. 0? Windows-Based Client Development.
The course opens with an overview of ADO. NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion
more...
ADO NET for Web Applications Using C

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
For students pursuing MCTS certification, the course provides helpful preparation for Exam 70-528: Microsoft .NET Framework 2.0?Web-Based Client Development.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of
more...
ADO NET Using C

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
more...
ADO NET Using VB NET

...etting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005.
The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced.
more...
NET Framework Essentials Using C

...h an introduction to database programming using ADO. NET. SQL Server 2005 Express Edition is used in database examples.
The course is practical, with many examples and a case study. The goal is to equip you to begin building significant applications using the .NET Framework. The student will receive a comprehensive set of materials, including course notes and all the programming examples.
more...
From Serebra Learning Corporation
Data Integration with C 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, C# 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
Data Integration with Visual Basic 2005 and ASP NET 2 0
To configure data controls and to establish and configure database connections in .NET 2.0 web applications Individuals who wish to use the .NET Framework 2.0 with Visual Studio 2005, Visual Basic 2005, and ASP.NET 2.0 to develop web-based client applications; individuals preparing for the Microsoft .NET Framework 2.0 Web-Based Client Development (70-528) exam
more...
From InnerWorkings
ASPNET Beginner to Intermediate

Learn how to develop powerful Web apps from a standing start. Youa ll gain an in-depth knowledge of ASP. NET while building fully functional solutions in Visual Studio 2005/ 2008. Along with our comprehensive hands-on Drills, youa ll get working code, MSDN articles, and access to the best authors on the topic from Safari Books Online. Ideal for the ASP. NET beginner or developers
more...
From The Virtual Training Company
Microsoft SQL Server 2005 Administration
...SQL Server 2005 is Microsoft's latest release of their enterprise database solution product. SQL Server 2005 is the result of five years of research, development and collection of suggestions and wish lists from database administrators and developers. Microsoft continues to drive the enterprise database market with the added features and capabilities of this new product. Microsoft Certified
more...
