SQL Programming Level 2

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 course outline.

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.

Note: Please bring a USB flash drive (minimum 2 GB) to in-person classes, so you can save your work.

No classes currently available. Click here to continue searching for courses.

Some Title