Print Course information
E-mail to a friend
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.

 

Item: F8313
CEUs:  2.1
Schedule: 6:00 PM - 9:00 PM, 7 Tu Th - 10/7/2021 - 10/28/2021

Instructor(s):  Victor Leal
Location: ONL   Room:

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: $749.00

 

Registration is closed for this class...
Item: R8341
CEUs:  2.1
Schedule: 6:00 PM - 9:00 PM, 7 Tu Th - 7/20/2021 - 8/10/2021

Instructor(s):  Victor Leal
Location: ONL   Room:

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: $749.00

 

 

 

If the class you are registering for lists a required textbook, you are responsible for ordering and purchasing it prior to the start of class. Please note that there is no bookstore at North Campus. 
 

 

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