Comparison of MDX and SQL - view details
In this video, Scott will talk to you about the basics of what MDX is, and how it compares to SQL. He will give you some examples of high-level differences between MDX and SQL, as well as ideas for how to think about the two languages without getting stressed out!
Highlights from this video:What's wrong with using a GUI?
How you can benefit from learning MDXFiguring out what the end user wants to seeMDX versus SQLLanguage differences
Working with hierarchiesAxes versus columns and rows and much more Source: http://www.learnitfirst.com/Course/165/Video/2803/Comparison-MDX-SQL.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 16:00 (32.2MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql server 2008, analysis services, multidimensional expressions, graphical user interface, OLAP, SSAS, SSIS, hierarchy, mdXML
This video comes from the SQL Server 2008 Analysis Services online training course, SQL Server 2008/R2 Analysis Services. And be sure to check out even more SQL Server Analysis Services training videos.
