50027 - Querying and Processing SQL Server Data Using Microsoft SQL Server

About this Course

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.

Audience Profile

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.

At Course Completion

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

Course 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 

Before attending this course, students must:At minimum be comfortable working with a complex user interface like SQL Server Management Studio.