|
SQL
|
|
Tue Jan 19
|
Introduction to SQL
|
Viescas & Hernandez: 4
|
Activity 1
|
|
Thu Jan 21
|
Expressions
|
Viescas & Hernandez: 5
|
Activity 2
|
|
Tue Jan 26
|
Filtering
|
Viescas & Hernandez: 6
|
Activity 3
|
|
Thu Jan 28
|
Inner Joins
|
Viescas & Hernandez: 8
|
Activity 4
|
|
Tue Feb 2
|
Class Canceled
|
|
|
|
Thu Feb 4
|
Outer Joins
|
Viescas & Hernandez: 9
|
Activity 5
|
|
Tue Feb 9
|
Unions
|
Viescas & Hernandez: 10
|
Activity 6
|
|
Thu Feb 11
|
Aggregate Functions
|
Viescas & Hernandez: 11 & 12
|
Activity 7
|
|
Tue Feb 16
|
Grouping
|
Viescas & Hernandez: 13 & 14
|
Activity 8
|
|
Thu Feb 18
|
Updating
|
Viescas & Hernandez: 15
|
Activity 9
|
|
Tue Feb 23
|
Inserting & Deleting
|
Viescas & Hernandez: 16 & 17
|
Activity 10
|
|
Thu Feb 25
|
Constraints
|
Viescas & Hernandez: 2
|
Activity 11
|
|
Tue Mar 1
|
Case
|
Viescas & Hernandez: 19
|
Activity 12
|
|
Thu Mar 3
|
Midterm Exam
|
|
|
|
Design
|
|
Tue Mar 15
|
Presentations
|
|
|
|
Thu Mar 17
|
Introduction to Database Design
|
Hernandez: 5
|
|
|
Tue Mar 22
|
Class Canceled
|
|
|
|
Thu Mar 24
|
Analyzing Current Database
|
Hernandez: 6
|
|
|
Tue Mar 29
|
Establishing Table Structure
|
Hernandez: 7
|
|
|
Thu Mar 31
|
Keys
|
Hernandez: 8
|
|
|
Tue Apr 5
|
Class Canceled
|
|
|
|
Thu Apr 7
|
Field Specifications
|
Hernandez: 9
|
|
|
Tue Apr 12
|
Table Relationships
|
Hernandez: 10
|
|
|
Thu Apr 14
|
Business Rules
|
Hernandez: 11
|
|
|
Tue Apr 19
|
Views
|
Hernandez: 12
|
|
|
Thu Apr 21
|
Data Integrity, Bad Design, & Breaking the Rules
|
Hernandez: 13, 14, & 15
|
|
|
Thu Apr 29
|
Project Presentations
|
|
|