Online Cube eLearning

Performing Advanced Query Techniques in SQL Server 2008 ...sets and generate rollup information, such as totals, the CUBE, GROUPING SETS, and ROLLUP operators can be used with the GROUP BY statement. UNION, INTERSECT, and EXCEPT can be used to gather specific results in a query. Transact-SQL also provides features that manage international concerns with regards to stored data, such as the collation and sort order. This course demonstrates how to  more...

Implementing SQL Server 2008 Analysis Services Solutions ...so show how to create a SQL Server 2008 Analysis Services cube. This includes how you would use the Cube Designer, how you would define dimensions, define hierarchies, and define attributes. In addition, it includes a discussion on how to define measures, measure groups, and calculations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft  more...

Querying Cubes Working with Data Mining in SSAS ...Cubes & Working with Data Mining in SSAS Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Business Intelligence Development and Maintenance (Exam 70-448) SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying  more...

Oracle Database 10g SQL Fundamentals I Part 2 In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3 ...lines for optimizing aggregation performance; and build a cube and a partition and manage them. L earn To: Create a data warehouse database. Perform the steps necessary to build and manage replication by using the Enterprise Manager. Identify OLAP Manager functions and the contents of DSOs. Build a dimension and assign its member properties. Build an aggregation and identify  more...

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 ... features and functionality of Pivot Table Service, Local Cubes, Client/Server Cache; identify the features of MS English Query; and create and deploy an English Query application. L earn To: Identify the methods of aggregating and accessing data from relational data structures. Create an MDX. Identify the methods of data access from multidimensional data structures. Identify  more...