2
Database Management System (ArsDigita University). Instructor: Ravi Jasuja.
305 years, 6 months
11
A more formal approach to Relational Database Management Systems, compared the way they were covered during Web Applications. Database systems are discussed from the physical layer of B-trees and file servers to the abstract layer of relational design. Also includes alternative and generic approaches to database design and database management system including relational, object-relational, and object-oriented systems, SQL standards, algebraic query languages, integrity constraints, triggers, functional dependencies, and normal forms. Other topics include tuning database transactions, security from the application perspective, and data warehousing. (from ADUni.org)
Course Currilcum
- Lecture 01 – Overview, Query Processing, Embedded SQL, Cursors, Triggers Unlimited
- Lecture 02 – Relational Algebra, Relational Calculus Unlimited
- Lecture 03 – Entity Relationship Diagrams Unlimited
- Lecture 04 – RDBMS Memory and Disk Storage, RAID, Buffer Management Unlimited
- Lecture 05 – Unordered/Sorted/Hashed Files, Indexes Unlimited
- Lecture 06 – Index Sequential Access Method, B+ Trees Unlimited
- Lecture 07 – Static and Dynamic Hashing Indexing Unlimited
- Lecture 08 – External Sorting, Merge Sort, Double Buffering, Replacement Sort Unlimited
- Lecture 09 – Query Optimizers, Query Evaluation Unlimited
- Lecture 10 – Normal Forms Unlimited
- Lecture 11 – Query Analysis and Optimizing in Oracle Unlimited
