Custom Search

> > > >

Online Sql Server 2005 eLearning - Training Resources

Sql Server 2005 Training Provider? - Tell us about your Training!

Matching Training Programs

online course

instructor-led class

learn at home

group study

self-directed study

cd-based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer-based learning

discount pricing

online tutorial

Sql Server 2005 Training Seminars and Classes

From 123-CBT Computer Based Training

Database Deployment and Data Distribution

recognize how to design, deploy and utilize database deployment and database distribution solutions more...

Designing Access to SQL Server Data

recognize how to design and utilize data access technologies to manage SQL Server and access SQL Server Data more...

Designing Efficient Application Access

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

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

recognize how to design and implement an appropriate cursor strategy in SQL Server 2005 more...

Designing a SQL Server 2005 Transaction Strategy

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

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

recognize how to optimize query performance and indexing strategies in SQL Server 2005 more...

Optimizing Storage in SQL Server 2005

recognize how to optimize database storage and SQL Server performance more...

Scaling Applications and Resolving Performance Issues

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

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

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

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

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

To select the appropriate data backup and recovery solution for a SQL Server 2005 database more...

Optimizing SQL Server 2005 Performance

To identify ways of optimizing the performance of SQL Server 2005 more...

Optimizing a Database Data Recovery Plan for SQL Server 2005

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

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

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

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

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...

Designing an Application Solution for SQL Server 2005

recognize how to design and build a database model and a physical database, and how to secure it more...

Designing Database Objects

recognize how to design database objects according to your requirements more...

Programming with SQL Server 2005

recognize how to implement SQL Server 2005 programming features to work with database data more...

Using XML

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

CLR Integration

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

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

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

recognize how to implement Reporting Services to generate reports and Integration Services to manipulate data according to your requirements more...

Installing SQL Server 2005

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

Configuring SQL Server 2005

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

To create and implement key database objects in SQL Server 2005 more...

Retrieving Data and Running Queries in SQL Server 2005

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

To implement Service Broker components and use full-text search in SQL Server 2005 more...

Managing and Maintaining SQL Server 2005 Databases

To manage and maintain SQL Server 2005 databases more...

SQL Server 2005 Database Performance and Optimization

To monitor and optimize database performance using SQL Server utilities more...

Monitoring and Diagnosing Database Problems in SQL Server 2005

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

To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005 more...

SQL Server 2005 Backup and Restores

To back up and restore a database in SQL Server 2005 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 Software Training Academy, Inc

SQL Server 2005 Reporting Services SSRS

...SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data more...

SQL Server 2005 Transact SQL T-SQL

In this course, you ll learn how to build basic queries using Transact-SQL, the language of SQL Server. Then, you'll learn how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL. You'll learn about the new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and programmers more...

SQL Server 2005 Transact SQL T-SQL with Additional Topics

...ase objects. You'll also learn about enhancements made to SQL Server 2005 for handling complex data structures, using partitioning, and working with XML. LEARNING OBJECTIVES Understand basic database design principles and how to implement them in SQL Server. Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data. Understand the differences between view, more...

SQL Server 2005

...es like C# and Visual Basic to build database objects. SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. You'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. You'll learn how to take advantage of SQL Server's tools for analyzing and tuning your more...

SQL Server 2005 Integration Services SSIS

... with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and more...

SQL Server 2005 - Additional Topics

...often be where the story ends. This course examines other SQL Server 2005 essential application, support, and maintenance topics features you can use for high-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML. LEARNING more...

SQL Server 2005 Analysis Services SSAS

...SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system more...

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

NET Framework Essentials Using Visual Basic

...th 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...

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...

NET Framework Using C CLI

...th 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. 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. LEARNING more...

NET Framework using Visual Basic

...es an introduction to database programming using ADO.NET. SQL Server 2005 Express Edition is used in database examples. Finally, the .NET Framework diagnostic facilities are discussed in depth. 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 more...

NET Framework using C

From Binary Research International, Inc.

Implementing and Maintaining Microsoft SQL Server 2005 The training course consists of online, live instructor-led sessions and additional self-paced e-learning content, scenario-based labs, and assessments to provide Participants with the knowledge and skills to manage and maintain Microsoft SQL Server 2005. Topics include: SQL Server 2005 Architecture Preparing to Install SQL Server 2005 Installing SQL Server 2005 Installing and Configuring 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...