Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
SQL Server Business Intelligence OverviewГод выпуска: 2010
Производитель: Pluralsight
Сайт производителя: pluralsight.com
Автор: Bret Stateham, et al.
Продолжительность: 3:47
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: This course introduces you to some of the Business Integration tools available in SQL Server, including SSIS, SSRS, and SSAS.
[spoiler="Содержание"]
SQL Server Integration ServicesIntroduction
Overview
Package
Package Example
Control Flow
Control Flow Example
Parallel Control Flow example
Loop example
Data Flow
Data Flow Source
Data Flow Source example
Data Flow Transform
Transform Example
Package Deployment
Deploy and Run example
Summary
SQL Server Reporting ServicesIntroduction
What is SSRS?
Sample Reports
Features
Server Components
Client Components
Report Wizard
Control Properties
Report Data Window
The Toolbox
TextBox Controls and Expressions
Tables and Grouping
Using Parameters
Summary
SQL Server Analysis ServicesIntroduction
Defining OLTP
Defining OLAP
The Data Warehouse
Star Schema
Multi-Dimension Concepts
Understanding Dimensions
Members, Levels and Hierarchies
Measures and Aggregates
SQL Server Analysis Services
System Roles and Workflow
Creating an Analysis Services Project
Creating a Data Source
Creating a Data Source View
Customizing the Data Source View
Creating Name Queries
Creating the Customer Dimension
The Product and Date Dimensions
Creating the Cube
Deployment and Processing
Verifying Deployment
Browsing the Cube
SSAS Clients
Querying from Excel
Querying from SSRS
Querying with ADOMD.NET
SUmmary
SQL Server Integration Services Precedence ConstraintsSSIS Precedence Constraints
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 4:3, 15fps, 242kbps
Аудио: WMA, 48kHz, 128kbps, stereo
[spoiler="Скриншоты"]

[/spoiler]