Database Management System (ArsDigita University) | Computer Science

Database Management System

Database Management System (ArsDigita University). Instructor: Ravi Jasuja. 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)

Lecture 01 - Overview, Query Processing, Embedded SQL, Cursors, Triggers

Lecture 02 - Relational Algebra, Relational Calculus

Lecture 03 - Entity Relationship Diagrams

Lecture 04 - RDBMS Memory and Disk Storage, RAID, Buffer Management

Lecture 05 - Unordered/Sorted/Hashed Files, Indexes

Lecture 06 - Index Sequential Access Method, B+ Trees

Lecture 07 - Static and Dynamic Hashing Indexing

Lecture 08 - External Sorting, Merge Sort, Double Buffering, Replacement Sort

Lecture 09 - Query Optimizers, Query Evaluation

Lecture 10 - Normal Forms

Lecture 11 - Query Analysis and Optimizing in Oracle

References

Database Management System
Instructor: Ravi Jasuja. Course Description. Lecture and Courseware. Student Evaluations. A more formal approach to Relational Database Management Systems, compared the way they were covered during Web Applications.