Год выпуска: 2013
Производитель: CBT Nuggets
Автор: Anthony Sequeira
Продолжительность: 06:54:43
Тип раздаваемого материала: Видеоурок
Язык: Английский
Стоимость: 1999 рублей
Описание:
Exam 70-452 retired July 31, 2013. However, this course retains value as a training resource.
Are you ready to design and plan database business solutions for your company? SQL Server 2008 offers database managers lots of built in controls and plenty of great opportunity to enhance their reputations.
In this CBT Nuggets video course you'll learn to plan the design and implementation of your SQL Server 2008 SSIS, SSAS and SSRS projects.
This training maps to Microsoft exam 70-452. After watching this course you'll be fully prepared to take the exam and earn Microsoft PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008. It's also your final towards earning SQL Server 2008 Business Intelligence MCITP Certification.
All trademarks and copyrights are the property of their respective holders.
[wpspoiler name="Подробное описание" ]
1. SSRS Architecture Overview (00:25:32)
SSRS architecture overview, simple report, SSRS drill-through reports, SSRS drill-down reports, SSRS sub-reports, SSRS subscriptions, SSRS data-driven subscriptions
2. SSRS & .NET (00:29:53)
SSRS .NET integration, SSRS web services, SSRS SOAP API, SSRS code-behind, SSRS URL access
3. SSRS Data Sets & Filters (00:29:07)
SSRS data sources, SSRS filters, SSRS query parameters, SSAS data source, SSAS filter, SSRS procedure data source
4. SSRS Templates, RDL & Advanced Reports (00:25:33)
SSRS templates, generating RDL, SSRS matrix reports, SSRS cross-tab reports, SSRS third-party controls
5. SSRS Deployment & Migration (00:29:31)
SSRS deployment scenarios, automating deployment, configuring SSRS deployment
6. Scaling SQL Server 2008 (00:21:50)
SQL Server editions, SSRS scale-out deployment, scaling SSIS, scaling SSAS
7. SQL Server 2008 Performance (00:34:52)
SQL Server 2008 performance, resource governor, performance counters, data management warehouse
8. Aggregations & Partitions (00:34:50)
SSAS aggregations, partitions, attribute hierarchies, dimension design
9. Data Mining Design (00:28:45)
SSAS data mining, staging data, mining algorithms, Microsoft Excel data mining add-on
10. SQL Server 2008 Advanced Data Mining (00:24:38)
SSAS refining testing model, SSAS DMX queries
11. SQL Server 2008 Sharepoint Integration (00:29:00)
SSRS SharePoint integration, reporting services SharePoint integration mode, deploying reports to SharePoint
12. SQL Server 2008 Visualization Tools (00:22:54)
Integrating SQL Server and SharePoint, SharePoint reports
13. SQL Server 2008 Auditing (00:29:04)
Benefits of SQL Server auditing, Setting up SQL Server auditing, auditing objects, database audit specifications, server audit specifications
14. SSAS -- Moving Packages (00:25:56)
SSAS Deployment, SSAS security, SSAS scheduling, dtexec
15. SSAS International Considerations (00:23:18)
SSAS international considerations, SSAS translations, SSAS currencies
[/wpspoiler]
