Program Databases with Transact-SQL

This course focuses on a single category of objects within a SQL Server database: Programmability objects. With these objects, database developers can automate systems with triggers, ensure consistent user experiences with stored procedures, protect database integrity with transactions, and implement error-handling routines that enhance the database’s functionality. Join instructor Adam Wilbert as he takes a deep dive into the Programmability folder in a SQL Server database. Using real-world examples, he explores the types of objects that can be deployed to automate systems and maintain database integrity. To follow along, you just need some familiarity with the functionality of a relational database, as well as how to write Transact-SQL (T-SQL) queries. Discover how to write stored procedures that include input and output parameters; create scalar- and table-valued user defined functions; execute batches of commands as transactions; and more.

Contents:

• Introduction
• 1. Create Views of the Data
• 2. Create User-Defined Functions
• 3. Work with Stored Procedures
• 4. Create Transactions
• 5. Implement Error Handling
• 6. Data Type Conversions and NULLs
• Conclusion