Nov 26, 2022  
2021-2022 Lane Community College Catalog 
    
2021-2022 Lane Community College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CS 275 - Basic Database SQL

4 Credit(s)

This training course is valuable for anyone who needs to learn SQL programming. The course is designed for students new to writing SQL queries or having insufficient practice experience. It will provide a solid foundation of the SQL programming language that enables students to query and manipulate databases. Working in Oracle throughout this course, students work with the ANSI/ISO standard with the SQL implementation of the database product.

Prerequisite:  CS 161N  or CS 161C  or CS 161P  or CS 133N  or CS 133C  or CS 133P  or BT 223  or instructor consent
Learning Outcomes
Students who successfully complete this course will be able to: 

  1. Write, test and debug SQL code based on ANSI/ISO standards to retrieve simple to complex data sets including: single or multiple tables, row functions, aggregate functions, subqueries
  2. Write, test and debug SQL code based on ANSI/ISO standards to update database content and handle transactions
  3. Write, test and debug SQL code based on ANSI/ISO standards to build and maintain database structures including views, users and permissions
  4. Describe different aspects of the data they are accessing-what are their results and could they be interpreted differently



Add to Portfolio (opens a new window)