50027 Querying and Processing SQL Server Data with SQL Statements

This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

Lesson 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

Lesson 2: Working with Views

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

Lesson 3: Advanced SQL Query Tactics

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

Lesson 4: Data Manipulation Statements

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

Lesson 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

Lesson 6: Task-Oriented Queries

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

• Charleston, SC - May 21, 2012
• Columbia, SC - May 21, 2012
• Greenville, SC - May 21, 2012
• Greensboro, NC - May 21, 2012
• Charleston, WV - May 21, 2012
• West Valley City, UT - May 21, 2012
• Bethlehem, PA - May 21, 2012
• Garfield Heights, OH - May 30, 2012
• Garfield Heights, OH - July 2, 2012
• Charleston, SC - July 16, 2012
• Columbia, SC - July 16, 2012
• Greenville, SC - July 16, 2012
• Charleston, WV - July 16, 2012
• Greensboro, NC - July 23, 2012
• Urbandale, IA - July 23, 2012
• Charleston, SC - September 10, 2012
• Columbia, SC - September 10, 2012
• Greenville, SC - September 10, 2012
• Charleston, WV - September 10, 2012
• Greensboro, NC - September 17, 2012
• Urbandale, IA - September 17, 2012
• Charleston, SC - November 5, 2012
• Columbia, SC - November 5, 2012
• Greenville, SC - November 5, 2012
• Charleston, WV - November 5, 2012
• Greensboro, NC - November 12, 2012
• Mechanicsburg, PA - November 12, 2012
• Urbandale, IA - November 12, 2012
• Charleston, SC - December 31, 2012
• Columbia, SC - December 31, 2012