This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions.

Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. The curriculum includes content focused on Microsoft SQL Server 2014 and on earlier releases of SQL. This course helps you prepare for the Exam 70-464.