|
|
| 7 Jan 2013 |
| 1. |
|
Introduction to Database Systems |
|
|
Read: |
Chapter 1 & 2 from the textbook (5th or 6th Ed.) |
|
|
Slides: |
in PDF:
4 slides per page
|
|
|
| 9 Jan 2013 |
| 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
|
|
|
| 14, 16 Jan 2013 |
| 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
|
|
|
|
Set #2, in PDF:
4 slide per page
|
|
|
| 23, 28 Jan 2013 |
| 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 |
& |
4, 6, 11 Feb 2013 |
| 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
|
|
|
|
Set #3, in PDF:
4 slide per page
|
|
|
| 11, 13, 18 Feb 2013 |
| 6. |
|
SQL Transactions, Integrity Constraints, Views & 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 (IC & Transactions)
|
|
|
|
Set #2, in PDF:
4 slide per page (Views)
|
|
|
|
Set #3, in PDF:
4 slide per page (Access Control)
|
|
|
| 18, 20, 25 Feb 2013 |
| 7. |
|
Embedded SQL |
|
|
Read: |
Chapter 8 from the textbook (5th Ed.) |
|
|
|
Chapter 13-14 from the textbook (6th Ed.)
|
|
|
Slides: |
Set #1 in PDF:
4 slide per page (PL/SQL)
|
|
|
|
Set #2 in PDF:
4 slide per page (ESQL/JDBC)
|
|
|
| 27 Feb |
& 4 Mar 2013 |
| 8. |
|
Transaction Processing - Concurrency Control |
|
|
Read: |
Chapter 17 and 18 from the textbook (5th Ed.) |
|
|
|
Chapters 21 and 22 from the textbook (6th Ed.)
|
|
|
Slides |
in PDF:
4 slide per page
|
|
|
| 18, 20, 25, 27 Mar 2013 |
& 1 Apr 2013 |
| 9. |
|
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 (HDs & SSDs)
|
|
|
|
Set #2 in PDF:
4 slide per page (Records)
|
|
|
|
Set #3 in PDF:
4 slide per page (Files)
|
|
|
|
Set #4 in PDF:
4 slide per page (Indexes)
|
|
|
| 3 Apr 2013 |
| 10. |
|
Query Optimization |
|
|
Slides |
in PDF:
4 slide per page
|
|
|
| 3, 8 Apr 2013 |
| 11. |
|
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: |
in PDF:
4 slide per page
|
|
|
| 10, 15 Apr 2013 |
| 12. |
|
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 slide per page
|
|
|
| 17 Apr 2013 |
| 12. |
|
Transaction Recovery |
|
|
Read: |
Chapter 19 from the textbook (5th Ed.) |
|
|
|
Chapters 23 from the textbook (6th Ed.)
|
|
|
Slides |
in PDF:
4 slide per page
|
|
