Updating Your SQL 2005 Skills to SQL Server 2008 (partnercursus)

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

Doelgroep

This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

Voorkennis

Wij adviseren onderstaande voorkennis:

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

Doel

After completing this course, students will be able to:

Describe the new features of SQL Server 2008.
Manage SQL Server 2008.
Optimize SQL Server 2008.
Secure a SQL Server 2008 Database.
Develop databases with SQL Server 2008.
Create and maintain highly available SQL Server 2008 databases.
Create and use a SQL Server 2008 data warehouse.
Use SQL Server 2008 Reporting Services.
Use SQL Server 2008 Analysis Services.

Onderwerpen

De cursus Updating Your SQL 2005 Skills to SQL Server 2008 behandelt de volgende onderwerpen:

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?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten wanneer er weer een sessie gepland wordt?

Vraag informatie aan

	Partnercursus
Lesmethode	Klassikaal
Cursusduur	3 dagen
Cursuscode	M6158
Locatie	Amsterdam-1	Nieuwegein	Op uw locatie?
Brutoprijs	€ 2.223,08	€ 2.223,08	Vraag info aan
Actieprijs (info) (bestellen vóór 30-6-2012)	€ 1.372,75	€ 1.372,75
Strippen (info) Kaartnr :	Vul links uw kaartnummer in of Vraag het ons	Vul links uw kaartnummer in of Vraag het ons
Cursusdata (*)	Vraag info aan	Vraag info aan	Vraag info aan
Inschrijven	Vraag info aan	Vraag info aan	Vraag info aan

Gerelateerde cursussen

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

De cursus BizTalk 2010 Solution Development, Deployment & Administration.
De cursus Database Design.
De cursus Examentraining 70-432: MCTS SQL Server 2008 Implementation and main....
De cursus Implementing a Data Warehouse with Microsoft SQL Server 2012.
De cursus Implementing a Microsoft SQL Server 2008 Database (M6232).
De cursus Implementing Data Models and Reports with Microsoft SQL Server 2012.
De cursus Maintaining a Microsoft SQL Server 2008 Database (M6231).
Het traject MCTS SQL Server 2008, Implementation and Maintenance.
De cursus Microsoft SQL Server administration voor Oracle DBA (5 dagen).
De cursus Microsoft SQL Server administration (5 dagen).
De cursus Microsoft SQL Server Performance.
De cursus Microsoft Transact-SQL: programmeren van objecten.
De cursus Microsoft Transact-SQL: queries en datamanipulatie.
De cursus Microsoft Transact-SQL: voor Oracle gebruikers.
De cursus Oplossingen bouwen met BizTalk 2009 Server.
De cursus SQL Server Business Intelligence: Analysis en Reporting.
De cursus SQL Server Business Intelligence: Integration, Analysis en Reporting.
De cursus SQL Server Integration Services (SSIS).
De cursus What′s new in SQL Server 2012 Business Intelligence Workshop.
De cursus What′s new in SQL Server 2012 Workshop.

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.

Vul uw kaartnummer in en u krijgt het aantal strippen te zien wat u moet afrekenen bij deze cursus.