Module 2: Working with Views Module 3: Advanced SQL Query Tactics Module 4: Data Manipulation Statements Module 5: Working with Procedures Module 6: Task-Oriented Queries

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

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

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

• 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

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

• Establish baseline knowledge required elsewhere in course