Book your Advanced T-SQL Querying & Programming Tuning for SQL Server 2005 & 2008 Training Course
This five day course is being run four times between Monday 18th June 2012 and Monday 17th December 2012 in London,
Book this course with us today from as little as £2,317.50 + 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.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Monday 18 June 2012 | QA | London |  | Save £257.50 | £2,317.50+VAT | |
| Monday 03 September 2012 | QA | London | | Save £257.50 | £2,317.50+VAT | |
| Monday 22 October 2012 | QA | London | | Save £257.50 | £2,317.50+VAT | |
| Monday 17 December 2012 | QA | London | | Save £257.50 | £2,317.50+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!
Summary:
You will learn how to tune your queries, how to develop efficient routines including user defined functions, stored procedures and triggers, work in multi-user environments with transactions and isolation levels, and use dynamic SQL securely and efficiently.
PreRequisites:
- At least one year of T-SQL querying and programming experience in SQL Server
Objectives:
DELEGATES WILL LEARN HOW TO
- Understand logical query processing
- Understand SQL Server’s internal data structures
- e able to analyze and tune query performance
- Be able to analyze query execution plans
- Be able to solve complex querying and programming problems
- Think in terms of sets
- Be able to compare set based and cursor based solutions
- Know how to handle date and time data
- Understand compilations, recompilations and reuse of execution plans
- Understand transactions and concurrency aspects of database programming
- Know how to handle hierarchical data and write recursive queries
- Be familiar T-SQL enhancements in SQL Server 2005 and 2008
Outline:
Module 01: Logical Query Processing
- Logical Query Processing Order
- Logical Query Processing Example
- Phase Details
- Set Operations
Module 02: Query Tuning
- Internals and Index Tuning
- Temporary Tables
- Sets vs. Cursors
- Query Tuning with Query Revisions
Module 03: Subqueries, Ranking Functions, Joins and Set Operations
- Subqueries
- Analytical Ranking Functions
- Joins
- Set Operations
- LAB 03A
Module 04: Aggregating and Pivoting Data
- The OVER Clause
- Tie Breakers
- Running Aggregations
- Pivoting and Unpivoting Data
- Custom Aggregations
- Histograms
- Grouping Sets
- LAB 04A
Module 05: TOP and APPLY
- TOP
- APPLY
- LAB 05A
Module 06: Data Modification
- Inserting Data
- Deleting Data
- Updating Data
- Merging Data
- The OUTPUT Clause
- LAB 06A
Module 07: Datatype Related Problems
- Date and Time Manipulation
- Datatype Enhancements
- LAB 07A
Module 08: Programmable Objects
- Dynamic SQL
- Views
- User Defined Functions
- Stored Procedures
- Triggers
- Transactions and Concurrency
- Exception Handling
- LAB 08A
Module 09: Graphs, Trees and Hierarchies
- Graphs, Described
- Common Requests against Graphs
- Enumerated Paths Model
- Nested Sets Model
- Recursive Queries
- The HIERARCHYID Datatype
- LAB 09A
Description:
You will learn how to tune your queries, how to develop efficient routines including user defined functions, stored procedures and triggers, work in multi-user environments with transactions and isolation levels, and use dynamic SQL securely and efficiently.
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.