Tweet
CBT Exam-Pack 70-448: Microsoft SQL Server 2008
[img[http://cbtnuggets.com/images/products/msft_70_448.jpg[/img]
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 series maps to Microsoft exam 70-448, so it carefully prepares you for that exam.
Exam-Pack 70-448: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance contains:
* SQL Server 2008 SSIS Overview
* SSIS: More ETL
* SSIS: Troubleshooting & Error Handling
* SSIS: Deployment
* SSIS: Handling Events and Custom .NET Code
* SSAS: Dimensions, Measures & Cubes
* SSAS: Dimension Attributes
* SSAS: Dimension Relationships
* More SSAS Features
* SSAS: Key Performance Indicators (free video!)
* SSAS: More Cube Options
* SSAS Data Mining
* Introduction to SSRS
* Advanced SSRS
* SSRS Management & Deployment
Here's what you'll learn in each video of the SQL Server 2008 70-448 series:
Video 1 - "SQL Server 2008 SSIS Overview" - SQL Server 2008 SSIS overview, SSIS architecture, SSIS example
Video 2 - "SSIS: More ETL" - SSIS looping, variables, package configurations, sorting, writing to flat file
Video 3 - "SSIS: Troubleshooting & Error Handling" - SSIS loggin, error output, data viewer, debugger, checkpointing, transactions
Video 4 - "SSIS: Deployment" - SSIS deployment utility, executing packages, dtutil, dtexec, package protection levels
Video 5 - "SSIS: Handling Events and Custom .NET Code" - SSIS handling events, event scope, event types, custom SSIS .NET code
Video 6 - "SSAS: Dimensions, Measures & Cubes" - SSAS benefits, SSAS architecture, SSAS dimensions, measures, cubes
Video 7 - "SSAS: Dimension Attributes" - SSAS dimension attributes, named calculations, attribute hierarchies, attribute relationships, columns, custom sorting
Video 8 - "SSAS: Dimension Relationships" - SSAS referenced relationship, self referencing fact/dimension table, many to many relationships, star schema, snowflake schema
Video 9 - "More SSAS Features" - SSAS buckets, calculated attributes, named sets
Video 10 - "SSAS: Key Performance Indicators" - SSAS Key performance indicators, KPI, KPI trending, parent KPIs
Video 11 - "SSAS: More Cube Options" - SSAS drill-through actions, translations, perspectives, partitions and aggregations
Video 12 - "SSAS Data Mining" - SSAS data mining, data mining process, predicting behavior, decision trees, clustering
Video 13 - "Introduction to SSRS" - SSRS architecture, SSRS report, SSRS parameters, SSRS headers and footers, SSRS pagination, embedding images in SSRS report
Video 14 - "Advanced SSRS" - SSAS as SSRS data source, SSRS matrix reports, SSRS conditional formatting, SSRS parent/child reports, SSRS charts
Video 15 - "SSRS Management & Deployment" - SSRS configuration, SSRS authentication, SSRS deployment, SSRS Report Builder, SSRS farm, SSRS key management
All trademarks and copyrights are the property of their respective holders.
[img[http://cbtnuggets.com/images/products/msft_70_448.jpg[/img]
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 series maps to Microsoft exam 70-448, so it carefully prepares you for that exam.
Exam-Pack 70-448: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance contains:
* SQL Server 2008 SSIS Overview
* SSIS: More ETL
* SSIS: Troubleshooting & Error Handling
* SSIS: Deployment
* SSIS: Handling Events and Custom .NET Code
* SSAS: Dimensions, Measures & Cubes
* SSAS: Dimension Attributes
* SSAS: Dimension Relationships
* More SSAS Features
* SSAS: Key Performance Indicators (free video!)
* SSAS: More Cube Options
* SSAS Data Mining
* Introduction to SSRS
* Advanced SSRS
* SSRS Management & Deployment
Here's what you'll learn in each video of the SQL Server 2008 70-448 series:
Video 1 - "SQL Server 2008 SSIS Overview" - SQL Server 2008 SSIS overview, SSIS architecture, SSIS example
Video 2 - "SSIS: More ETL" - SSIS looping, variables, package configurations, sorting, writing to flat file
Video 3 - "SSIS: Troubleshooting & Error Handling" - SSIS loggin, error output, data viewer, debugger, checkpointing, transactions
Video 4 - "SSIS: Deployment" - SSIS deployment utility, executing packages, dtutil, dtexec, package protection levels
Video 5 - "SSIS: Handling Events and Custom .NET Code" - SSIS handling events, event scope, event types, custom SSIS .NET code
Video 6 - "SSAS: Dimensions, Measures & Cubes" - SSAS benefits, SSAS architecture, SSAS dimensions, measures, cubes
Video 7 - "SSAS: Dimension Attributes" - SSAS dimension attributes, named calculations, attribute hierarchies, attribute relationships, columns, custom sorting
Video 8 - "SSAS: Dimension Relationships" - SSAS referenced relationship, self referencing fact/dimension table, many to many relationships, star schema, snowflake schema
Video 9 - "More SSAS Features" - SSAS buckets, calculated attributes, named sets
Video 10 - "SSAS: Key Performance Indicators" - SSAS Key performance indicators, KPI, KPI trending, parent KPIs
Video 11 - "SSAS: More Cube Options" - SSAS drill-through actions, translations, perspectives, partitions and aggregations
Video 12 - "SSAS Data Mining" - SSAS data mining, data mining process, predicting behavior, decision trees, clustering
Video 13 - "Introduction to SSRS" - SSRS architecture, SSRS report, SSRS parameters, SSRS headers and footers, SSRS pagination, embedding images in SSRS report
Video 14 - "Advanced SSRS" - SSAS as SSRS data source, SSRS matrix reports, SSRS conditional formatting, SSRS parent/child reports, SSRS charts
Video 15 - "SSRS Management & Deployment" - SSRS configuration, SSRS authentication, SSRS deployment, SSRS Report Builder, SSRS farm, SSRS key management
All trademarks and copyrights are the property of their respective holders.
