|
9 Jan 2012 |
1. |
|
Introduction to Database Systems |
|
|
Read: |
Chapter 1 & 2 from the textbook (5th or 6th Ed.) |
|
|
Slides: |
in PDF:
4 slides per page
|
|
11 Jan 2012 |
2. |
|
Relational Model |
|
|
Read: |
Chapter 5 from the textbook (5th Ed.) |
|
|
          |
Chapters 3 from the textbook (6th Ed.) |
|
|
Slides: |
in PDF:
4 slide per page
|
|
18, 23 Jan 2012 |
3. |
|
Relational Algebra |
|
|
Read: |
Chapter 6 from the textbook (5th Ed.) |
|
|
          |
Chapters 6.1-6.5 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1, in PDF:
4 slide per page
|
|
|
|
Set #2, in PDF:
4 slide per page
|
|
25, 30 Jan 2012 |
4. |
|
SQL DDL |
|
|
Read: |
Chapter 8 from the textbook (5th Ed.) |
|
|
          |
Chapters 4.1-4.2 and 5.4 from the textbook (6th Ed.)
|
|
|
Slides: |
in PDF:
4 slide per page
|
|
30 Jan |
& |
1, 6, 8 Feb 2012 |
5. |
|
SQL DML |
|
|
Read: |
Chapter 8 from the textbook (5th Ed.) |
|
|
          |
Chapters 4.3-4.6 & 5.1 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1, in PDF:
4 slide per page
|
|
|
|
Set #2, in PDF:
4 slide per page
|
|
8, 13 Feb 2012 |
6. |
|
SQL Views, Integrity Constraints, Access Control |
|
|
Read: |
Chapter 8 from the textbook (5th Ed.) |
|
|
          |
Chapters 5.2-5.5 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1, in PDF:
4 slide per page
|
|
|
|
Set #2, in PDF:
4 slide per page
|
|
15, 20, 22 Feb 2012 |
7. |
|
Embedded SQL |
|
|
Read: |
Chapter 8 from the textbook (5th Ed.) |
|
|
          |
Chapter 13-14 from the textbook (6th Ed.)
|
|
|
Slides: |
in PDF:
4 slide per page
|
|
27 Feb, 12 Mar 2012 |
8. |
|
DB Design - Normalization |
|
|
Read: |
Chapter 10 and Sections 11.1 and 11.2 from the textbook (5th Ed.) |
|
|
          |
Chapters 15 and Sections 16.2-16.5 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1, in PDF:
4 slide per page
|
|
|
|
Set #2, in PDF:
4 slide per page
|
|
14, 19 Mar 2012 |
9. |
|
DB Design - Conceptual Design, ER and EER Model |
|
|
Read: |
Chapters 3, 4 and 7 from the textbook (5th Ed.) |
|
|
          |
Chapters 7-10 from the textbook (6th Ed.)
|
|
|
Slides |
Set #1 in PDF:
4 slides per page
|
|
|
|
Set #2 in PDF:
4 slides per page
|
|
|
|
Set #3 in PDF:
4 slide per page
|
|
21, 26, 28 Mar, 2012 |
& |
2, 4, 9 Apr, 2012 |
10. |
|
Physical Organization: Storage, Files & Indexing |
|
|
Read: |
Chapters 13 and 14 from textbook (5th Ed.) |
|
|
          |
Chapters 17-18 from the textbook (6th Ed.)
|
|
|
Slides |
Set #1 in PDF:
4 slides per page
|
|
|
|
Set #2 in PDF:
4 slide per page
|
|
|
|
Set #3 in PDF:
4 slide per page
|
|
9, 11 Apr 2012 |
11. |
|
Query Processing & Optimization |
|
|
Read: |
Chapter 15 from textbook (5th Ed.) |
|
|
          |
Chapter 19 from textbook (6th Ed.)
|
|
|
Slides |
in PDF:
4 slide per page
|
|
11, 16, 18 Apr 2012 |
11. |
|
Transaction Processing, Concurrency Control, Recovery & Data Streams |
|
|
Read: |
Chapter 17, 18 and 19 from the textbook (5th Ed.) |
|
|
          |
Chapters 21, 22 and 23 from the textbook (6th Ed.)
|
|
|
Slides |
in PDF:
4 slide per page
|
|