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:

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
Write, test and debug SQL code based on ANSI/ISO standards to update database content and handle transactions
Write, test and debug SQL code based on ANSI/ISO standards to build and maintain database structures including views, users and permissions
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)