Microsoft SQL Server 2008 - Business Intelligence Development (70-448)
-
5
day(s)
This course covers these SQL Server 2008 topics: Create SSIS packages; troubleshoot data flow and control flow, Configure, debug, and deploy SSIS solutions, Develop SSAS cubes for OLAP and data mining services, Implement custom logic with MDX, Optimize storage design and query performance, Create SSRS reports; enable interactivity; write custom code, Manage the report environment, Configure security features for SSIS, SSAS, and SSRS
|
Microsoft SQL Server 2008 - Database Development (70-433)
-
5
day(s)
This course covers these SQL Server 2008 topics: Create and manage database objects, Query and modify data; implement subqueries and CTEs, Optimize table structures and data integrity, Create stored procedures, functions, and triggers, Manage transactions, error handling, and change tracking, Tune query performance, Implement database mail, full-text search, Service Broker, scripts, Work with XML and SQLCLR.
|
Microsoft SQL Server 2008 - Implementation and Maintenance (70-432)
-
5
day(s)
This course covers these SQL Server 2008 topics: Configure, manage, back up, and restore databases, Create a partitioned table, index, or indexed view, Configure services and components to manage your environment, Help prevent unauthorized access at each security infrastructure layer, Design and deploy high-availability solutions, Manage SQL Server Agent jobs, alerts, and operators, Identify service, concurrency, and job execution problems.
|