Exclusive SQL Server Education
We're proud to feature high-end SQL offerings through our partnership with
Solid Quality Mentors. Solid Quality Mentors are experts in their area and work with Microsoft, publish articles and speak at international conferences. They're committed to providing unparalleled service to the SQL Server community, and they have just one goal: offer deep training and mentorship to help your company provide the best service to your customers by maximizing the integrity of your database systems and applications.
Upcoming Exclusive SQL Classes
SQL Server 2008 End-to-End Business Intelligence Workshop
5 Days 200+ Level
Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. This five-day workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services.
Register>> Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 & 2008
5 Days 400+ Level
This course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. In this five-day course, you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Ranking Functions, Joins and Set Operations; Aggregating and Pivoting Data; TOP and APPLY; Data Modification; Data Type Related Problems; Programmable Objects; Graphs, Trees and Hierarchies. Through the course you will learn how to use T-SQL to solve practical problems.
Register>> Deploying, Operating and Tuning an Analysis Services 2008 Solution
3 Days 300+ Level
During this three-day course, you will learn to deploy, operate and tune an Analysis Services solution. You begin by learning how to prepare for the successful deployment of an Analysis Services solution. You will then learn to update data in a production environment while minimizing its impact on performance. Finally, you will learn to collect and analyze data to improve processing and querying performance. The target audience for this course is IT professionals and business intelligence developers who want to successfully deploy and operate well-performing Analysis Services solutions.
Register>> Solving Business Problems with MDX in SQL Server 2008
5 Days 300+ Level
This hands-on, five-day course will guide you step by step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information.
Register>> Microsoft Office PerformancePoint Server Monitoring and Analytics
3 Days 200+ Level
Written and delivered by industry experts, this three-day course provides students with the technical skills required to design, develop and manage interactive dashboards using Microsoft Office PerformancePoint Server (PPS) 2007 Monitoring. The course consists of lessons, demonstrations and comprehensive “real world” student lab exercises and a case study.
Register>> Enterprise ETL with SQL Server 2005 & 2008 Integration Services
4 Days 300+ Level
During this four-day instructor-led training, you will learn the ins and outs of SSIS and how to apply its enterprise functionality to data warehouse ETL systems. At the completion this course, you will understand how to design, develop, deploy, and operate SSIS solutions from source systems extractions, to data integration and transformation, to business intelligence system loading including how to process SQL Server Analysis Services (SSAS) cubes. This course will demonstrate a fully working ETL solution, including extensive demos, sample projects that will not only teach how to use the new technology, but also illustrate business intelligence ETL and data warehouse best practices.
Register>>