T-SQL Programming   

Explore SQL Server programming techniques using Transact-SQL programming constructs. 

 

Competencies:

• Automate data insertion and modification using scripts and basic programming constructs 
• Convert SQL Scripts into procedures and functions in order to make the functionality available to other database users 
• Manage transactions in order to increase concurrent usage of the database 
• Create SQL programming functions to provide flexible data integrity and error-handling rules 
• Create triggers that enable the SQL database to automatically take action based on a particular event occurring 
• Manage database query results row-by-row using SQL cursors 

 

This course covers Microsoft’s SQL Server database programming techniques using Transact-SQL programming constructs, with an emphasis on stored procedures and scripts. This course also involves writing SQL scripts of increasing complexity. Topics: creating and implementing functions using T-SQL and SQL CLR; views, triggers, and transactions; how to protect your data with constraints; and structured error handling.

Prerequisites:

• Structured Query Language (SQL) Level 1 or equivalent knowledge 
• Structured Query Language (T-SQL) Level 2 or equivalent knowledge