Advanced SQL.

Catalog description

Learn various advanced SQL topics for SQL Server, including temporary tables, triggers, advanced stored procedures and user-defined functions. Develop skills in optimization, indexing and other performance-tuning tools and techniques. Explore advanced database design, implement windowing functions, perform data integration using triggers and merge statements, and create and parse JSON and XML.