Official Course Description:   MCCCD Approval:  06/22/99
CIS117DS     19996-20005	L+L	1 Credit(s)	2 Period(s)
Oracle Advanced SQL and PL/SQL
Retrieve data using advanced techniques such as set operators and hierarchical retrieval. Focuses on writing SQL and SQL *Plus script files. Prerequisites: CIS117DO or permission of the instructor.

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:
CIS117DS   19996-20005	Oracle Advanced SQL and PL/SQL

1.	Describe the SET operators and correlated subqueries and review rules and guidelines for their use.(I-II)
2.	Explain the benefits of heirarchical query.(III)
3.	Use advanced techniques to retrieve data including SET operators, correlated subqueries and hierarchical queries.(I-III)
4.	Describe the types of problems that may be solved by writing SQL scripts that generate other SQL scripts.(IV)
5.	Write and execute SQL scripts that generate SQL scripts of drop table commands and insert commands.(IV)
6.	Use SQL *Plus to format reports.(V)

Go to Description    Go to top of Competencies
 

MCCCD Official Course Outline:
CIS117DS   19996-20005	Oracle Advanced SQL and PL/SQL

I. Combining Queries with SET Operators A. Overview of SET operators B. Rules and guidelines C. Order by clause II. Correlated Subqueries A. Overview of Correlated Subqueries B. Solving Problems with Correlated Subqueries C. Writing Correlated Subqueries D. EXISTS AND NOT EXISTS Operators E. Up-date and Deletion of Rows III. Hierarchical Retrieval A. Benefits of Hierarchical Query B. Ordering Rows C. Formatting Hierarchical Data D. Excluding Branches IV. Writing Scripts to Generate Scripts A. Types of Problems That May be Solved B. Drop Table Commands C. Insert Commands V. Formatting Reports Using SQL *Plus A. Output with Set Commands B. Header and Footer Information C. Aggregate Data

Go to Description    Go to top of Competencies    Go to top of Outline