Updating Your SQL 2005 Skills to SQL Server 2008

• Module 1: Introduction to SQL Server 2008



• The Evolution of SQL Server
• Preparing for SQL Server 2008
• After completing this module, students will be able to:



• Describe the evolution of SQL Server.
• Prepare for SQL Server 2008.
• Module 2: SQL Server 2008 Manageability Enhancements



• Configuration Servers
• Policy-Based Management
• After completing this module, students will be able to:



• Create and use a configuration server.
• Create and use policies.
• Module 3: SQL Server 2008 Performance Enhancements



• Managing Workloads with Resource Governor
• Monitoring Performance with the Data Collector
• Managing Performance with Plan Freezing
• After completing this module, students will be able to:



• Manage workloads with Resource Governor.
• Monitor performance with the Data Collector.
• Manage performance with Plan Freezing.
• Module 4: SQL Server 2008 Security Enhancements



• Encrypting Databases
• Auditing All Actions
• After completing this module, students will be able to:



• Encrypt databases.
• Audit all actions.
• Module 5: SQL Server 2008 Database Development Enhancements



• Developer Tool Enhancements
• Data Type Enhancements
• Working with Spatial Data
• After completing this module, students will be able to:



• Describe the developer tool enhancements in SQL Server 2008.
• Use the data type enhancements in SQL Server 2008.
• Work with spatial data.
• Module 6: SQL Server 2008 Availability Enhancements



• Always On Technologies
• Transactional Peer-to-Peer Replication
• After completing this module, students will be able to:



• Describe the SQL Server 2008 always on technologies.
• Implement transactional peer-to-peer replication.
• Module 7: SQL Server 2008 Data Warehousing Enhancements



• ETL Enhancements Using Partitioned Tables Optimizing Data Storage
• After completing this module, students will be able to:



• Describe the ETL enhancements in SQL Server 2008.
• Use partitioned tables.
• Optimize data storage.
• Module 8: SQL Server 2008 Reporting Services Enhancements



• Reporting Services Architecture and Management
• Authoring Reports
• Report Processing and Rendering
• After completing this module, students will be able to:



• Describe the Reporting Services architecture and management.
• Author reports.
• Understand report processing and rendering.
• Module 9: SQL Server 2008 Analysis Services Enhancements



• Multidimensional Analysis with SQL Server Analysis Services
• Data Mining with SQL Server Analysis Services
• After completing this module, students will be able to:



• Implement multidimensional analysis.
• Implement data mining.

Meer informatie?

Gerelateerde cursussen

In dezelfde cursusgroep bieden wij óók onderstaande opleidingen aan: