 |
 SQL Server Training: Introduction to Microsoft SQL Server 2005 Administration
SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services
SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services
SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration Transact-SQL Training: Introduction to T-SQL for SQL Server
Live Online Training
 Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
Contract #
3-09-70-2645A
Recent Training Venues
Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- Oceanside / San Diego, California
- Pasadena / Orange County / Los Angeles, California
- San Bernardino / Riverside, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- DeLand / Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Gainesville / Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Titusville & Melbourne, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Macon & Columbus, Georgia
- Boise, Idaho
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Greenbelt / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Flint, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Whiteman Air Force Base / Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Santa Fe / Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Trenton, New Jersey
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Providence, Rhode Island
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Stockholm, Sweden
- Chattanooga / Knoxville, Tennessee
- Memphis / Jackson / Nashville, Tennessee
- College Station and Houston, Texas
- El Paso, Texas / Ciudad Juarez, Mexico
- San Antonio / Austin, Texas
- Wichita Falls & Dallas, Texas
- Ogden / Salt Lake City, Utah
- Burlington, Vermont
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Madison / Milwaukee, Wisconsin
|
|
|
SQL Server 2008 MDX Training
|
Course Number: 931
Duration: 3 days
view class outline
SQL Server 2008 MDX Training Overview
Accelebrate's SQL Server 2008 MDX training teaches attendees the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.
SQL Server 2008 MDX Training Prerequisites
All SQL Server 2008 MDX training attendees should have prior experience with SQL Server 2008.
Hands-on/Lecture Ratio
This SQL Server 2008 MDX training class is 50% hands-on, 50% lecture, with the longest lecture segments lasting for 20 minutes.
SQL Server 2008 MDX Training Materials
All SQL Server 2008 MDX training students receive a copy of Microsoft Press's Microsoft SQL Server 2008 MDX Step by Step.
Software Needed on Each Student PC
- SQL Server 2008, including Analysis Services.
- The AdventureWorks 2008 database
Note: If you have purchased this course, please contact us for a detailed setup sheet.
SQL Server 2008 MDX Training Objectives
All attendees will learn to:
- Construct and execute MDX queries
- Work with tuples, sets, and expressions
- Build complex sets to retrieve the exact data users need
- Perform aggregation functions and navigate data hierarchies
- Assemble time-based business metrics
- Customize an Analysis Services cube through the MDX script
- Implement dynamic security to control data access
- Develop MDX-driven reports in SQL Server Reporting Services
|
SQL Server 2008 MDX Training Outline
- Welcome to MDX
- The Business Intelligence Landscape
- The Dimensional Model
- Implementing the Dimensional Model
- The MDX Language
- Using the MDX Query Editor
- SQL Server Management Studio
- The MDX Query Editor
- Building a Simple MDX Query
- Exploring the Step-by-Step Cube
- Building a More Complex Query
- Understanding Tuples
- N-dimensional Space
- Cube Space
- Accessing Data with Tuples
- Understanding Cells
- Working with Partial Tuples
- Building Tuples with User-Hierarchies
- Working with Sets
- Set Basics
- Understanding the SELECT Statement
- Building Sets with Functions
- Limiting Sets
- Working with Expressions
- Expression Basics
- Calculated Members
- Building Dynamic Expressions
- Resolving Contextual Conflicts
- Building Complex Expressions
- Building Complex Sets
- Assembling Ordered Sets
- Retrieving the First or Last Tuples of a Set
- Filtering Sets
- Combining Sets
- Performing Advanced Set Construction
- Performing Aggregation
- Performing Summation
- Calculating Averages
- Identifying Minimum and Maximum Values
- Counting Tuples in Sets
- Navigating Hierarchies
- Accessing Immediate Relatives
- Accessing Extended Relatives
- Navigating within a Level
- Working with Time
- Understanding the Time Dimension
- Calculating an Accumulating Total
- Performing Period-over-Period Analysis
- Combining Time-Based Metrics
- Enhancing the Cube
- Understanding the MDX Script
- Constructing Calculated Members
- Assembling Named Sets
- Implementing Dynamic Security
- Understanding Dynamic Security
- Implementing Attribute-Hierarchy Restrictions
- Implementing Cell-Level Restrictions
- Building Reports
- Getting Started
- Connecting to Analysis Services
- Designing the Dataset
- Adding Parameters to the Dataset
- Presenting the Data in the Report
- Conclusion
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
| |
| Accelebrate E-Newsletter |
|
Get the latest Web development news delivered to your email box once a month!
|
|
|
|
|
