Microsoft Certification Courses From Activia
Querying and Processing SQL Server Data Using Microsoft SQL Server
A Two-Day Training Course
Your training is easier with Activia because we have:
Authorised Microsoft Training Course
This is an authorised Microsoft training course, delivered by certified Microsoft trainers at fully equipped centres using the latest equipment, software and course materials. There is no better way to undertake your training, to maximise your learning and ensure the highest marks possible in your certification exams.
Elements of the syllabus for this 2-day course are subject to change.
Who Should Attend
The target audience for this clinic is 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.
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
After completing this course, delegates will be able to write queries for use with Microsoft SQL Server.
Microsoft Course 50027
Regus House, 268 Bath Road
Slough, SL1 4DX
Sales: 0845 230 6150
Service: 0845 230 6159
Accounts: 0845 230 6157
With our quality accreditations for ISO9001, IITT, ILM and the ILP, and a uniquely flexible service, you can be sure that your MCSA, MCTS and MCITP certification courses will get the results you need, at the prices you want.
With seventeen fully equipped training centres , Activia should be your first choice for courses for Microsoft Certification wherever you are in the UK.
We provide Microsoft Mcsa MCTS & MCITP Certified Courses courses in the following locations:
For in house delivery of Microsoft Mcsa MCTS & MCITP Certified Courses, you can expect the same standard of training and service for your MS Certification training classes as you get at our centres, conveniently delivered at your offices.
To book your in-house certification courses for MCSA, MCTS and MCITP, you need look no further than Activia.
Click for more about MS Certification training courses UK from Activia