CS 151A Oracle SQL Databases (3)
Credit, Degree Applicable
A course in the use of the Oracle database management system to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the Oracle SQL language. The course includes a brief introduction to the programming aspects of PL/SQL.
After successful completion of this course, students will be able to:
- Outcome 1: Describe the basic concepts of databases, tables, relationships, and normalization.
- Outcome 2: Analyze business requirements, designing and implementing queries that satisfy those requirements and using all of the major components of the SQL language for accessing data, including inner and outer joins, aggregate queries and subqueries, and a variety of the intrinsic functions supplied by Oracle.
- Outcome 3: Manipulate an Oracle database using client software to create and modify database objects such as tables, constraints, relationships, and views following a database design and design and implement simple user-defined functions with PL/SQL.
- Outcome 4: Create queries that will manipulate data in the database using Data Manipulation Language statements