SQL Server 2005 Courseware
Microsoft SQL Server is a relational database server that provides high levels of security, reliability, and scalability for business-critical applications. Its primary query languages are T-SQL and ANSI SQL. SQL Server allows storage of data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. It includes a rich set of integrated services that enables queries, searches, synchronization, reporting, and analysis.
SQL Server enables data to be consumed from custom applications developed using Microsoft .NET and Visual Studio and from within service-oriented architectures (SOA) and business processes through Microsoft BizTalk Server.
The Microsoft SQL Server courses listed in this category are specifically designed by practicing experts to get your students up to speed on SQL Server 2005.
Looking for training materials for a different version of SQL Server? ITCourseware also provides training materials for Microsoft SQL Server 2008.
Student Price:
$ 200.00
SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. In this 5-day course you'll learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 120.00
Developing a database, getting the database to work with your applications, and getting it to production is just the beginning, but can often be where the story ends. This 3-day course examines other SQL Server 2005 essential application, support, and maintenance topics. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 200.00
In this 5-day course, you'll learn how to develop projects for SQL Server. This includes how to design, create, modify, analyze and tune your databases. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 160.00
In this 4-day course, you'll learn about available features for the administration of SQL Server, and how to design, create, modify, analyze and tune your databases. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 80.00
This 2-day, interactive workshop is designed for new users of Microsoft SQL Server Reporting Services 2005. Some of the topics covered include a review of the software features, administrative tasks, report design, creation of presentation quality reports, and report deployment. The course incorporates a number of hands-on exercises to reinforce the learning process.
Learn More
Student Price:
$ 120.00
In this 3-day course, you will learn how to use 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. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 120.00
This 3-day course will enable technology professionals 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. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 120.00
In this 3-day course, you will learn how to use Microsoft 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. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 120.00
In this 3-day 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. The instructor kit for this course is appropriate for self-study.
Learn More
Student Price:
$ 160.00
This comprehensive 4-day course takes you from the basic features that are available in SQL Server to building effective views and user-defined functions using Transact-SQL and finishes with more advanced features, such as complex data and structures, implicit transactions, and the xml data type. The instructor kit for this course is appropriate for self-study.
Learn More