SQL Server Business Intelligence (Certificate)

New Horizons Learning Center Philippines
Alabang, Makati City, Marikina City, Philippines

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Formerly ’non-MOC’ course 7032, this course on SQL Server 2005 provides many new and enhanced business intelligence (BI) features designed to give you a competitive advantage.

Who Should Attend:
This course is intended for IT professionals.

At Course Completion:
After completing this course, students will be able to: - Explain the elements of SQL Server Business Intelligence. - Input and output data, script to branch control, and configure and deploy packages. - Create an account and work with measures. - Scale Analysis Services. - Use Client Reporting Tools and the web service. - Create custom OLAP clients. - Create queries using Analytical MDX. - Create and execute a package using Integration Services.


Outline: Top
Lesson 1: Quick Start Introduction
Integration Services
Analysis Services
Reporting Services
SQL Server Management Studio
Top
Lesson 2: Integration Services
Cleanse Data Input
Output to Multiple Destinations
Script to Branch Control
Lookup Fuzzy Values
Package Configuration and Deployment

Lesson 3: Core Analysis Services
Explore Analysis Services Objects
Create an Account (Parent-Child) Dimension
Create Measure Groups
Add Time
Work with Measures
Create AMO

Lesson 4: Analysis Services Scalability
Analysis Services Demonstrations
Cube Scalability
Aggregates in Natural Hierarchies

Lesson 5: Client Reporting Tools
Client Reporting Tools Demonstrations
Use URL Access in Applications
Use the Web Service
Top
Lesson 6: Custom OLAP Clients
Custom OLAP Clients Demonstrations
Render Cells
Render a Flattened Rowset

Lesson 7: Analytical MDX
MDX Queries: MDX vs. SQL
MDX Stored Procedures

Lesson 8: Data Mining
Browse Data Mining Models
Add DM Viewers to a Web Page

Lesson 9: Extending Integration Services
Create and Execute a Package
...''

Elements of this syllabus are subject to change.

Phone:(63)2-859-2801

School Address:

CEO Suite, Level 37
LKG Tower
Ayala Avenue, Makati 1226
Philippines


Jobs & Resumes: Alabang, Makati City, Marikina City
Houses & Roommates: Alabang, Makati City, Marikina City
Travel Agencies:

Search other schools for SQL Server Business Intelligence training resources.

Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
implementing and maintaining microsoft sql server 2008 reporting services
oracle database 10g - introduction to sql
Oracle Database 10g: Program With PL/SQL
Oracle10g SQL and SQL Plus
Installing and Managing Microsoft Exchange Server 2007
Managing Messaging Security using Microsoft Exchange Server 2007
Recovering Messaging Servers and Databases Using Microsoft Exchange Server 2007
Monitoring and Troubleshooting Microsoft Exchange Server 2007
Designing a Messaging Infrastructure Using Microsoft Exchange Server 2007
Designing a High Availability Messaging Solution Using Microsoft Exchange Server 2007

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.