Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Accelerated Microsoft Business Intelligence (SQL 2008)
SQL Training Overview

This four-day, comprehensive course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007

SQL Training Audience:

DBAs, Developers, and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment.

SQL Training Prerequisites

A working knowledge of RDBMS, Business Intelligence Studio, and Excel and the Office Ribbon. Students must also possess an understanding of the goals of Business Intelligence.

SQL Training Course duration

4 days

SQL Training Course outline

The Microsoft Business Intelligence Stack

  • The Goal of Business Intelligence
  • Informed and Timely Decisions
  • The Microsoft BI Stack
  • Key Concepts
  • Data Warehouse
  • Data Mart
  • Cubes
  • Dimensions
  • Measures
  • Fact Table
  • Key Components
  • SQL Server Analysis Server
  • SQL Server Integration Server
  • SQL Server Reporting Services
  • Data Mining
  • MDX
  • SharePoint Report Center
  • Office 2007
  • Common Business Challenges in BI
  • Unified Data Model
  • UDM Defined
  • Definition
  • Structure
  • Data Sources
  • Data Views
  • Proactive Caching
  • XML Definitions
  • User Experience
  • Relational Querying the Data Sources Directly
  • UDM and Simplified Access
  • Advantages
  • Trouble in River City
  • When Not to Use the UDM
  • SharePoint and Business Intelligence
  • What is SharePoint?
  • Collaboration
  • Portals
  • Enterprise Search
  • Content Management
  • Business Process and Forms
  • Business Intelligence
  • What Does SharePoint Bring to BI?
  • Key SharePoint Concepts
  • SharePoint or WSS?
  • SharePoint Architecture
  • MOSS Adopts a Typical 3-Tier Model
  • The Shared Service Provider
  • Content Types
  • Document Classification System
  • Metadata
  • Document Templates
  • Forms Associate With
  • Workflows Associated With
  • Supports Inheritance
  • Solutions
  • Features
  • 12 Hive
  • New BI Features in SQL 2008
  • Integration Services
  • Analysis Services
  • Reporting Services
  • SQL Server Integration Services Major Components
  • Major Components
  • Data Import/Export Wizard
  • ETL Tool
  • Control Flow Engine
  • Application Platform
  • High Performance Data Transformation Data Pipeline
  • New or Changed Features
  • Code Samples
  • The SSIS Object Model
  • Downloading a File Using HTTP
  • Loading the Contents of a Text File into a Variable
  • Simple Custom Logging
  • Handling Exceptions
  • SQ Server Integration Services Extract/Transform/Load
  • SSIS and ETL
  • ETL Life Cycle
  • Extract
  • Transform
  • Load
  • Transformers
  • Best Practices for Deployment
  • Scope
  • Deploying Packages
  • Testing Packages
  • Data Flow Practices
  • Package Design
  • Best Practices for Design
  • SQL Server Analysis Server Part 1
  • Key Concepts
  • Cubes
  • Multi Dimension Space
  • Schemas
  • Star
  • Snowflake
  • Measures
  • Dimensions
  • Hierarchies
  • Time Dimension
  • Slowly Changing Dimension
  • SQL Server Analysis Server Part 2
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Notification Settings
  • Aggregations
  • Design of Aggregations
  • Monitoring
  • SQL Server Reporting Services
  • Integration with SharePoint
  • SharePoint Integrated Mode
  • Integrated Install
  • Report Builder 2.0
  • Tablix
  • Charts
  • New Chart Types
  • Advanced Chart Functionality
  • Parameters
  • Interactive Sorting
  • Actions
  • Document Maps
  • Sub-Reports
  • Interactive Features
  • Differences Between Environments
  • Developers
  • Basic Users
  • Power Users
  • SharePoint Business Data Catalog
  • Why a Business Data Catalog
  • Special BDC Only Web Parts
  • Business Data Web Parts
  • Business Data List
  • Business Data Item Web Pat
  • Business Data Related List Web Part
  • Business Data Item Builder
  • Application Definition Files
  • Line of Business
  • Entity
  • Method
  • Parameter
  • Filter Descriptor
  • Association
  • Action
  • Authentication and Security
  • PassThrough
  • RevertToSelf
  • WindowsCredentials/RDBCredentials
  • Credential
  • SharePoint Integrated Security and Report Management
  • Understanding SharePoint Security
  • Groups
  • Securable Items
  • Report Content Types
  • Report Subscriptions
  • Scheduled Delivery
  • Rendering Type
  • Where to Deliver
  • SharePoint
  • File Share
  • Workflows
  • Out of Box
  • SharePoint Designer
  • Visual Studio
  • Reports Library
  • Part of the Report Center Template
  • Default Content Types
  • Can be Created in Any Site
  • Default Launch is Excel
  • Business Web Parts
  • What is a Web Part?
  • Excel 2007 and Data Mining
  • Notable Uses of Data Mining
  • Pattern Mining
  • Subject Based Mining
  • Games
  • Business
  • Key Terms in Data Mining
  • Data Mining Model
  • Columns
  • Cases
  • Case Table sand Nested Tables
  • Types of Data Mining Algorithms
  • Classification Algorithms
  • Regression Algorithms
  • Segmentation Algorithms
  • Association Algorithms
  • Sequence Analysis Algorithms
  • The Algorithms
  • Excel and the BI Extensions
  • Add Ins
  • Forecast Table Analysis Tool
  • Prediction Calculator Tool
  • Shopping Basket Analysis Tool
  • Detect Categories Table
  • Analyze Key Influencers
  • Visio 2007

  •  
    About us
    Contact us
    Careers at Wintrac
    Our Clients
    Why Wintrac


    Register for a free training CD-ROM drawing
    Refer a client or instructor and earn $$$


    Wintrac Inc.
    16523 SW McGwire Ct.
    Beaverton OR 97007
     
    Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy