InsideEdgeInsideEdge
Semester 1MCA103

Advanced Database Management System (MCA103) crash course, Online MCA, Semester 1:

This subject covers PL/SQL programming (blocks, cursors, exceptions, triggers, procedures and packages) along with distributed, parallel and object-oriented…

  • 18 video lessons
  • 5h 37m
  • Study notes
  • 90 quiz questions
  • Assignment
Enroll nowSee the lessons
Advanced Database Management System crash course

18 lessons in Advanced Database Management System

Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.

About this subject

This subject covers PL/SQL programming (blocks, cursors, exceptions, triggers, procedures and packages) along with distributed, parallel and object-oriented database systems. After it you will be able to write PL/SQL programs for real database tasks and explain how data is fragmented, replicated, processed in parallel and modelled as objects in advanced DBMS designs.

  1. 1

    PL/SQL Basics, Blocks and Architecture

    Module I, Basics of PL/SQL: PL/SQL basics, blocks, architecture, character set, PL/SQL

    PL sql concepts | DBMS | Lec-40 | Bhanu Priya· Education 4u· 11 min

    Study notes 5 quiz questionsWatch lesson
  2. 2

    PL/SQL Variables, Constants, Attributes and Data Types

    Module I, Basics of PL/SQL: variables, constants, attributes, data types

    Master Oracle PL/SQL in One Video | Beginner to Advanced (2026) [HINDI] | MPrashant· MPrashant TECH· 22 min

    Study notes 5 quiz questionsWatch lesson
  3. 3

    PL/SQL Control Structures

    Module I, Basics of PL/SQL: control structure, conditional and sequential control statements

    PL/SQL Control Structure | Controlling Program Flow in RDBMS· Being A Programmer · 13 min

    Study notes 5 quiz questionsWatch lesson
  4. 4

    PL/SQL Precompiler and Cursors

    Module II, Pl/sql: PL/SQL precompiler, cursors, type of cursors

    Lec-138: What is Cursor in PL-SQL with example· Gate Smashers· 12 min

    Study notes 5 quiz questionsWatch lesson
  5. 5

    Exception Handling in PL/SQL

    Module II, Pl/sql: exceptions

    PLSQL Exception Handling | Learn Coding· Learn Coding· 12 min

    Study notes 5 quiz questionsWatch lesson
  6. 6

    Indexing and Views in SQL

    Module II, Pl/sql: Indexing, View

    Lec-107: Why Indexing is used | Indexing Beginning | DBMS· Gate Smashers· 10 min

    Study notes 5 quiz questionsWatch lesson
  7. 7

    Triggers, Stored Procedures and Packages

    Module II, Pl/sql: triggers, PL/SQL Stored procedures and packages

    Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure· Gate Smashers· 7 min

    Study notes 5 quiz questionsWatch lesson
  8. 8

    Distributed Databases: Introduction and Architecture

    Module III, Distributed Databases: Introduction, Advantages, Architecture, Homogeneous & Heterogeneous DDBMS

    Introduction to Distributed Database in Hindi | DDB tutorials #1· Last moment tuitions· 19 min

    Study notes 5 quiz questionsWatch lesson
  9. 9

    Fragmentation and Replication

    Module III, Distributed Databases: Distributed Data Storage (Fragmentation & Replication)

    L127: Types of Distributed Databases | Data Storage (Fragmentation, Replication) | Transparency· Easy Engineering Classes· 17 min

    Study notes 5 quiz questionsWatch lesson
  10. 10

    Distributed Transactions and Two-Phase Commit

    Module III, Distributed Databases: Distributed Transactions, Commit protocol

    DS38: Distributed Transactions: Atomic Commit protocols| two phase commit in distributed database· University Academy· 10 min

    Study notes 5 quiz questionsWatch lesson
  11. 11

    Distributed Concurrency Control and Query Processing

    Module III, Distributed Databases: Concurrency Control in Distributed Databases, Availability, Distributed Query Processing

    L128: Query Processing & Optimization in Distributed Database | Query Processing Steps, Query Blocks· Easy Engineering Classes· 16 min

    Study notes 5 quiz questionsWatch lesson
  12. 12

    Parallel Databases: Architecture and I/O Parallelism

    Module IV, Parallel Databases: Introduction, Architecture, I/O Parallelism and Skew

    DBMS 40 : Parallel Database Architecture with Examples· CS & IT Tutorials by Vrushali 👩‍🎓· 12 min

    Study notes 5 quiz questionsWatch lesson
  13. 13

    Inter-query and Intra-query Parallelism

    Module IV, Parallel Databases: Inter-query Parallelism, Intra-query Parallelism

    Interquery Parallelism and Intraquery Parallelism in Query Processing· WIT Solapur - Professional Learning Community· 12 min

    Study notes 5 quiz questionsWatch lesson
  14. 14

    Parallel Sort, Parallel Join and Parallel System Design

    Module IV, Parallel Databases: Intra-operation Parallelism (Parallel Sort, Parallel Join), Interoperation Parallelism, Design of Parallel Systems

    ADVANCED DATABASE CONCEPTS- PART 5(PARALLEL DATABASES- INTER&INTRA-QUERY PARALLELISM (PARALLEL JOIN)· Dr. Paul P Mathai· 59 min

    Study notes 5 quiz questionsWatch lesson
  15. 15

    Object-Oriented Data Model

    Module V, Object Oriented Database Management System: Introduction, Object-Oriented Data Model

    Object Oriented Data Model in DBMS in Hindi | Advantages & Disadvantages - Lecture #6· The Crazy Programmer· 19 min

    Study notes 5 quiz questionsWatch lesson
  16. 16

    Object-Oriented and Persistent Programming Languages

    Module V, Object Oriented Database Management System: Object Oriented Languages, Persistent Programming Languages

    Object Oriented Databases· Centre for Climate Change & Water Research, SGVU· 43 min

    Study notes 5 quiz questionsWatch lesson
  17. 17

    Object-Relational Databases: Nested Relations and Complex Types

    Module V, Object Oriented Database Management System: Object-Relational Databases: Nested Relations, Complex Types, Inheritance, Reference Types

    Structured Types & Inheritance in SQL - Object Based Databases - Database Management System· Ekeeda· 20 min

    Study notes 5 quiz questionsWatch lesson
  18. 18

    Querying Complex Types and Object Storage

    Module V, Object Oriented Database Management System: Querying with Complex Types, Functions and Procedures, Storage for Object Databases

    ORDBMS implementation issues: storage and access, query processing· Radhika Sarath· 23 min

    Study notes 5 quiz questionsWatch lesson

Assignment

Library Loans: PL/SQL, Distribution, Parallelism and Object Design

Free login to open
What you get

Less scrolling. More passing.

  • Free

    Hand-picked video lessons

    18 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.

  • Free login

    Study notes

    18 lessons come with a summary, key points, key terms and takeaways for quick revision.

  • Free login

    Quizzes

    90 questions across the course, with the right answer and why, the moment you pick.

  • Free login

    Assignments

    1 subject assignments with clear tasks, so you practise what each subject actually asks of you.

  • Free login

    Notebook

    Write notes beside the video, stamped with the exact time, and jump back to that moment later.

  • Free login

    Progress that follows you

    Completed lessons, quiz scores and where you stopped, saved to your account on every device.

  • Live chat pass

    Live chat

    A members-only live chat beside every lesson: doubts, tips, stickers and GIFs with your batch. One ₹19 pass opens every live chat.

Members only

The Online MCA live chat. Study together, live.

A live chat right beside the video, shared by everyone studying Online MCA. Ask a Advanced Database Management System doubt mid-lesson, share a shortcut, celebrate a finished semester.

  • Live chat beside every lesson
  • One live chat for all of Online MCA
  • Members-only stickers & GIFs
  • One ₹19 pass opens every live chat
Open the live chat
Pass₹19

More from Online MCA Semester 1

All subjects

Advanced Database Management System: common questions

This subject covers PL/SQL programming (blocks, cursors, exceptions, triggers, procedures and packages) along with distributed, parallel and object-oriented database systems. After it you will be able to write PL/SQL programs for real database tasks and explain how data is fragmented, replicated, processed in parallel and modelled as objects in advanced DBMS designs. It's the Advanced Database Management System subject of Online MCA, Semester 1, in 18 lessons: PL/SQL Basics, Blocks and Architecture; PL/SQL Variables, Constants, Attributes and Data Types; PL/SQL Control Structures; PL/SQL Precompiler and Cursors; Exception Handling in PL/SQL; Indexing and Views in SQL; Triggers, Stored Procedures and Packages; Distributed Databases: Introduction and Architecture; Fragmentation and Replication; Distributed Transactions and Two-Phase Commit; Distributed Concurrency Control and Query Processing; Parallel Databases: Architecture and I/O Parallelism; Inter-query and Intra-query Parallelism; Parallel Sort, Parallel Join and Parallel System Design; Object-Oriented Data Model; Object-Oriented and Persistent Programming Languages; Object-Relational Databases: Nested Relations and Complex Types; Querying Complex Types and Object Storage.

Yes. Every video lesson is free to watch without an account. A free login unlocks study notes, quizzes, the assignment, a notebook and progress that syncs across devices.

About 5h 37m of video across 18 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.

Yes: “Library Loans: PL/SQL, Distribution, Parallelism and Object Design”. It comes after the last lesson, with a brief, clear tasks and how the work is judged.

A members-only live chat beside the video, shared by everyone studying Online MCA, where learners ask doubts, share tips and react with stickers and GIFs. One ₹19 pass, paid once from your InsideEdge wallet, opens the live chat for every degree.

No. It's a crash course to help you understand and revise the subject quickly. Use it alongside your official study material and assignments.

Enroll now