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
Bring a USB flash drive (minimum 2 GB) to class. Bring book from Structured Query Language: (SQL) Level 1.
See our
detailed course information including course content, learning objectives, and prerequisites.
Students must have a Bellevue College NetID before the first class session. Please
click here to create your NetID account.