Planning and Management of Database Systems (27-2017) - The Academic College of Tel-Aviv - Yafo
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.
September 11, 2017Course 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
September 11, 2017Exercises
Information unavailable
September 11, 2017Exam
Information unavailable
September 11, 2017Additional 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.
February 13, 2018