|
GRADES
|
|
ATTENDANCE
|
|
Instructor: Karen Krejcie
Tables
Definition |
Unique Number: 30168
|
|
Class Date
|
Assignment
|
Page
|
Due Date
|
Points
|
|
Introduction to 4 GLs & SQL
|
|
January 16
|
Course Overview
Generation Presentation
Research Assignment
|
|
January 23
|
75
|
|
January 23
|
Research Assignment Presentations
Assignment #2
Read Chapter 1
|
SQL Tutorial
Curriculum Manual
|
January 30
|
100
|
|
Manual Queries
|
|
January 30
|
Chapter 1 Presentation
Tables Presentation
Assignment #1
Read Chapter 3
|
Curriculum Manual
|
February 6
|
75
|
|
Single Table Queries
|
|
February 6
|
Chapter 3 Presentation
SQL Demo on iSeries
|
|
|
|
|
February 13
|
Assignment #3
|
Curriculum Manual
|
February 20
|
100
|
|
February 20
|
********** NO CLASS *********** |
|
February 27
|
Relational Concepts
Read Chapter 4
|
|
|
|
|
Multiple Table Queries
|
|
March 6
|
Chapter 4 Presentation
Assignment #4
Read Chapter 2
QUIZ 1 - SQL Questions & Single Tables
|
Curriculum Manual
|
March 20
March 6
|
120
30
|
|
Table Creation & Updating
|
|
March 13
|
********** NO CLASS ***********
|
|
March 20
|
Chapter 2 Presentation
Creating Tables
Assignment #5
Read Chapter 5
|
Curriculum Manual
|
March 27
|
100
|
|
March 27
|
Additional Multiple Table Queries
Chapter 5 Presentation
Updating Tables
Assignment #6
Prep for FUNCTION DAY!
|
Curriculum Manual
|
April 3
|
100
|
|
April 3
|
Prototyping
Presentation
FUNCTION DAY
Review Exam 1
|
|
|
|
|
April 10
|
EXAM 1
Assignment #7
Read Chapter 6
|
Curriculum Manual
|
April 17 3pm CT
|
125
100
|
|
Database Administration
|
|
April 17
|
Review Exam 1
Chapter 6 Presentation
Assignment #8 |
Curriculum Manual
|
May 1 |
50
|
|
April 24
|
********** NO CLASS *********** |
|
SQL System Development
|
|
May 1
|
Project 1 - Parts A and B
Exam 2 Review
|
Curriculum Manual
|
May 8
|
200
|
|
May 8
|
EXAM 2 |
|
|
125
|
|
May 15
|
Review Exam #2
Course Wrap-Up |
|
|
|
