Learn to streamline and extract relevant information and execute more advanced SQL features. Topics include implementing complex queries; utilizing sub queries and derived tables; designing views and inline functions; building stored procedures, user-defined functions, and triggers; implementing transactions, error handling and dynamic SQL; identifying locking and isolation levels; and creating indexes. Prerequisites: SQL Programming Level 1. Recommended Textbook (available from Amazon): Beginning SQL Server for Developers, 4th Edition, ISBN: 978-1484202814. For more information, please refer to our website. This is the third required course in the SQL Server Certificate (4 Class Series) and the Data Analyst Certificate Part 1: SQL Server (4 Class Series). The SQL Server Certificate is a prerequisite for the Data Analyst Certificate.