Whats New in SQL Server 2008 - Clinic & Hands-on Lab
Short course
In Bath
Description
-
Type
Short course
-
Methodology
Inhouse
-
Location
Bath
-
Duration
1 Day
After completing this course, 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; explain how SQL Server 2008 benefits from. Suitable for: This course introduces students to the new feature available in SQL Server 2008. The series focus on new features and components in the relational database, business intelligence and development environment. It is intended for SQL Server administrators and developers who have experience working with previous editions of SQL Server.
Facilities
Location
Start date
Start date
About this course
Before attending this course, students must have the following pre-requisites:Experience developing applications on SQL Server 2000/2005.Experience managing and administering databases on SQL Server 2000/2005.
Reviews
Course programme
This course introduces students to the new feature available in SQL Server 2008. The series focus on new features and components in the relational database, business intelligence and development environment. It is intended for SQL Server administrators and developers who have experience working with previous editions of SQL Server.
Pre-Requisites
Before attending this course, students must have the following pre-requisites:Experience developing applications on SQL Server 2000/2005.Experience managing and administering databases on SQL Server 2000/2005.
Purpose
After completing this course, 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; explain how SQL Server 2008 benefits from Visual Studio integration and provides enhancements to work with location data.
Course outline
- SQL Server Platform Vision
- Enterprise Data Platform
- Dynamic Development
- Beyond Relational
- Pervasive Insight
- This module describes the SQL Server 2008 platform vision.
- The new features added to SQL Server 2008.
- This module describes the enhancements in the SQL Server Enterprise Data Platform.
- High Availability Enhancements
- Hardware Support
- Secure Data Features
- Policy based management
- System Auditing Enhancements.
- This module walks students through the development enhancements of the SQL Server Database Platform.
- .NET Platform integration
- Build data synchronizing applications using the .NET Compact Framework 3.5 and the .NET Entity Framework.
- This module describes new features that go beyond the relational engine, available in SQL Server 2008.
- FILESTREAM storage
- Extensions to working with user defined types
- Database enhancements that include new datatypes such as data/time data.
- This module describes new SQL Server 2008 features for Business Intelligence.
- New Report Designer
- Integration with Virtual Earth and Location data tracking
- Enhancements to Analysis Services
- New features in Integration Services.
Whats New in SQL Server 2008 - Clinic & Hands-on Lab