Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Advanced Database Management Systems CSE5003

Satish C J via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore advanced concepts in database management systems through this comprehensive video lecture series covering parallel databases, distributed systems, and NoSQL technologies. Master parallel database architectures including I/O parallelism, data partitioning strategies such as range partitioning, and understand partition skew challenges. Learn various join algorithms including nested loop, hash join, and sort merge join implementations in parallel environments. Examine Oracle's degree of parallelism concepts and parallel sorting techniques on partitioned tables. Dive into distributed database management systems and understand replication mechanisms using triggers and the two-phase commit protocol for maintaining consistency across distributed environments. Study XML databases and XQuery for handling semi-structured data, then transition to NoSQL database fundamentals including different data models, the CAP theorem, and BASE properties that govern modern distributed database systems.

Syllabus

Advanced Database Management Systems #1 Parallel Databases
Advanced DBMS #2 I/O parallelism , Data Partitioning
Advanced DBMS #3 Range Partitioning, Partition Skew
Advanced DBMS #4 Nested Loop and Hash Join
Advanced DBMS #5 Sort Merge Join
Advanced DBMS #6 Degree of Parallelism ( Oracle), Parallel Sort
Advances DBMS #7 Parallel range sort on Partitioned Table
Advanced DBMS #8 Parallel Hash Join and Parallel Nested Loop Join
Advanced Database Management Systems #9 Distributed Database Management Systems
Advanced DBMS #10 Triggers
Advanced DBMS #11 Replication in Distributed Databases using Triggers
Advanced DBMS #12 Two Phase Commit Protocol (2PC) In Distributed Systems
Advanced DBMS # 13 XML Databases
Advanced Database Management Systems #14 XML Database - XQuery
NoSQL Databases #1 (Data Models, CAP Theorem, BASE Property)

Taught by

Satish C J

Reviews

Start your review of Advanced Database Management Systems CSE5003

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.