Book your MS50027 Querying and Processing SQL Server Data Using Microsoft SQL Server Training Course
This two day course is being run 16 times between Thursday 7th June 2012 and Thursday 13th December 2012 in Leeds, London, Manchester, Bristol, Reading, Edinburgh, Newcastle,
Book this course with us today from as little as £682.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 | ||
|---|---|---|---|---|---|---|
| Thursday 07 June 2012 | QA | Leeds |  | Save £192.50 | £682.50+VAT | |
| Thursday 14 June 2012 | QA | London | | Save £192.50 | £682.50+VAT | |
| Thursday 05 July 2012 | QA | Manchester | | Save £192.50 | £682.50+VAT | |
| Monday 09 July 2012 | QA | London | | Save £192.50 | £682.50+VAT | |
| Thursday 02 August 2012 | QA | Bristol | | Save £192.50 | £682.50+VAT | |
| Monday 13 August 2012 | QA | Manchester | | Save £192.50 | £682.50+VAT | |
| Thursday 06 September 2012 | QA | Manchester | | Save £192.50 | £682.50+VAT | |
| Thursday 06 September 2012 | QA | Reading | | Save £192.50 | £682.50+VAT | |
| Monday 10 September 2012 | QA | London | | Save £192.50 | £682.50+VAT | |
| Thursday 13 September 2012 | QA | Leeds | | Save £192.50 | £682.50+VAT | |
| Monday 17 September 2012 | QA | Edinburgh | | Save £192.50 | £682.50+VAT | |
| Monday 24 September 2012 | QA | Newcastle | | Save £192.50 | £682.50+VAT | |
| Thursday 01 November 2012 | QA | Manchester | | Save £192.50 | £682.50+VAT | |
| Monday 12 November 2012 | QA | London | | Save £192.50 | £682.50+VAT | |
| Monday 26 November 2012 | QA | Reading | | Save £192.50 | £682.50+VAT | |
| Thursday 13 December 2012 | QA | Leeds | | Save £192.50 | £682.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:
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.
Outline:
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."