LinkedIn – Program Databases with Transact-SQL 2020-9

Program Databases with Transact-SQL course. This course focuses specifically on one class of objects in a SQL Server database: programming objects. Using these objects, database developers can automate systems with triggers, ensure seamless user experiences with stored procedures, protect database integrity with transactions, and implement error handling routines to enhance database capabilities.

Instructor Adam Wilbert takes an in-depth look at the programming side of SQL Server databases. Using real-world examples, he explains the types of objects that can be used to automate systems and maintain database integrity. This course assumes only a basic understanding of how a relational database works and how to write Transact-SQL (T-SQL) queries.

What you will learn

• Write stored procedures that include input and output parameters.
• Create scalar-valued and table-valued user-defined functions.
• Execute batches of commands as transactions to ensure data integrity.
• Design and implement triggers to automate actions in response to database events.
• Implement error handling routines to improve the stability and reliability of database applications.
• Use programming objects to increase security and improve database performance.

This course is suitable for people who:

• Are familiar with relational database concepts and want to deepen their knowledge of SQL Server programming.
• Able to write Transact-SQL (T-SQL) queries and looking to learn how to automate and enhance database capabilities through programming objects.
• Database developers are looking for tools to ensure data integrity, improve user experience, and implement complex logic at the database level.
• Looking for a deeper understanding of the “Programmability” folder in SQL Server and its practical applications.
• They want to automate their systems using triggers and stored procedures and implement error management effectively.

Course details

• Publisher: LinkedIn
• Instructor: Adam Wilbert
• Training level: Beginner to advanced
• Training duration: 2 hours and 41 minutes

Course headings

Course images

Sample course video

Download link

Download file – 404 MB

File(s) password: www.downloadly.ir

File size

404 MB