Advanced SQL and Triggers Course

Upon completion of this course, the participant will be able to:
> Apply Triggers in a Windows SQL Server environment

The effective use and creation of Triggers
The 'thought process' of developing an effective query
The use of the elusive ALL, ANY, and EXIST parameters
The efficiencies and the inefficiencies in the SQL language
What correlation variables can do to simplify query processing
When SCALAR and AGGREGATE FUNCTIONs should be used
How to use the many types of sub query constructs most effectively
When which one of the four JOIN types should be used for efficiencies
Boolean constructs, CASE constructs, and multiple condition constructs
How NULLs are helpful to reduce processing time and query complexity
When to utilize the 'nested table expression' to improve query performance
What and when the UNION operation is most effective vs. other techniques
The runtime LOCKING issues with INSERT, UPDATE and DELETE operations
When to (and not to) use DISTINCT, IN, LIKE, BETWEEN and other predicates
How DATE and TIME data types can effectively be used for audits and compliance