Introduction to SQL Server 2008 Analysis Services

  • ·Skill level: 100-300
  • ·CourseId: 165
  • ·Status: In Development


This course is an introductory course for Microsoft SQL Server Analysis Services for versions 2008 and 2008 R2. This course features coverage of the basics of business intelligence in the Microsoft world, understanding data warehousing, creating and populating Analysis Services cubes using SQL Server Integration Services (SSIS), and more. We cover the basics of writing MDX statements, doing backup and recovery for SSAS, and database management as well. You will also explore various cube browsers and techniques for wiring applications to your SSAS databases. This course also makes extensive use of LearnItFirst's video exercises which include complete walk-throughs of the solutions (and come with the files containing both the problems and the solutions). NOTE: This course is being released as it is finished. The first chapters being released in April, 2010 and the final chapters released throughout April and May, 2010.

Note: This course is not yet available for purchase (but soon will be). We will announce more details in our newsletter.

To subscribe to our newsletter, create a free account now:


Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)
This course is designed for someone who has at least a basic understanding of SQL and SELECT statements. This course will help you gain a solid understanding of when to use SQL Server Analysis Services as well as a solid foundation on how to get your first cubes and databases created. Prior working experience with SQL Server 2000, SQL Server 2005, or SQL Server 2008 will help you get the most out of this course.
While a true beginner could take this course, it is actually recommended that you have at least 30 days experience working with SQL Server (or equivalent work experience with another database system) prior to taking this course.
  • Are there any sample videos from this course? Not for this course but this instructor has several free videos for other courses. Click here to view this instructor's free videos
  • Can I get a certificate saying I passed/took the course? Yes. Once you have downloaded all of the videos in the course, send us a request for a certificate through our contact us page. We'll send you a certificate that looks like this sample certificate.
  • What is included with this course? Our training courses come complete with the video files, PDFs of the course presentation (for lecture-based videos), and sample projects and files where appropriate. Most courses are a blend of demo and lecture but, depending on the topic, some courses are lecture-only while others are demo-only. Read more
  • Will this course help me pass a certification exam? Absolutely. We have a lot of members who have successfully earned Microsoft certifications with the help of our training materials. We do not, however, consider ourselves a "certification training company"; we are a "real world training company" and we think there is an important difference between the two. Read more

^ Back to top

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.