Back

Microsoft Database SQL Server 2008 Business Development 70-448

Business Intelligence Development and Maintenance

Julie Johnson

CBT Nuggets Trainer

"Hello, and thank you for giving me the opportunity to share with you my technical knowledge. I have a passion for programming languages which dates back to computer camp in the fourth grade! (Aut... Read more.

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.

All trademarks and copyrights are the property of their respective holders.
  • Videos
  • Purchase Options
Title Duration
 
SQL Server 2008 SSIS Overview
SQL Server 2008 SSIS overview, SSIS architecture, SSIS example
00:22:26
 
SSIS: More ETL
SSIS looping, variables, package configurations, sorting, writing to flat file
00:25:23
 
SSIS: Troubleshooting & Error Handling
SSIS loggin, error output, data viewer, debugger, checkpointing, transactions
00:24:19
 
SSIS: Deployment
SSIS deployment utility, executing packages, dtutil, dtexec, package protection levels
00:23:31
 
SSIS: Handling Events and Custom .NET Code
SSIS handling events, event scope, event types, custom SSIS .NET code
00:27:48
 
SSAS: Dimensions, Measures & Cubes
SSAS benefits, SSAS architecture, SSAS dimensions, measures, cubes
00:25:52
 
SSAS: Dimension Attributes
SSAS dimension attributes, named calculations, attribute hierarchies, attribute relationships, columns, custom sorting
00:25:16
 
SSAS: Dimension Relationships
SSAS referenced relationship, self referencing fact/dimension table, many to many relationships, star schema, snowflake schema
00:28:10
 
More SSAS Features
SSAS buckets, calculated attributes, named sets
00:27:46
 
SSAS: Key Performance Indicators
SSAS Key performance indicators, KPI, KPI trending, parent KPIs
00:26:01
 
SSAS: More Cube Options
SSAS drill-through actions, translations, perspectives, partitions and aggregations
00:31:43
 
SSAS Data Mining
SSAS data mining, data mining process, predicting behavior, decision trees, clustering
00:32:58
 
Introduction to SSRS
SSRS architecture, SSRS report, SSRS parameters, SSRS headers and footers, SSRS pagination, embedding images in SSRS report
00:29:39
 
Advanced SSRS
SSAS as SSRS data source, SSRS matrix reports, SSRS conditional formatting, SSRS parent/child reports, SSRS charts
00:36:30
 
SSRS Management & Deployment
SSRS configuration, SSRS authentication, SSRS deployment, SSRS Report Builder, SSRS farm, SSRS key management
00:34:05
Total Series Duration: 7 hours
Which option is right for you?
Buy a Single Series
"Focus your training on one series, for one month, for one low price."
StreamOne
StreamOne SUBSCRIPTION
Includes ExamPrep
StreamOne is your monthly option for streaming access to Microsoft Database SQL Server 2008 Business Development 70-448. One multi-user license gives you and a small team access to one full series. Cancel at any time. A StreamOne subscription gives you plenty of time to explore the benefits of CBT Nuggets, while paying for just the specific series you want.
MULTI-USER
$199
per license
$499
EDM
Download
Download Microsoft Database SQL Server 2008 Business Development 70-448.
$499
DVD
DVD
Have Microsoft Database SQL Server 2008 Business Development 70-448 delivered on DVD.
 
Buy a Certification Package
"Secure your future with professional recognition via industry certification. Certification Packages give you the training you need to pass those certification exams."
Get Certified. Cisco, Microsoft, CompTIA and more.
Inclusive pricing. Package includes training videos and any relevant and available exam-prep.
Image
Certification Packages
Professional Recognition from Renowned IT Organizations
CBT Nuggets offers certification packages to help you achieve valuable professional recognition. Get the most popular certifications from Cisco, Microsoft and others. IT certification after training with CBT Nuggets will help you do a lot more than put letters after your name. Begin your path to a better job and a better future today!
  • Certification Package
    $599
    4 MONTHS STREAMING
    Add to Cart
    MCITP: SQL Server 2008 Business Intelligence Developer 2008
    Are you ready to design and plan database business solutions for your company? SQL Server 2008 offers database training about built in controls and plenty of SQL training to enhance your Microsoft certification. In this CBT Nuggets Microsoft training, you'll learn to plan the design and implementation of your SQL Server 2008 SSIS, SSAS and SS... Learn more...
Buy an Annual Subscription to Everything IT
"Eliminate your limitations. An IT Nuggets streaming subscription puts our complete IT training library at the fingertips of IT pros."
All topics. From admin to programming.
Image
IT Nuggets
Productivity for Companies and IT Advancement for Professionals
Get access to better training, and never lose it, with an IT Nuggets subscription. IT Nuggets is a multi-user product that supports all levels of your IT department, even as employees come and go. One locked-in rate gets you access to our IT training catalog, which is updated regularly and automatically at no additional charge. As long as your subscription is maintained, the rate won't change, and neither will your budget. Our full IT library is designed for Pros to keep current for career advancement and companies that want their IT Pros to reach their full potential.
YEARLY
MULTI-USER
$1999
per license
Bookmarks

No Bookmarks