Christopher J. Kimmer, Ph.D.
IU Southeast Informatics
iSciCL
Informatics and Scientific Computing Laboratory
I308 Tentative Class Schedule
Fall 2013
"Tentative" means that this schedule may change due to weather, classroom pace, etc.
| Date | Class Topic, Reading, Assignments, etc. |
| T 8/27 | Syllabus, Databases, Big Threes: Tiers of Architecture & Views of Data |
| R 8/29 | Relations, records, and flat-file data models |
| T 9/3 |
Conceptual Data Models: ERDs
Read Ramackrishnan Chap. 2 available on Oncourse |
| R 9/5 | Cardinality in Relationships |
| T 9/10 |
Advanced ERDs
Classwork 1 |
| R 9/12 |
The Relational Data Model : Keys and Schemas
HW 1 due |
| T 9/17 | Making Database Schemas from ERDs |
| R 9/19 | Basic SQL: SELECT FROM WHERE and ORDER BY |
| T 9/24 |
SQL Joins; In Class 2
Read Beginning SQL Queries (henceforth referred to as SQL) Chap 2. and 3 HW 2 ERD 2 RDB due |
| R 9/26 |
Parameterized Queries
|
| T 10/1 |
The SQL DDL and DML
In class 2 Parameterized Queries |
| R 10/3 |
Quiz 1 - SQL Query Language, Intro to Relational Algebra
Read Ramakrishnan Chap. 4 available on Oncourse HW 3 SQL 1 Due Project Phase 2 Due Friday 10/4 |
| T 10/8 |
Relational Algebra Set Operations
In Class 3 Relational Algebra 1 Project Phase 3 Due |
| R 10/10 | Test 1 - Data models, ERDs, RDB2ERD, SQL |
| T 10/15 | In class 4 Relational Algebra 2 |
| R 10/17 |
Set operations in SQL; Uncorrelated nested queries
Read SQL Chapter 5, additional notes at the course blog and this set of notes as well as here and how about this set, too HW 4 Relational Algebra Due |
| T 10/22 | Nested Query Practice, ANY, ALL |
| R 10/24 |
SQL practice; Alternative Intersections and self joins
SQL Chapter 6 and notes at the blog Project Phase 4 Due Friday at 11 AM |
| T 10/29 |
Outer Joins; More SQL practice
Read SQL Chapter 6 |
| R 10/31 |
Aggregation
Read SQL Chapter 7 and notes at the blog |
| T 11/5 |
GROUP BY, More SQL Practice
notes at the blog HW 5 SQL 2 Due |
| R 11/7 | Intro to XML, syntax and flat-file data models in XML |
| T 11/12 |
XPath document model
HW 6 SQL 3 due |
| R 11/14 | Test 2 |
| T 11/19 | XPath Navigation, levels, trees, and nodes |
| R 11/21 |
XPath Wildcards and Filters
Notes at the i308 blog Project Phase 5 Due |
| T 11/26 | NO CLASS - THANKSGIVING BREAK |
| R 11/28 | NO CLASS - THANKSGIVING BREAK |
| T 12/3 | XPath Practice. Kimmer out of town. |
| R 12/5 |
Review Day
HW 7 due, Extra credit assignment due 12/9 at 11 AM |
| T 12/10 |
Test 3 (Cumulative)
Project Phase 6 Due |