Nov 27, 2021  
2020-2021 Lane Community College Catalog 
    
2020-2021 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 or SQL Server database throughout this course (based on student preference), students work with the ANSI/ISO standard with the SQL implementation of the database product.

Prerequisite:  CS 161N  or CS 161C   instructor consent.
Learning Outcomes
Upon successful completion of this course, the student should 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)