|
Standard |
|
R State Standard |
£ Institutionally Developed |
College: n/a |
This course
provides an introduction to the ORACLE database management system platform and
to Structured Query Language (SQL) and
|
Competency Areas: |
Hours: |
|
|
Understand
Oracle operating environment |
Class |
4 |
|
Able to
implement basic SQL SELECT statements |
D. Lab |
6 |
|
Using
ORACLE DML and DDL statements |
P.
Lab/O.B.I. |
0 |
|
Understand
the basics of PL/SQL |
Credit |
7 |
|
Able to
understand and implement ORACLE SQL data retrieval techniques |
|
|
|
Sorting
and retrieving data |
|
|
|
Manipulating
data |
|
|
|
Creating
and managing tables |
|
|
|
Creating
views |
|
|
|
Describing
constraints |
|
|
|
|
|
|
|
Prerequisite: SCT 100, CIS 105, CIS 106, and
CIS 214 Corequisite: |
|
Course Guide |
|
Competency |
After completing this section, the
student will: |
Hours |
||
|
Class |
D. Lab
|
P. Lab/ O.B.I. |
||
UNDERSTANDING ORACLE
OPERATING ENVIRONMENT
|
2 |
3
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ABLE TO IMPLEMENT BASIC
SQL SELECT STATEMENTS
|
4 |
6
|
0 |
|
|
|
Use the
SQL select statements to retrieve database data |
|
|
|
|
|
Use the
SQL select statements to sort database data |
|
|
|
|
|
Use the
SQL select statement with the where clause to filter data |
|
|
|
|
|
Use the
SQL select statement with the in, and, not, and like operators |
|
|
|
USING ORACLE DML AND DDL
|
4 |
6
|
0 |
|
|
|
|
|
|
|
|
|
Insert,
update, delete, and merge rows in a table with DML statements |
|
|
|
|
|
Create,
Modify, and Delete database objects with DDL statements |
|
|
|
UPSTANDING THE BASIC OF
PL/SQL
|
4 |
6
|
0 |
|
|
|
Learn
about PL/SQL variables and data types |
|
|
|
|
|
View the
structure of PL/SQL program blocks and their basic operations |
|
|
|
|
|
Manipulate
variables and perform number and character string operations |
|
|
|
|
|
Become
familiar with PL/SQL program control structures |
|
|
|
|
|
Learn
techniques for debugging PL/SQL programs |
|
|
|
|
|
Understand
named PL/SQL program units |
|
|
|
|
|
Create
server-side stored procedures and functions in SQL Plus |
|
|
|
|
|
Create
client-side procedures and functions in Procedure Builder |
|
|
|
|
|
Create,
Disable, and Drop Triggers |
|
|
|
ABLE TO UNDERSTAND AND
IMPLEMENT ORACLE SQL DATA RETRIEVAL TECHNIQUES
|
4 |
6
|
0 |
|
|
|
Write
Select statements to access data from more than one table using equality and nonequality joins |
|
|
|
|
|
View data
that generally does not meet a join condition by using outer joins |
|
|
|
|
|
Join a
table to itself using a self-join |
|
|
|
SORTING AND RETRIEVING
DATA
|
4 |
6
|
0 |
|
|
|
Retrieve
and sorting data by multiple columns |
|
|
|
|
|
Retrieve
and sorting data by column position |
|
|
|
|
|
Specify
Sort Direction |
|
|
|
MANIPULATING DATA
|
4 |
6
|
0 |
|
|
|
Use
character, number, and date functions in select statements |
|
|
|
|
|
Use
conversion functions |
|
|
|
|
|
Use group
functions |
|
|
|
|
|
Group
data using the group by clause |
|
|
|
|
|
Include
or exclude grouped rows by using the having clause |
|
|
|
|
|
Write
single-row and multiple-row subqueries |
|
|
|
CREATING AND MANAGING
TABLES
|
4 |
6
|
0 |
|
|
|
Create
tables |
|
|
|
|
|
Describe
the data types that can be used when specifying column definition |
|
|
|
|
|
Alter
table definitions |
|
|
|
|
|
Drop,
rename, and truncate tables |
|
|
|
CREATING VIEWS
|
4 |
6
|
0 |
|
|
|
Describe
a view |
|
|
|
|
|
Create,
alter the definition, and drop a view |
|
|
|
|
|
Retrieve
data through a view |
|
|
|
|
|
Insert,
update, and delete data through a view |
|
|
|
|
DESCRIBING
CONSTRAINTS |
4 |
6
|
0 |
|
|
|
Describe
constraints |
|
|
|
|
|
Create
and maintain constraints |
|
|
|
|
ESTABLISH
COMPETENCIES FOR INTRODUCTION TO ORACLE EXAM |
2 |
3
|
0 |
|
|
|
Review
various Oracle websites with established competencies |
|
|
|
|
Suggested Resources |
Enhanced Guide to Oracle by Joline Morrison and Mike Morrison, Course Technology, ISBN:
0619035498
Teach Yourself SQL in 10 Minutes by
Ben Forta, SAMS Publishing, ISBN:
0672316641
Database Systems Using Oracle by Nilesh Shah, Prentice Hall, ISBN: 0130909335
OCP Introduction to Oracle9i: SQL
Exam Guide by Jason S. Couchman, Oracle Press
Oracle SQL Interactive Workbook by
Alex Morrison
and Alice Rischart, Prentice Hall, ISBN:
0130157457
Oracle SQL Plus: The Definitive
Guide by Jonathan Gennick Deborah Russel, O'Reilly & Associates, Incorporated
ISBN: 1565925785