50027 Querying and Processing SQL Server Data Using Microsoft SQL Server

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

•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.

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

Microsoft SQL Server 2005 Implementation and Maintenance Expert Encore MCTS: DBA

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

Infero Training Ltd is based in the Lace Market in Nottingham. Training courses take place at the following locations including Nottingham, Derby, Loughborough, Mansfield, Chesterfield, Burton-on-Trent, Lincoln, Leicester, Sheffield, Stoke-on-Trent, Tamworth, Wolverhampton, Walsall, Birmingham, Solihul, Coventry, Nuneaton, Peterborough, Grantham.