Print Course information
Email me when offered
Return to Course Catalog

Course Catalog > Technology Classes > Database Business Intelligence Developer

Structured Query Language L2   

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.
 
No classes currently available. Click here to continue searching for courses.

Some Title



Copyright © Bellevue College Continuing Education, 14673 NE 29th Place | 425.564.2263 | Main Campus, 3000 Landerholm Circle SE