ADO NET Using Visual Basic 2005 Learn about the features provided by ADO.NET 2.0 including
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that more...
ADO NET Using Visual C 2005 Learn about the features provided by ADO.NET 2.0 including
connecting to data sources, the various ADO.NET classes,
stored procedures, parameters, return values, how to
search, sort, and filter data stored in a DataSet or DataTable.
Become familiar with strongly typed DataSets and learn their advantages.
See how to leverage the power of XML through various means. Examine new
ADO.NET features that more...
SQL Server 2005 Additional Topics ...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.
Audience:SQL Server 2005 administrators seeking advanced knowledge in the more...
SQL Server 2005 Administration Learn about the features of SQL Server; how to design and create a
database; and how to build basic queries using Transact-SQL.
Learn how to build effective views, stored procedures,
triggers, and user-defined functions, using Transact-SQL.
Learn about the new enhancements to the Transact-SQL
programming language including improved support for error handling
and hierarchical queries, and more...
SQL Server 2005 Analysis Services ...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. 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 solutions. more...
SQL Server 2005 Reporting Services ...SQL Server 2005
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2005 and SQL Server 2005
Business Intelligence Studio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, more...
SQL Server 2005 T-SQL Learn how to build basic queries using Transact-SQL, the language of
SQL Server. Learn how to build effective views, stored procedures,
triggers, and user-defined functions using Transact-SQL.
Learn about the new enhancements to the Transact-SQL programming
language including improved support for error handling and
hierarchical queries, and how programmers can now use .NET languages
like C# and more...
Implementing SQL Server 2005 ...ts with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Audience
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.
At Course more...
8814 Microsoft Dynamics GP Installation and Configuration ...mizes the installation time for your customers. Microsoft SQL Server 2005 is discussed as it applies specifically to Microsoft Dynamics GP.
The course covers the installation of Microsoft Dynamics GP and the installation of the related products listed in the agenda. This course does not go into the setup and use of the application as these topics are covered by other classes offered by more...
Maintaining a Microsoft SQL Server 2005 Database ...oduct knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database.
At Course more...
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 ...rmine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.
Audience This course is intended for current professional database more...
Implementing a Microsoft SQL Server 2005 Database ...duct knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Audience This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
At Course more...
Designing the Data Tier for Microsoft SQL Server 2005 ...knowledge and skill to design the data tier for Microsoft SQL Server 2005. The clinic focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today.
Audience This course is intended for current professional database developers more...
Designing Microsoft SQL Server 2005 Server-Side Solutions ... and skills to design server-side solutions for Microsoft SQL Server 2005T. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single more...
Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005 ...the knowledge
and skills to upgrade their skills to SQL Server 2005 so
that they can design, build, query and develop enterprise
SQL Server 2005 databases and servers. Provides students
with the knowledge and skills to upgrade their skills to SQL
Server 2005 so that they can support, configure, and
maintain enterprise SQL Server 2005 databases and servers. more...
Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005 ...the knowledge
and skills to upgrade their skills to SQL Server 2005 so
that they can design, build, query and develop enterprise
SQL Server 2005 databases and servers. Provides students
with the knowledge and skills to upgrade their skills to SQL
Server 2005 so that they can support, configure, and
maintain enterprise SQL Server 2005 databases and servers. more...
Designing on OLAP Solutions Architecture Using Microsoft SQL Server 2005 THANK YOU FOR YOUR INTEREST
IN COURSE 2796!
Introduction
Elements of this syllabus are subject
to change.
The purpose of this 3-day course is
to teach Business Intelligence (BI) professionals working in
enterprise environments to design a multidimensional solution
architecture that supports their BI solution. Students will go
through the entire process from more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Course 2733) Thank you for your interest in Course 2733.
Introduction
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
This course is intended for experienced database administrators and database developers who are responsible for more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005 ... with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
Audience This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers.
At more...
Updating Your Database Development Skills to Microsoft SQL Server 2005 ... with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.
Audience This course is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.
At more...