Advanced SQL with Stored Procedures Course

Upon completion of this course, the participant will be able to:
> Utilize stored procedures and triggers within a Windows SQL Server environment

Topics provide the attendee with the ability to understand:
that performance needs effective design
the effective use and creation of Triggers
how to create and utilize Stored Procedures
the performance advantages of Stored Procedures
the security advantages of using Stored Procedures
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