Structured Query Language Level 2   

Competencies:

• Create queries using transact structured query language (T-SQL) commands that are used with SQL Server databases 
• Understand how to create queries in order to merge data between tables, track data changes on tables, rank data and compare tables 
• 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

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.

Prerequisites:

• Required: Structured Query Language: (SQL) Level 1 or equivalent knowledge  
• Recommended: Beginning SQL Server