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

a.      Data Types

i.           Numeric

ii.           Character

iii.           Date

b.      Creating Table Structure

c.      SQL Constraints

i.           Key Constraints

a.      Not Null

b.      Unique

c.      Default

ii.           Check Command

iii.           Column Constraint

iv.           Table Constraint

d.      SQL Indexes

i.           Create Index

ii.           Integrating with constraints

iii.           Dropping Index

e.      Data Manipulation

i.           Adding Rows

a.      Insert

ii.           Saving Changes

a.      Commit

iii.           Listing Table Rows

a.      Select

i.           Wild Card *

iv.           Updating Table Rows

a.      Update

v.           Restoring Table Contents

a.      Rollback

vi.           Deleting Table Rows

a.      Delete

vii.           Subquery/nested query/Inner

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

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 19.pdf