Database Management System (ArsDigita University). Instructor: Ravi Jasuja.
0
2
September 25, 2023
English
English [CC]
Description
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 Curriculum
- 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
About the instructor
Instructor Rating
Reviews
Courses
Students
Hours of videos
305 years, 6 months
Units & Quizzes
Unlimited Lifetime access
Access on mobile app
Certificate of Completion
- For teams of 2 or more users
- 27,000+ fresh & in-demand courses
- Learning Engagement tools
- SSO and LMS Integrations
