Book your MS50027 Querying and Processing SQL Server Data Using Microsoft SQL Server Training Course

This two day course is being run 23 times between Monday 20th February 2012 and Monday 26th November 2012 in Newcastle, Bristol, Glasgow, Manchester, Edinburgh, Leeds, London, Birmingham, Reading,

Book this course with us today from as little as £647.40 + 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 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 20 February 2012NewcastleSave £182.60£647.40+VAT
Monday 27 February 2012BristolSave £182.60£647.40+VAT
Monday 27 February 2012GlasgowSave £182.60£647.40+VAT
Monday 05 March 2012ManchesterSave £182.60£647.40+VAT
Monday 12 March 2012EdinburghSave £182.60£647.40+VAT
Tuesday 20 March 2012LeedsSave £182.60£647.40+VAT
Thursday 22 March 2012LondonSave £182.60£647.40+VAT
Thursday 22 March 2012BirminghamSave £182.60£647.40+VAT
Tuesday 10 April 2012ReadingSave £182.60£647.40+VAT
Monday 30 April 2012GlasgowSave £182.60£647.40+VAT
Tuesday 08 May 2012LondonSave £182.60£647.40+VAT
Monday 14 May 2012ManchesterSave £182.60£647.40+VAT
Thursday 07 June 2012BristolSave £182.60£647.40+VAT
Thursday 07 June 2012EdinburghSave £182.60£647.40+VAT
Thursday 07 June 2012LeedsSave £182.60£647.40+VAT
Thursday 05 July 2012ManchesterSave £182.60£647.40+VAT
Monday 09 July 2012LondonSave £182.60£647.40+VAT
Thursday 06 September 2012ManchesterSave £182.60£647.40+VAT
Thursday 06 September 2012ReadingSave £182.60£647.40+VAT
Monday 10 September 2012LondonSave £182.60£647.40+VAT
Thursday 01 November 2012ManchesterSave £182.60£647.40+VAT
Monday 12 November 2012LondonSave £182.60£647.40+VAT
Monday 26 November 2012ReadingSave £182.60£647.40+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: 

Elements of this syllabus are subject to change.

Alto's Querying and Processing SQL Server Data Using Microsoft SQL Server concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

PreRequisites: 

Before attending this course, students must:

  • At minimum be comfortable working with a complex user interface like SQL Server Management Studio
Audience: 

The target audience for this clinic includes the following:

  • IT Professionals who will be writing queries for use with Microsoft SQL Server. Non-technical “power users” will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.
Objectives: 

Students will be able to write queries for use with Microsoft SQL Server.

Module 1: Quick Intro to SQL Query Basics

  • Establish baseline knowledge required elsewhere in course
  • Elements of the SELECT statement
  • Optional clauses
  • Working with NULL values
  • Working with Dates

Module 2: Working with Views

  • Nature and purpose of views
  • Creating and modifying view
  • Limitations and cautions

Module 3: Advanced SQL Query Tactics

  • Scalar and vector aggregations
  • Everything you need to know about JOINS
  • UNION queries
  • GROUP BY queries
  • Sub-queries

Module 4: Data Manipulation Statements

  • Insert statements
  • Update statements
  • Delete statements
  • Manipulation through views and over JOINs

Module 5: Working with Procedures

  • Nature and purpose of stored procedures and functions
  • Calling stored procedures for effect
  • Passing input parameters to stored procedures
  • Calling procedures that return data
  • Calling built-in functions
  • Calling user-defined functions

Module 6: Task-Oriented Queries

  • Finding unmatched or missing records
  • Finding duplicates
  • Calculating running sums
  • Changing a primary key

Description: 

Elements of this syllabus are subject to change.

Alto's Querying and Processing SQL Server Data Using Microsoft SQL Server concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

Additions Info: 
Encrypted pdf
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
"The course is perfect if you have either no understanding, or a basic understanding of SQL. The course is presented in a very clear way which makes confusing SQL statements more understandable. The elements surrounding the creation of joins have proven very useful and will impact the way I conduct my work in the future."
- Andrew Chenery
- C.E.
- M.B.

Software Vendor

IT Technical

Business Skills