Print Course information
Email me when offered
Return to Course Catalog

Course Catalog

Structured Query Language L1   

Competencies:
  • Use the WHERE clause in a SELECT statement to retrieve filtered data from a relational database 
  • Apply aggregate, date and string functions to data retrieved from a relational database 
  • Use the ORDER BY, GROUP BY and HAVING clauses to retrieve data from a relational database 
  • Use a self-join operation to retrieve data from a single data source or a variety of operators, or subqueries to retrieve data from multiple data sources 
  • Use the INSERT, UPDATE, DELETE and TRUNCATE commands to manipulate data in a table 
  • Revise a relational database by creating, altering and dropping tables and views 
 
Create queries using a standard structured query language (SQL) that is applicable to almost any relational database. Students will get hands-on practice creating queries to retrieve data in various forms, including filtered, calculated, grouped and aggregated, sorted, and consolidated from multiple data sources. Students will also practice writing queries to manipulate data in a table and create, alter, and drop tables and views.
 
Prerequisite:
  • Basic Relational Database Essentials or familiarity with relational database products 

Bring a USB flash drive (minimum 2 GB) to class.

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.
Copyright © Bellevue College Continuing Education, 14673 NE 29th Place | 425.564.2263 | Main Campus, 3000 Landerholm Circle SE