In this intermediate SQL course, students will create queries using transact structured query language (T-SQL) commands that are used with SQL Server databases. Students will get hands-on practice creating queries to merge data between tables, track data changes on tables, rank data, and compare tables. Students will also join data from subqueries and table-valued functions, perform recursive queries with hierarchical data, use common table expressions in place of complex joins, query Excel data, and transfer XML data between a SQL Server table and an outside file.
Bring a USB flash drive (minimum 2 GB) to class. Bring book from Structured Query Language: (SQL) Level 1.
Prerequisite: Structured Query Language: (SQL) Level 1 or equivalent. Recommended: Beginning SQL Server (using 2012).
See our detailed course information including course content, learning objectives, and prerequisites.