SQL Server 2008 Developer Workshop

London

Tuesday, 01 November 2011

SQL Server 2008 Developer Workshop

Tuesday, 01 November 2011 09:00 - Wednesday, 02 November 2011 17:00 (GMT)

Progressive Training Centre
15-19 Risborough Street
Southwark
London
SE1 0HG
United Kingdom
020 313 73958

Tel: 07976877845 Email Us

Overview

A 2-day interactive workshop that drills down into new features, tools and best practices for developers working with SQL Server 2008 or 2008 R2.

Instructor

This course will be taught by Gavin Payne. Gavin is a Senior Consultant for Coeo Ltd, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for all versions of SQL Server.

Why attend?

This popular workshop will broaden and deepen your understanding of SQL Server’s newest and upgraded development features.

You will gain new knowledge and confidence through the right balance of theory, insights and hands-on experience.

Theory – we combine presentation-based content and instructor-led demos to introduce topics and explain the detail behind the concepts.

Insights – we enhance the theory with nuggets of real world experience gained from implementing, optimising and performance tuning SQL Server 2008 for our clients.

Hands-on Labs – try out the new features for yourself on your own instance of SQL Server in several supported lab sessions throughout the two days.

Who is it for?

This level 300 workshop is for development professionals who create or maintain database applications, schemas or queries. Attendees should be familiar with developing databases and queries with SQL Server and its T-SQL query language.

What you will learn

Day 1:
On the first day we will focus on changes to the most commonly used parts of SQL Server: client tools, T-SQL query language and database table design.

Features covered will include:
• Changes to SQL Server Management Studio
• T-SQL assignment operators and row constructors
• The new merge command
• Enhancements to date and time storage
• Indexing enhancements
• Data compression

Day 2:
On day two we will look at new features in SQL Server 2008 and R2 for handling non-relational data and track changes to data within databases. We will also explore SQL Server’s integration with the .Net developer world by reviewing SQL Server’s support for XML data manipulation and CLR assemblies.

Features covered will include:
• Manipulating spatial and hierarchical data
• Tracking data changes
• Using full-text indexing
• XML and CLR support

Cost £990 + VAT