In this course you will learn advanced Transact-SQL using SQL concepts to help optimize queries. Additional focus is on writing queries that will effectively present data in reports.
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Upon successful completion the student will be able to perform Variables, IF-THEN-ELSE Conditions, CASE Structures, Stored Procedures, Database View, COALESCE, WHILE Loops, Triggers User Defined Functions Windowing Functions, Mathematical Functions, Date Manipulation, Cursors.