Introduction to Database Management Systems (DBMS). Architecture of a DBMS. Data modeling data with the Entity-Relationship Model. Relational Model. Relational Algebra and Relational Calculus. SQL Language. Design of a Database. Physical organization of a DBMS. Storage media. File organizations and indexes. Tree indexes and files (B-trees, B+trees). Random static and dynamic files (hashing). Processing and optimization of queries. Transaction processing and concurrency techniques. Recovery techniques. Techniques of security and authorization.
After the successful course attendance a student will: