|
Oct. 29: |
Notes (Set #1) on SQL Integrity Contraints are posted
|
|
Oct. 29: |
Notes on SQL Access Control are posted
|
|
Oct. 29: |
Notes (Set #2) on SQL Views are posted
|
|
Oct. 29: |
Recitation 8 material is posted
|
|
Oct. 26: |
Notes (Set #1) on SQL Views are posted
|
|
Oct. 26: |
Notes (Set #2) on Nested SQL Queries and Analytics are posted
|
|
Oct. 22: |
Recitation 7 material is posted
|
|
Oct. 20: |
Notes (Set #1) on Nested SQL Queries and Analytics are posted
|
|
Oct. 18: |
HW3 sample solutions are posted
|
|
Oct. 15: |
Reading on Nested SQL Queries and Analytics is posted
|
|
Oct. 15: |
Notes (Set #3) on DB Design - ER Model are posted
|
|
Oct. 13: |
Notes (Set #2) on DB Design - ER Model are posted
|
|
Oct. 8: |
Recitation 6 material is posted
|
|
Oct. 7: |
Notes (Set #1) on DB Design - ER Model are posted
|
|
Oct. 5: |
Reading on DB Design - ER Model is posted
|
|
Oct. 5: |
Notes (Set #2) on DB Design - Normalization are posted
|
|
Oct. 1: |
Recitation 5 material is posted
|
|
Sep. 30: |
HW3 is released & is due on Oct. 18
|
|
Sep. 30: |
HW2 sample solutions are posted
|
|
Sep. 30: |
Notes (Set #1) on DB Design - Normalization are posted
|
|
Sep. 30: |
Notes (Set #1) on DB Design - Normalization are posted
|
|
Sep. 28: |
Reading on DB Design - Normalization is posted
|
|
|
Sep. 28: |
Notes (Set #2) for basic SQL DML are posted
|
|
Sep. 24: |
Recitation 4 material is posted
|
|
Sep. 23: |
Notes(Set #1) for basic SQL DML are posted
|
|
Sep. 23: |
Notes (Set #3) on Relationsl Algebra are posted
|
|
Sep. 22: |
Reading for basic SQL DML is posted
|
|
Sep. 21: |
Notes (Set #2) on Relationsl Algebra are posted
|
|
Sep. 17: |
Recitation 3 material is posted
|
|
Sep. 17: |
Notes (Set #1) on Relationsl Algebra are posted
|
|
Sep. 15: |
HW2 is released & is due on Sep. 29
|
|
Sep. 14: |
Notes (Set #1) on SQL DDL are posted
|
|
Sep. 10: |
Recitation 2 material is posted
|
|
Sep. 9: |
Notes (Set #2) on Relational Model are posted
|
|
Sep. 7: |
Notes (Set #1) on Relational Model are posted
|
|
Sep. 4: |
Recitation 1 material is posted
|
|
Sep. 2: |
Notes (Set #3) on Intro to DBMS are posted
|
|
Sep. 1: |
HW1 is released & is due on Sep. 15
|
|
Aug. 31: |
Notes (Set #1 & #2) on Intro to DBMS are posted
|
|
Aug. 21: |
Lectures and Recitations on-line until Sep. 13
|
|
Lectures Zoom Details
|
|
Recitation Zoom Details
|
|
Aug. 17: |
First Lecture (Class) on Aug. 31
|
|
Aug. 17: |
First recitations on Sep. 3
|