0

(

ratings

)

2

students

Created by:

Profile Photo

Last updated:

September 25, 2023

Duration:

Unlimited Duration

FREE

This course includes:

Unlimited Duration

Badge on Completion

Certificate of completion

Unlimited Duration

Description

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)

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

5 5

Instructor Rating

6

Reviews

4637

Courses

24151

Students

Profile Photo
OpenCoursa
We are an educational and skills marketplace to accommodate the needs of skills enhancement and free equal education across the globe to the millions. We are bringing courses and trainings every single day for our users. We welcome everyone woth all ages, all background to learn. There is so much available to learn and deliver to the people.