MS SQL Server 2005: Designing a Business Intelligence Solution (2794E)
(more...)After his training students will be able to capture the business and technical requirements for a Business Intelligence solution architecture and describe the major stages and requirements of a Business Intelligence project lifecycle.
MS SQL Server 2005: Designing a Infrastructure (2786B)
(more...)This training provides database administrators the knowledge and skills to design a MS SQL ServerT 2005 database infrastructure. and focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The training also stresses the importance of capacity analysis and emphasizes the tradeoffs that need to be made during design.
MS SQL Server 2005: Designing a Reporting Solution Architecture (2797E)
(more...)The purpose of this training is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. The training focuses on the planning and design aspects of a reporting solution and does not teach you how to create reports or how to use the development tools provided with SQL Server 2005.
MS SQL Server 2005: Designing an Analysis Solution Architecture (2796E)
(more...)The purpose of this training is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. The training 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.
MS SQL Server 2005: Implementing and Maintaining Analysis Services (2791E)
(more...)Describe how SQL Server Analysis Services can be used to implement analytical solutions: create multidimensional analysis solutions and Secure an Analysis Services database, maintain a multidimensional Analysis Services solution...
MS SQL Server 2005: Implementing and Maintaining Integration Services (2792E)
(more...)The training discusses how to develop, deploy, and manage Integration Services packages.
MS SQL Server 2005: Querying and Processing SQL Server Data (50027)
(more...)Students will be able to write queries for use with MS SQL Server.
MS SQL Server 2008: Implementing a Database (6232A)
(more...)After completing this training,students will be able to create, manage and optimize tables, fields, index, databases, triggers, and views.
MS SQL Server 2008: Maintaining a Database (6231A)
(more...)Be able to install and configure MS SQL Server 2008 and use all tools necessary to manage database files, backup/restore databases, manage security, transfer data, automate administrative tasks, replicate data, maintain high availability and monitor SQL Server.
MS SQL Server 2008: What's new in SQL Server (6157E)
(more...)After completing these labs, students will be able to explain new development features in SQL Server 2008 and how they can benefit from these in application development. Explain new enhancements to database administration features in SQL Server 2008. Explain new features and enhancements in a SQL Server 2008 Business Intelligence platform. And to explain how SQL Server 2008 benefits from Visual Studio integration and provides enhancements to work with location data.
MS SQL Server 2008: Writing Queries Using Transact-SQL
(more...)This provides the technical skills required to write basic Transact-SQL queries for MS SQL Server 2008.