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

Chapter 8

1.      Review on using SQL programs

i.           MYSQL Workbench

2.            SQL Joins Continued

i.           Types of Joins

a.      Have common values in common columns (Natural Join)

b.      Meet a given join condition (equality or inequality)

c.      Have common values in common columns or have no matching values (outer join)

ii.           Example from chapter 7

a.      Points from example

iii.           Inner Join - Traditional join where only rows matching criteria are selected

a.      Equality condition/Natural Join/Equijoin

b.      Inequality condition/Theta Join

iv.           Outer Join - Returns not only the matching rows buy the rows with unmatched values as well

v.           Examination of table 8.1

vi.           SQL new style of join the Cross Join

a.      Cartesian Product

vii.           Natural Join

viii.           Using Clause

ix.           Join on Clause

x.           Outer Joins

a.      Left

b.      Right

c.      Full

xi.           Sub Queries

a.      Rules from chapter 7

b.      Examples

c.      Returns

i.           One Single Value

ii.           A list of Values

iii.           A virtual table

d.      Where

e.      In

f.       Having

g.      Any and All

h.      From

i.        Attribute List

xii.           Correlated Subqueries

xiii.           SQL Functions

a.      DATE and TIME

b.      NUMERIC

c.      STRING

d.      CONVERSION

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 23.pdf