Using SQL Queries in SQL Server - Advanced

The training is recommended for anyone who will be responsible for advanced data query, display, organization, error handling, transaction management in SQL Server 2016. The training builds on previous SQL query knowledge and practice and covers the basics of operators, table expressions, stored procedures, error handling, views, transaction and optimization.

Using INSERT, UPDATE, DELETE statements in Transact-SQL.

MERGE statement

Include OUTPUT clause in various DML statements

Creating statements, using PIVOT and UNPIVOT.

Introduction to T-SQL programming: basics of controls (loops, branches); concept, creation and execution of dynamic SQL.

Error handling: basic concepts, compile and run-time errors, redirecting errors using TRY/CATCH, creating error handling routines using CATCH and ERROR functions, creating client-side error messages (THROW, RAISERROR), error handling tips and tricks.

Transaction management basics: basic concepts, transaction properties, benefits of using transactions; using transaction management statements; transaction error handling.

Completion of or knowledge of the Querying Microsoft SQL Server 2016 (20461_1) course. As the course materials are in English, a minimum of basic English at document reading level is required. The lecture is in Hungarian.