SQL Server OLAP, DTS, Data Warehousing, Cubes / Analysis Services Training UKThe course covers the main aspects of designing and building data warehouses using SQL Server 2000 or 2005 and Analysis Services. It demonstrates how to construct star schemas in SQL Server and cubes in Analysis Services. In addition, it shows how to use DTS (Data Transformation Services) to migrate and transform data. This is applied to populating OLAP star schemas and cubes from traditional normalised databases.
|
Please click here for a full list of our latest SQL Server 2005 training courses
What You Will Learn
By the end of the course delegates will gain:
Course Content
Course content has been developed for real-world, commercial scenarios by our
expert instructors. See below for detailed syllabus, or if you have a technical query email
.
Duration
4 Days
Target Audience
Anyone interested in getting raw data to the end user as information that has integrity, is retrieved quickly, and requires little or no programming.
Pre Requisite Skills
Delegates should have a good background knowledge of SQL Server.
Review of third normal form and traditional OLTP databases
Introduction to designing OLAP star schemas
Intorduction to designing cubes
Building fact tables
Building dimensions
Building cubes
Browsing cubes in Analysis Manager
Browsing cubes in Excel
Browsing cubes in web pages
Backup and restore of star schemas
Backup and restore of cubes
Cube security
Updating cubes
Guided tour of DTS Designer
Using DTS Wizards
Using DTS Designer
Using DTS to normalise data
Using DTS to denormalise data
Using DTS to process cubes
DTS and TSQL (Transact SQL)
DTS and VB Script
Scheduling DTS packages
Running from stored procedures
Running from Visual Basic
Saving to SQL Server
Saving to file
Saving to Visual Basic
Log files
Error files
Exception files
Associated Courses
SQL Server 2005 Applications Development
training course
SQL Server 2005
Database Administration Training Course
SQL Server
2005 Comprehensive Upgrade Training Course for existing SQL Server 2000 / Oracle
/ MySQL users
SQL Server
2005 Business Intelligence Training Course: SSAS & SSIS Analysis and Integration
Services Training Course
Advanced
SQL Server Analysis Services Training Course
SQL Server
2005 Business Intelligence Training Course: SSRS Reporting Services Training
Course
SQL Server 2000
Applications Development training
SQL Server 2000 Database Administration
SQL
Server Performance Tuning
SQL
Server OLAP, DTS & Cubes Training
SQL Design and Information
Retrieval
|
|
|