Database Management Systems(DBMS)

Learn Database Management Systems(DBMS) the exam way—clear concepts, worked examples, and 83 focused lessons in database systems.

Instructor: DAKALA SREENIVASULU

Last updated Aug 2026 en

26 learners enrolled

all-levels

This course includes

— on-demand video
Access on mobile & desktop
Full lifetime access
Certificate of completion

Course content

13 sections · 83 lectures

Lec-01 : Introduction Preview
Lec-02 : what is database
Lec-03 : Components of data base systems
Lec-04 : Building blocks & Applications | DBMS
Lec-05 : Architecture | DBMS
Lec-06 : Structure | DBMS
Lec-07 : Database users in dbms with example
Lec-08 : Data independence

Lec-09: Attributes Preview
Lec-10 : Attributes types
Lec-11 : ER Diagrams Components
Lec-12 : ER model to Relational model
Lec-13 : Mapping relationship
Lec-14 : Mapping weak entity & Hierarachy entity
Lec-15 : Relational model
Lec-16 : Constraints

Lec-17 : Keys in database Preview
Lec-18 : Super key
Lec-19 : Candidate key
Lec-20 : Primary key
Lec-21 : Foreign key
Lec-22 : Secondary key
Lec-23 : Composite Key

Lec-24 : Relational algebra Preview
Lec-25 : Operations on Relational algebra
Lec-26 : Select operation
Lec-27 : Projection operation
Lec-28 : Set difference operation
Lec-29 : Union operation
Lec-30 : Castesian product operation | Cross product

Lec-31 : SQL introduction Preview
Lec-32 : SQL Joins with examples
Lec-33 : Outer Join in SQL with examples
Lec-34 : Outer join | Left, Right & Full

Lec-35 : Aggregate functions Preview
Lec-36 : DDL : CREAT, DROP | SQL commands
Lec-37 : DDL : ALTER, RENAME & TRUNCATE | SQL commands
Lec-38 : DML in sql with examples
Lec-39 : DCL: GRANT, REVOKE | SQL Commands

Lec-40 : PL/SQL concepts Preview
Lec-41 : PL/SQL example
Lec-42 : Triggers | Introduction & Syntax
Lec-43 : Triggers with example
Lec-44 : Functional dependency
Lec-45 : Fully functional dependency
Lec-46 : decomposition in dbms
Lec-47 : lossless decomposition in dbms

Lec-48 : Normalization Preview
Lec-49 : 1NF Databse Normalization example
Lec-50 : 2NF Databse Normalization example
Lec-51 : 3NF Databse Normalization example
Lec-52 : BCNF Databse Normalization example
Lec-53 : 4NF Databse Normalization example

Lec-54 : Relational calculus in dbms Preview
Lec-55 : Tuple relational calculus in dbms
Lec-56 : Domain relational calculus in dbms
Lec-57 : Transaction management in dbms tutorial
Lec-58 : ACID properties - 1
Lec-59 : ACID properties - 2
Lec-60 : Transaction states in database example

Lec-61 : Concurrency Control Preview
Lec-62 : Lock based Concurrency Control
Lec-63 : Deadlock
Lec-64 : 2PL : Two phase Locking example

Lec-65 : Time stamping method Preview
Lec-66 : Time stamp ordering protocol in database
Lec-67 : Database recovery management
Lec-68 : Physical storage
Lec-69 : File organization - 1| Importance
Lec-70 : File organization - 2 | Importance

Lec-71 : Indexing in database example Preview
Lec-72 : Indexing Classification
Lec-73 : Primary indexing
Lec-74 : Secondary indexing
Lec-75 : Cluster indexing

Lec-76 : B+ tree in database Preview
Lec-77 : B tree | Introduction
Lec-78 : B tree | Example
Lec-79 : Need of query processing
Lec-80 : Query cost measures
Lec-81 : Materialized view in database
Lec-82 : Sorting in database | Algorithm
Lec-83 : Sorting in database | Example

Explore related topics

Computer Science all-levels

Description

Database Management Systems(DBMS) is an exam-focused database systems programme designed for B.Tech / MCA learners and anyone revising CS subjects for semester exams (all levels). Lessons are paced for semester revision and competitive practice, with clear explanations you can replay anytime.

You will connect definitions to exam-style problems in Database Management Systems(DBMS), so you can write clearer answers, dry-run code mentally, and revise units in order. Syllabus highlights include Introduction & Structure, ER diagrams & Relational model, Keys, Relational Algebra, SQL joins, and SQL commands. Across 83 lessons, you will move from foundations to problem-solving patterns that show up in university papers and placement tests.

Taught by DAKALA SREENIVASULU, this course keeps theory short and practice heavy—so you can revise faster, spot examiner cues, and build confidence before mocks and finals.