SQL school training courses in Eagan, MN (public, in-house or online)

In this 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. 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 solutions. This course also provides information on e...

Full archival course description>>

This 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. 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 Data Flow. You will also become familiar with SSIS pack...

Full archival course description>>

In this 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. You’,ll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’,ll explore the deployment and printing of reports and the export of report...

Full archival course description>>

Exam 70-448

6234 Implementing and Maintaining Microsoft® SQL Server 2008 Analysis Services Training;
6235 Implementing and Maintaining Microsoft® SQL Server 2008 Integration Services Training

6236 Implementing and Maintaining Microsoft® SQL Server 2008 Reporting Services Training

6232: Implementing a Microsoft SQL Server 2008 Database

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL