Two Days • Instructor-led
This is the third course in the SQL series. In this class you will learn how programming objects work in SQL Server and tackle key topics such as error handling.
Course Outline
Constraints
- Data Types
- Primary Keys
- Check Constraints
- Unique Constraints
- Default Constraints
Triggers
- Insert Trigger
- Update Triggers
- Delete Triggers
Views
- Creating Views
- Altering Views
- Nesting Views
- View Options
Stored Procedures
- Basic Stored Procedures
- Stored Procedures that return values
- Stored Procedures with Output values
- Stored Procedure Options
- Table-Valued Parameters
String, Time and Logical Functions
- Basic String Functions
- System Time Functions
- Time Calculation Functions
- Logical Functions (ISNULL, CASE, COALESCE, IIF)
User-Defined Functions
- Scalar Functions
- Table Valued Functions
Cursors
- Using Cursors
- Cursor Types
Error Handling
- Structure Error Handling
- Throw Structure