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

i.           Final Exam Review

ii.           Final Project Review

iii.           SQL Functions

a.           DATE and TIME

b.           NUMERIC

c.           STRING

d.           CONVERSION

iv.           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

v.           Virtual Tables/Views

a.           View

b.           Base tables

vi.           Updateable views

vii.           Oracle Sequences

viii.           Procedural SQL

a.           Persistent stored module PSM

b.           Procedural Language SQL PL/SQL

i.           Anonymous blocks

ii.           Data Types

ix.           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

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 25.pdf