Advance Database Management Systems (BCA302) crash course, Online BCA, Semester 3:
This subject covers relational design theory and normalization, PL/SQL programming from basic blocks to cursors, triggers, procedures and packages, query…
- 21 video lessons
- 6h 53m
- Study notes
- 105 quiz questions
- Assignment
21 lessons in Advance Database Management Systems
Each lesson pairs one topic with a hand-picked video, trimmed to the part that teaches it.
About this subject
This subject covers relational design theory and normalization, PL/SQL programming from basic blocks to cursors, triggers, procedures and packages, query optimization, database integrity and security, and object and object-relational databases. After it you will be able to normalize schemas, write and debug PL/SQL programs, reason about how queries are optimized and protected, and model data using object-relational features in SQL/Oracle.
- 1
Functional Dependencies
Module I, Design Theory for Relational Database: Functional Dependencies
Lec-27: Functional Dependency & its properties in DBMS in HINDI· Gate Smashers· 17 min
Study notes 5 quiz questionsWatch lesson - 2
Decomposition and Normal Forms
Module I, Design Theory for Relational Database: Decomposition of Relation Schemes, Normal Forms for Relations, Schemes
Lec-33: All Normal Forms with Real life examples | 1NF 2NF 3NF BCNF 4NF 5NF | All in One· Gate Smashers· 10 min
Study notes 5 quiz questionsWatch lesson - 3
Multivalued Dependencies and 4NF
Module I, Design Theory for Relational Database: Multivalued and other kinds of Dependencies
L80: Multivalued dependency & fourth normal form· IIT Madras - B.S. Degree Programme· 27 min
Study notes 5 quiz questionsWatch lesson - 4
Transactions and Concurrency Control
Module I, Design Theory for Relational Database: Transactions and Concurrency Control
L59 : Transaction and Concurrency Control | Complete DBMS Course· Riti Kumari· 11 min
Study notes 5 quiz questionsWatch lesson - 5
PL/SQL Introduction: Blocks and Architecture
Module II, Basics of PL/SQL: PL/SQL basics, blocks, architecture
Lec-86: Introduction to PL-SQL in DBMS· Gate Smashers· 6 min
Study notes 5 quiz questionsWatch lesson - 6
PL/SQL Variables, Constants and Data Types
Module II, Basics of PL/SQL: variables, constants, attributes, character set, data types
PL/SQL tutorial 2 : PL/SQL Variables in Oracle Database By Manish Sharma RebellionRider· Manish Sharma· 5 min
Study notes 5 quiz questionsWatch lesson - 7
SQL Joins and Their Types
Module II, Basics of PL/SQL: JOIN and its types with queries
Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11· Rishabh Mishra· 20 min
Study notes 5 quiz questionsWatch lesson - 8
PL/SQL Control Structures: IF, CASE and Loops
Module II, Basics of PL/SQL: control structure, conditional and sequential control statements
PLSQL Conditional Statement | Learn Coding· Learn Coding· 15 min
Study notes 5 quiz questionsWatch lesson - 9
PL/SQL Cursors and Precompiler
Module III, Advanced PL/SQL: PL/SQL precompiler, cursors, type of cursors
L101: PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor | DBMS Lectures· Easy Engineering Classes· 15 min
Study notes 5 quiz questionsWatch lesson - 10
Exception Handling in PL/SQL
Module III, Advanced PL/SQL: exceptions
PLSQL Exception Handling | Learn Coding· Learn Coding· 12 min
Study notes 5 quiz questionsWatch lesson - 11
Indexes and Views in Oracle
Module III, Advanced PL/SQL: Indexing, View
Lec-125: View in Database | Oracle, SQL Server Views | Types of Views· Gate Smashers· 13 min
Study notes 5 quiz questionsWatch lesson - 12
Triggers, Stored Procedures and Packages
Module III, Advanced 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 - 13
Query Optimization Strategies and Algebraic Manipulation
Module IV, Query Optimization and Database Protection: Basic Optimization Strategies, Algebraic Manipulation, Optimization of Selections in System
48. What is Query Optimization in a Database Management System #dbms #queryoptimization· Constant Learners· 11 min
Study notes 5 quiz questionsWatch lesson - 14
Exact Optimization and Weak Equivalence
Module IV, Query Optimization and Database Protection: Exact Optimization for a Subset of Relational Queries, Optimization under Weak Equivalence
Query Optimization | SQL Query Optimization with Examples· Gate Smashers· 2 min
Study notes 5 quiz questionsWatch lesson - 15
Database Integrity and Constraints in QBE
Module IV, Query Optimization and Database Protection: Integrity, Constraints in Query-by-Example
L3.3 Integrity Constraints | Domain, Entity Integrity, Referential Integrity & Key Constraints |DBMS· Shanu Kuttan CSE Classes· 15 min
Study notes 5 quiz questionsWatch lesson - 16
Database Security and Statistical Databases
Module IV, Query Optimization and Database Protection: Security, Security in Query-by-Example, Security in Statistical Databases
DBMS Data Security (Authentication & Authorization) | Learn Coding· Learn Coding· 9 min
Study notes 5 quiz questionsWatch lesson - 17
Object Database Concepts and Object Identity
Module V, Object and Object Relational Databases: Concepts for Object Databases, Object Identity, Object structure, Type Constructors
ADVANCED DATABASE CONCEPTS- PART 1(OBJECT ORIENTED DATABASES - BASIC CONCEPTS)· Dr. Paul P Mathai· 44 min
Study notes 5 quiz questionsWatch lesson - 18
Encapsulation, Methods and Persistence
Module V, Object and Object Relational Databases: Encapsulation of Operations, Methods, Persistence
ADVANCED DATABASE CONCEPTS-PART 3(OBJECT ORIENTED DATABASES - ENCAPSULATION,PERSISTENCE,INHERITANCE)· Dr. Paul P Mathai· 35 min
Study notes 5 quiz questionsWatch lesson - 19
Type Hierarchies, Inheritance and Complex Objects
Module V, Object and Object Relational Databases: Type and Class Hierarchies, Inheritance, Complex Objects
ADVANCED DATABASE CONCEPTS-PART 3(OBJECT ORIENTED DATABASES - ENCAPSULATION,PERSISTENCE,INHERITANCE)· Dr. Paul P Mathai· 17 min
Study notes 5 quiz questionsWatch lesson - 20
ODMG Model, ODL and OQL
Module V, Object and Object Relational Databases: Object Database Standards, Languages and Design: ODMG Model, ODL, OQL
ADVANCED DATABASE CONCEPTS-PART 5(OBJECT ORIENTED DATABASES - ODMG MODEL (ODL & OQL)· Dr. Paul P Mathai· 65 min
Study notes 5 quiz questionsWatch lesson - 21
Object-Relational Features in SQL/Oracle
Module V, Object and Object Relational Databases: Object Relational and Extended – Relational Systems, Object Relational features in SQL/Oracle – Case Studies
ADVANCED DATABASE CONCEPTS-PART 6(OBJECT RELATIONAL & EXTENDED RELATIONAL SYSTEMS)· Dr. Paul P Mathai· 57 min
Study notes 5 quiz questionsWatch lesson
Assignment
Mini Project: Designing and Programming a College Library Database
Less scrolling. More passing.
- Free
Hand-picked video lessons
21 short lessons, each with the best YouTube explanation we could find, trimmed to the part that matters.
- Free login
Study notes
21 lessons come with a summary, key points, key terms and takeaways for quick revision.
- Free login
Quizzes
105 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.
The Online BCA live chat. Study together, live.
A live chat right beside the video, shared by everyone studying Online BCA. Ask a Advance Database Management Systems doubt mid-lesson, share a shortcut, celebrate a finished semester.
- Live chat beside every lesson
- One live chat for all of Online BCA
- Members-only stickers & GIFs
- One ₹19 pass opens every live chat
Online BCA live chat
Anyone else finding Advance Database Management Systems tricky? 😅
Lesson 2 cleared it up for me. Watch it before the quiz
Doing it now, thanks!
Starting Advance Technologies in Computer Science tonight if anyone wants to go together
More from Online BCA Semester 3
All subjects- Sem 3
BCI333
Advance Technologies in Computer Science
This subject introduces emerging areas of computer science: soft computing, green computing, the Internet of Things, civic technology, and newer computing…
- 16 lessons
- 2h 38m
- Notes
- Quiz
- Sem 3
BCA301
Computer Oriented Statistical & Optimization Methods
This subject covers descriptive statistics, correlation and regression, probability and probability distributions, and the optimization techniques of linear…
- 18 lessons
- 10h 36m
- Notes
- Quiz
- Sem 3
EVS001
Environmental Studies
This subject covers natural resources, ecosystems, biodiversity, environmental pollution, social and legal issues of the environment, and the links between…
- 23 lessons
- 6h 3m
- Notes
- Quiz
- Sem 3
BCI303
Object Oriented Programming Concepts Using C++
This subject teaches object oriented programming in C++, from basic syntax, data types, loops, decisions and functions through structures, classes, operator…
- 22 lessons
- 5h 47m
- Notes
- Quiz
- Sem 3
BCI332
Web Designing
This subject teaches how web pages are built with HTML, styled with CSS, enhanced with images and SVG graphics, and published on a web host.
- 17 lessons
- 5h 33m
- Notes
- Quiz
- Sem 3
BCI331
Working at a Small-to-Medium Business or ISPs
This subject covers how the Internet and ISPs work, how an ISP help desk troubleshoots problems using the OSI model, and how a small-to-medium business plans a…
- 20 lessons
- 4h 28m
- Notes
- Quiz
Advance Database Management Systems: common questions
This subject covers relational design theory and normalization, PL/SQL programming from basic blocks to cursors, triggers, procedures and packages, query optimization, database integrity and security, and object and object-relational databases. After it you will be able to normalize schemas, write and debug PL/SQL programs, reason about how queries are optimized and protected, and model data using object-relational features in SQL/Oracle. It's the Advance Database Management Systems subject of Online BCA, Semester 3, in 21 lessons: Functional Dependencies; Decomposition and Normal Forms; Multivalued Dependencies and 4NF; Transactions and Concurrency Control; PL/SQL Introduction: Blocks and Architecture; PL/SQL Variables, Constants and Data Types; SQL Joins and Their Types; PL/SQL Control Structures: IF, CASE and Loops; PL/SQL Cursors and Precompiler; Exception Handling in PL/SQL; Indexes and Views in Oracle; Triggers, Stored Procedures and Packages; Query Optimization Strategies and Algebraic Manipulation; Exact Optimization and Weak Equivalence; Database Integrity and Constraints in QBE; Database Security and Statistical Databases; Object Database Concepts and Object Identity; Encapsulation, Methods and Persistence; Type Hierarchies, Inheritance and Complex Objects; ODMG Model, ODL and OQL; Object-Relational Features in SQL/Oracle.
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 6h 53m of video across 21 lessons, plus time for notes and quizzes. Go at your own pace; your place is saved.
Yes: “Mini Project: Designing and Programming a College Library Database”. 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 BCA, 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.