Online Sql Server 2005 eLearning - Training Resources
Sql Server 2005 Training Provider? - Tell us about your Training!
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...
Database Deployment and Data Distribution
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...
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

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

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