Apr 04, 2020
DA 161 - Oracle Database Programming II
Credit Hours: 3
Physical implementation of conceptual database designs that were generated during the database design and modeling phase of relational database development will be addressed in this course.
Physical database creation will be accomplished by using SQL, the industry-standard database programming language and implemented using the Oracle corporation's relational database software.
Upon completion, the student will be able to:
- use SQL single-row and group functions to perform calculations, manipulate data and modify data items;
- code SQL statements to JOIN multiple database tables for purposes of querying and maintaining the tables using both Oracle proprietary syntax and ANSI/ISO SQL 99 syntax;
- combine two queries into one to create single-row and multiple row subqueries;
- use Data Manipulation Language (DML) to add, update, delete or merge data in the database;
- use Data Definition Lanuage (DDL) to create, alter, remove and drop tables from the database;
- create and enforce constraints to prevent invalid data from entering a table or prevent deletion if records contain dependencies with other tables;
- establish "views" of existing database tables to provide and restrict user access to data;
- create sequences, indexes and synonyms to assist in the management of a database;
- implement database security and recovery at the system and user priviledge levels; and
- take the first of two certification exams to become an Oracle Certified Associate (OCA).