50027A: Querying and Processing SQL Server Data Using 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