Год выпуска: 2010
Производитель: CBT Nuggets
Автор: Anthony Sequeira
Продолжительность: 07:01:27
Тип раздаваемого материала: Видеоурок
Язык: Английский
Стоимость: 1999 рублей
Описание:
If you're a SQL Server 2008 data warehousing developer or analyst, you'll want to harness the power of SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)and SQL Server Reporting Services (SSRS.
After finishing this cool video training you'll be able to: extract, transform, and load data into meaningful end-user information; create, deploy, and utilize data warehousing cubes and dimensions for data analysis; and create and deploy data reports in various formats.
This course maps to Microsoft exam 70-448, so it carefully prepares you for that exam.
All trademarks and copyrights are the property of their respective holders.
[wpspoiler name="Подробное описание" ]
1. SQL Server 2008 SSIS Overview (00:22:26)
SQL Server 2008 SSIS overview, SSIS architecture, SSIS example
2. SSIS: More ETL (00:25:23)
SSIS looping, variables, package configurations, sorting, writing to flat file
3. SSIS: Troubleshooting & Error Handling (00:24:19)
SSIS loggin, error output, data viewer, debugger, checkpointing, transactions
4. SSIS: Deployment (00:23:31)
SSIS deployment utility, executing packages, dtutil, dtexec, package protection levels
5. SSIS: Handling Events and Custom .NET Code (00:27:48)
SSIS handling events, event scope, event types, custom SSIS .NET code
6. SSAS: Dimensions, Measures & Cubes (00:25:52)
SSAS benefits, SSAS architecture, SSAS dimensions, measures, cubes
7. SSAS: Dimension Attributes (00:25:16)
SSAS dimension attributes, named calculations, attribute hierarchies, attribute relationships, columns, custom sorting
8. SSAS: Dimension Relationships (00:28:10)
SSAS referenced relationship, self referencing fact/dimension table, many to many relationships, star schema, snowflake schema
9. More SSAS Features (00:27:46)
SSAS buckets, calculated attributes, named sets
10. SSAS: Key Performance Indicators (00:26:01)
SSAS Key performance indicators, KPI, KPI trending, parent KPIs
11. SSAS: More Cube Options (00:31:43)
SSAS drill-through actions, translations, perspectives, partitions and aggregations
12. SSAS Data Mining (00:32:58)
SSAS data mining, data mining process, predicting behavior, decision trees, clustering
13. Introduction to SSRS (00:29:39)
SSRS architecture, SSRS report, SSRS parameters, SSRS headers and footers, SSRS pagination, embedding images in SSRS report
14. Advanced SSRS (00:36:30)
SSAS as SSRS data source, SSRS matrix reports, SSRS conditional formatting, SSRS parent/child reports, SSRS charts
15. SSRS Management & Deployment (00:34:05)
SSRS configuration, SSRS authentication, SSRS deployment, SSRS Report Builder, SSRS farm, SSRS key management
[/wpspoiler]
