Databases Design (27-2017) - Bar-Ilan University
General
- Winter 2015 - Wednesday, 14: 15-15: 45, Exercises: Wednesday, 16: 15-17: 45, 18: 15-19: 45.
- Spring 2016 - Wednesday, 14: 15-15: 45, Exercises: Tuesday, 16: 15-17: 45, 18: 15-19: 45.
- Syllabus.

Course Outline
- Background and basic concepts, principles of database management systems
- Data model
- ERD
- Tabular and RA data model
- SQL language
- Normalization (Lecture notes in Hebrew)
- Indexes and hashing (Lecture notes in Hebrew)
- Query processing and optimization (Lecture notes in Hebrew)
- Transaction management and parallel work (Lecture notes in Hebrew)
- XML

Exercises
Information unavailable

Exam
Information unavailable

Additional Material
- Heiferman, R. (2000). Relational Data Bases and SQL, Principles and Design: Hod-Ami. (Hebrew)
- Silberschatz, A., Korth, H. F., & Sudarshan, S. (2010). Database system concepts (6th Ed.): McGraw-Hill New York.
- Hoffer, J., Ramesh, V., & Topi, H. (2015). Modern database management: Prentice Hall.
- Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems, Global Edition: Pearson Education Limited.
