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

1.      Review

2.      Select Queries

i.           Set Oriented

ii.           Where Clause

iii.           Comparison Operators

a.      On Characters

b.      On Dates

c.      Computed Columns

iv.           Arithmetic Operators

a.      Rules of Precedence

v.           Logical Operators

a.      And

b.      Or

c.      Not

vi.           Special Operators

a.      Between

b.      Is Null

c.      Like

d.      In

e.      Exists

3.      Additional Data Definition Commands

i.           Alter Table

a.      Changing Data Type on Column

b.      Changing Data Characteristics on Column

c.      Adding a Column

d.      Dropping a Column

ii.           Advanced Data Updates

a.      Update Command

1.      Difference between Insert and Update

iii.           Copying Parts of Tables

a.      Creating a Table and using Insert Into

b.      Creating a new table and Selecting from another

iv.           Adding Primary and Foreign Key Designations

v.           Drop Table

4.      Additional Select Query Keywords

i.           Order By

a.      Cascading Order Sequence

ii.           Distinct

iii.           Aggregate Functions

a.      Count

b.      Min

c.      Max

d.      Sum

e.      Avg

iv.           Grouping Data

a.      Group By

1.      Having Clause

5.      Joining Database Tables

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 20.pdf