Book your MS2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Training Course
This three day course is being run 66 times between Tuesday 14th February 2012 and Tuesday 11th December 2012 in Edinburgh, Exeter, London, Leeds, Aberdeen, Bath, Stockport, Bristol, Hinckley, Newcastle, Reading, Glasgow, Manchester, Birmingham,
Book this course with us today from as little as £868.00 + 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 MicrosoftSee all courses provided by QA
See all courses provided by F1 Computing
See all courses provided by Global Knowledge
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 | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Tuesday 14 February 2012 | Edinburgh |  | Save £343.20 | £1,216.80+VAT | |
| Tuesday 14 February 2012 | Exeter | | Save £343.20 | £1,216.80+VAT | |
| Monday 20 February 2012 | London | | Save £57.50 | £1,092.50+VAT | |
| Monday 27 February 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 28 February 2012 | Leeds | | Save £343.20 | £1,216.80+VAT | |
| Monday 05 March 2012 | Aberdeen | | Save £343.20 | £1,216.80+VAT | |
| Monday 05 March 2012 | Bath | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 06 March 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 06 March 2012 | Stockport | | Save £343.20 | £1,216.80+VAT | |
| Monday 12 March 2012 | London | | Save £217.00 | £868.00+VAT | |
| Monday 19 March 2012 | Bristol | | Save £343.20 | £1,216.80+VAT | |
| Monday 19 March 2012 | London | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 27 March 2012 | Hinckley | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 27 March 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Monday 02 April 2012 | Leeds | | Save £343.20 | £1,216.80+VAT | |
| Monday 02 April 2012 | Newcastle | | Save £343.20 | £1,216.80+VAT | |
| Monday 02 April 2012 | Reading | | Save £343.20 | £1,216.80+VAT | |
| Monday 02 April 2012 | Bath | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 03 April 2012 | Edinburgh | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 03 April 2012 | Glasgow | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 10 April 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Monday 16 April 2012 | London | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 24 April 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 01 May 2012 | Leeds | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 08 May 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 08 May 2012 | London | | Save £217.00 | £868.00+VAT | |
| Wednesday 09 May 2012 | Bath | | Save £57.50 | £1,092.50+VAT | |
| Monday 14 May 2012 | Leeds | | Save £217.00 | £868.00+VAT | |
| Tuesday 15 May 2012 | Exeter | | Save £343.20 | £1,216.80+VAT | |
| Monday 21 May 2012 | London | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 29 May 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Wednesday 06 June 2012 | Bath | | Save £57.50 | £1,092.50+VAT | |
| Monday 11 June 2012 | Aberdeen | | Save £343.20 | £1,216.80+VAT | |
| Monday 11 June 2012 | Birmingham | | Save £343.20 | £1,216.80+VAT | |
| Monday 11 June 2012 | Bristol | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 12 June 2012 | Hinckley | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 12 June 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Monday 18 June 2012 | London | | Save £57.50 | £1,092.50+VAT | |
| Tuesday 19 June 2012 | Glasgow | | Save £343.20 | £1,216.80+VAT | |
| Monday 25 June 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 10 July 2012 | Edinburgh | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 10 July 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 24 July 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 31 July 2012 | Glasgow | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 31 July 2012 | Newcastle | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 07 August 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 21 August 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Monday 03 September 2012 | Aberdeen | | Save £343.20 | £1,216.80+VAT | |
| Monday 03 September 2012 | Bristol | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 04 September 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 11 September 2012 | Hinckley | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 18 September 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Monday 01 October 2012 | Birmingham | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 02 October 2012 | Glasgow | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 02 October 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 09 October 2012 | Edinburgh | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 16 October 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 30 October 2012 | Newcastle | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 06 November 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 13 November 2012 | London | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 27 November 2012 | Glasgow | | Save £343.20 | £1,216.80+VAT | |
| Monday 03 December 2012 | Aberdeen | | Save £343.20 | £1,216.80+VAT | |
| Monday 03 December 2012 | Bristol | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 04 December 2012 | Manchester | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 11 December 2012 | Hinckley | | Save £343.20 | £1,216.80+VAT | |
| Tuesday 11 December 2012 | London | | Save £343.20 | £1,216.80+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 OutlinePreRequisites:
Before attending this course, students must have:
- Knowledge of data and intergrity concepts.
- Core Windows Server skills.
- Relational database design skills.
- Programming skills.
Audience:
This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.
Objectives:
After completing this course you should be able to:
- Describe the uses of and ways to execute the Transact-SQL language.
- Use querying tool.
- Write SELECT queries to retrieve data.
- Group and summarise data by using Transact-SQL.
- Join data from multiple tables.
- Write queries that retrieve and modify data by using subqueries.
- Modify data in tables.
- Query text fields with full-text search.
- Describe how to create programming objects.
- Use various techniques when working with complex queries.
Module 1: Getting Started with Databases and Transact-SQL in SQLServer 2008
Module 2: Querying and Filtering Data
Module 3: Grouping and Summarizing Data
Module 4: Joining Data from Multiple Tables
Module 5: Working with Subqueries
Module 6: Modifying Data in Tables
Module 7: Querying Metadata, XML, and Full-Text Indexes
Module 8: Using Programming Objects for Data Retrieval
Module 9: Using Advanced Querying Techniques
Description:
This 3-day instructor led course provides students wuth the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.
Additions Info:
Encrypted pdf
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.
Global Knowledge
Global Knowledge offer global IT training and Business training courses at your fingertips. Offering more than 1000 courses focusing mainly on Cisco, Microsoft, Nortel and Project Management- Global Knowledge boast a wide variety of courses.
The variety of courses is due to the recognition that learning is not just attending training courses but is crucial to organisation success.
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.