Print Course information
E-mail to a friend
Return to Course Catalog

Course Catalog > Data & Analytics

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

Item: F39072
CEUs:  1.8
Schedule: 6:00 PM - 9:00 PM, 6 Tu Th - 10/25/2022 - 11/10/2022

Instructor(s):  Victor Leal
Location: BVONL   Room: Online

Online registration closes 1 week before the class start date.

Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.



Total cost: $629.00