Title: Class Outline 28
Course: KVCC BUS210 > Section: Class Outlines

i.           Relational Set Operators

a.           UNION

b.           INTERSECT

c.           EXCEPT(MINUS)

d.           Set-oriented

e.           Union Compatible

f.           Commands

i.           Union

ii.           Union All

iii.           Intersect

iv.           Except

v.           Alternatives

ii.           Virtual Tables/Views

a.           View

b.           Base tables

iii.           Updateable views

iv.           Oracle Sequences

v.           Procedural SQL

a.           Persistent stored module PSM

b.           Procedural Language SQL PL/SQL

i.           Anonymous blocks

ii.           Data Types

vi.           Triggers

a.           What is a trigger

b.           Remember

i.           Invoked before or after a data row is inserted, updated, or deleted

ii.           Associated with a database table

iii.           Each table can have more than one trigger

iv.           Is executed as part of the transaction that triggered it

c.           Parts

i.           Triggering Timing

i.           Before

ii.           After

ii.           Triggering Event

iii.           Triggering Level

i.           Statement

ii.           Row level

iv.           Triggering Action

vii.           Stored Procedure

a.           Passing Values

viii.           Cursors

a.           Implicit - automatically created when SQL statement returns only one value

b.           Explicit - created to hold output of SQL statement with more than one row

ix.           Stored Function

x.           Embedded SQL

a.           Static

b.           Dynamic

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 28.pdf