Learn SQL with Microsoft SQL Server training

The SQL Server Analysis Services (SSAS) Maestro program is a three-day, deep-dive course on Microsoft SQL Server 2008 R2 Analysis Services. It gives architects and consultants the education and hands-on experience needed to deliver highly scalable Online Analytical Processing (OLAP) solutions.

The SSAS Maestro program was created as a way to share the lessons learned by enterprise customers of the SQL Customer Advisory Team (SQLCAT) using complex SQL Server 2008 R2 Analysis Services and a Unified Dimensional Model (UDM). As an example, you can learn about Yahoo!’s 24 TB Analysis Services cube, which was announced during the PASS Summit 2010 Day One Live Streaming Keynote with Senior VP Ted Kummert.

The in-depth knowledge of experts such as Akshai Mirchandani, Thomas Kejser, John Sirmon, and Denny Lee has been incorporated by the Solid Quality Mentors team into a three-day, deep-dive course, consisting of 11 modules, with labs and exams.

Benefits

Upon successful completion of this course, attendees will:

Requirements

Because of the complexity of the subject matter and the depth of the lessons, the course has strict requirements, including the following:

Following the technical conference conventions defining 400-level sessions, this is a 500-level course. It is modeled after the MCM SQL certification program.

Additional Microsoft hosted SSAS Maestro training courses will be available in the near future. Check back on this site for updates. For questions or for a list of courses hosted by certified Maestro trainers, please email sqlmaestros@microsoft.com.

SSAS Maestro program: Training objectives

Future courses will include training information on Analysis Services Tabular.

Module 1: Analysis Services 2008 R2 and Large Cubes

Module 2: Tools for Monitoring and Optimizing Analysis Services

Module 3: Internal Data Storage Structures

Module 4: Memory Management

Module 5: Thread Management

Module 6: Designing Partitions

Module 7: Designing Aggregations

Module 8: High Performance ROLAP Partitions for Large Cubes

Module 9: Large Cube Processing Strategies

Module 10: Advanced Dimension Design Best Practices

Module 11: Query Performance Monitoring and Tuning

Module 12: Scale-Out Querying with Read-Only Databases

Meet the SSAS Maestros

Microsoft is building a significant community of SSAS Maestros. Those who hold this designation live and work in many countries and regions, including the United States, Europe, Latin America, and Asia Pacific. All have varied backgrounds, interests, and extensive experience.

Consider connecting with these SSAS Maestros for help with your project. We add names regularly—so check back again for opportunities to connect with someone in your region.

Individuals have agreed to be listed here; therefore, the list may not represent the complete Maestro community.