 |
Microsoft SQL 2005 BI
O Microsoft SQL Server 2005 é o mais completo produto de bases de dados e análise, que hoje disponibiliza a próxima geração de soluções dimensionáveis de comércio eletrônico na linha empresarial e de armazenamento de dados para sua empresa. Para que se possa aprender a configurar e usar todos estes recursos a Microsoft disponibiliza esta linha de treinamentos abaixo:
|
|
MS2792- Implementing and Maintaining Microsoft SQL Server 2005 Integration Services Elements of this syllabus are subject to change. This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. |
|
MS2793- Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Elements of this syllabus are subject to change. This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. |
|
MS2791- Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services Elements of this syllabus are subject to change. This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. |
|
MS2794- Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 Elements of this syllabus are subject to change. The purpose of this two-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The first day focuses on foundational standards and practices for the enterprise. The second day focuses on a project-specific lifecycle for capturing requirements and deriving a solution architecture. This is the first course in the Business Intelligence curriculum and will serve as the entry point for other courses in the curriculum. |
|
MS2795- Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services Elements of this syllabus are subject to change. The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution. The course focuses on the planning and design aspects of an ETL solution and does not teach students how to create SSIS packages or how to use the development tools provided with SQL Server 2005. |
|
MS2796- Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Elements of this syllabus are subject to change. The purpose of this three day course is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production. Students will also be taught to develop custom functionality and optimize a multidimensional solution. The course focuses on the planning and design aspects of an analysis solution and does not teach students how to create Analysis Services database objects or how to use the development tools provided with SQL Server 2005. |
|
MS2797- Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services The purpose of this 2-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. Students will go through the entire process-from identifying report data to promoting the reporting solution to production. Students will scale a reporting solution. Students will also be taught best practices for collaborating with application developers to integrate applications and reporting services. |
|
|||||