Due to its ease of use, scalability and data warehousing capabilities, many organizations are choosing Microsoft SQL Server for their database needs, fueling the demand for professionals well versed in the development of robust SQL Server applications.
This course provides extensive experience creating stored procedures and triggers, and developing SQL queries that utilize SQL Server to the fullest. You learn to take advantage of AFTER and INSTEAD OF triggers, manage concurrency using transactions and locking options, and exchange data effectively using Transact-SQL's support for XML.
In this course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application. You also learn to transform data with built-in functions, summarize data using aggregation and grouping, and build simple and correlated subqueries.
In this course, you acquire an in-depth knowledge of SQL Server's essential tools - the storage engine, lock manager and query optimizer. Through hands-on exercises, you gain the skills to implement a high-performance SQL Server database solution. You create indexes that optimize different types of queries, interpret the data access plans produced by the query optimizer, and minimize I/O by designing efficient physical data structures.
