Certificate Authentication

Review of Structured Query Language

• DQL, DML, DDL
• The GROUP BY, HAVING Clause
• Sub-queries and Correlated Sub-queries
• Advanced Update & Delete Statements
• Sub-queries
• Correlated Sub-queries

Procedural Programming

• Variables
• Control-Of-Flow Statements
• IF, WHILE, CASE, GOTO, RETURN

Managing Errors

• Responding To Errors
• RAISERROR
• PRINT

Using Transactions

• Introduction To Transactions
• Transaction Isolation Levels
• Deadlocks
• Transactional Error Handling

Implementing Cursors

• Declaring Cursors
• OPEN, FETCH, CLOSE
• DEALLOCATE
• CURRENT OF

Stored Procedures

• Creating Stored Procedures
• Passing values into a Stored Procedure
• Returning Information From Stored Procedures
• Altering Stored Procedures

Triggers

• Creating Triggers
• Transactional Error Handling
• Using Inserted and Deleted Tables