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

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

2.      Joining Database Tables

i.           Review Chapter 3

ii.           Linking through keys

iii.           Running commands within join

iv.           Using Aliases

v.           Recursive Joins

Chapter 8

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

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 21.pdf