Book your MS6158A Updating Your SQL Server 2005 Skills to SQL Server 2008 Training Course

This three day course is being run 18 times between Monday 13th February 2012 and Wednesday 21st November 2012 in London, Bath, Edinburgh, Manchester, Stockport,

Book this course with us today from as little as £908.70 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.

See all courses by the manufacturer Microsoft
See all courses provided by F1 Computing
See all courses provided by QA

Expert Help

If you would like
advice, or to book, call
one of our experts on
01920 460232

Open: 9am - 5:30pm
Monday- Friday

Locations/dates for this course
DateLocationRatingPrice
Monday 13 February 2012LondonSave £57.50£1,092.50+VAT
Monday 27 February 2012BathSave £57.50£1,092.50+VAT
Monday 12 March 2012LondonSave £57.50£1,092.50+VAT
Monday 19 March 2012EdinburghSave £256.30£908.70+VAT
Monday 26 March 2012BathSave £57.50£1,092.50+VAT
Monday 02 April 2012LondonSave £256.30£908.70+VAT
Wednesday 11 April 2012ManchesterSave £256.30£908.70+VAT
Wednesday 11 April 2012LondonSave £57.50£1,092.50+VAT
Monday 23 April 2012BathSave £57.50£1,092.50+VAT
Monday 14 May 2012LondonSave £57.50£1,092.50+VAT
Monday 28 May 2012BathSave £57.50£1,092.50+VAT
Monday 11 June 2012LondonSave £57.50£1,092.50+VAT
Wednesday 04 July 2012LondonSave £256.30£908.70+VAT
Wednesday 04 July 2012ManchesterSave £256.30£908.70+VAT
Wednesday 18 July 2012EdinburghSave £256.30£908.70+VAT
Wednesday 03 October 2012StockportSave £256.30£908.70+VAT
Monday 08 October 2012LondonSave £256.30£908.70+VAT
Wednesday 21 November 2012EdinburghSave £256.30£908.70+VAT
 

Book your course now with Coursebookers!

Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.

Remember:

  • Not only are we great value, we can also boast no booking fees
  • Human administrators make booking & coordination simple and painless
  • Coursebookers is vendor neutral we can offer unbiased and independent advice
  • If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
  • We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course Outline

Summary: 

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

PreRequisites: 

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

Audience: 

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

Objectives: 

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.

Module 1: Introduction to SQL Server 2008

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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

Lessons

  • 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
Description: 

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008. This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

F1 Computing

F1 Computing have 20 years of experience in developing their CRM product, Pro-ACTION, is now used to build and deploy solutions for customers.
F1 Computing aim to meet the requirements of your company and arm you and your employees with the skills to make your business a success. Through many years of refining their courses, F1 computing have established a name for themselves, as well as a great relationship with their clients.

QA

QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.

Want to leave your own testimonial? click Here
No Testimonials have been left for this course.

Software Vendor

IT Technical

Business Skills