Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Base Management Systems(DBMS)
Rating: 4.4 out of 5(13 ratings)
270 students

Data Base Management Systems(DBMS)

Learn DBMS, ER Model, Normalization, SQL, Transactions, Indexing, Views, Stored Procedures & Fabric SQL Essentials.
Created bySankara Narayanan S
Last updated 5/2026
English

What you'll learn

  • understand the fundamentals of DBMS and ER model
  • Study about the Relational model
  • Write SQL queries for data retrieval, insertion, update, and deletion.
  • Understand the need for and process of normalizing databases.

Course content

5 sections • 23 lectures • 4h 7m total length

  • Introduction and application of DBMS9:33

    Explore the introduction and applications of database management systems (dbms), define data, information, and knowledge, and explain how sql enables storing, retrieving, and securing interrelated data.

  • Evolution of data models11:06

    Explore the evolution of data models from hierarchical and network models to IR, relational, and object oriented models, highlighting structures, relationships, and trade-offs.

  • Data base system architecture7:53

    explains the database system architecture with four user types and three core components: the query processor, storage manager, and disk storage, and outlines dml and ddl processing.

  • ER model8:25

    Explore how the ER model maps real-world entities to a conceptual schema using entity sets, relationships, attributes, and a primary key, with faculty and student examples.

  • Data Independence5:44

    Explore data independence in DBMS, enabling changes at physical, conceptual, or logical levels without affecting other levels, and distinguish physical data independence from logical data independence.

  • Database users and DBA5:53

    Explore database users, including naive, application programmer, sophisticated, native, specialized, and standalone users, and the role of the database administrator with its privileges and duties.

  • Mapping cardinality7:08

    Explore mapping cardinalities in dbms, including 1 to 1, 1 to many, many to 1, and many to many, and explain total and partial participation constraints.

  • Types of attributes8:10

    Explore the six types of attributes in dbms—simple, composite, single valued, multi-valued, derived, and key attributes—through student table examples.

  • Basic Terminologies of a Database5:14

    Explore terminologies of a database, including tables, rows, columns, primary keys, foreign keys, indexes, and sql queries. Understand normalization, relational databases, transactions with acid properties, schema, and the data dictionary.

  • Introduction

Requirements

  • Basic knowledge about CSE

Description

Nearly all digital services and e-governance solutions rely on databases as their foundation. Database systems and transaction processing are essential to the smooth running of contemporary financial systems and businesses. With the aid of database management systems (DBMS) and the SQL Standard, this course introduces students to the many theoretical and practical aspects involved in the design and use of database systems.

What you'll learn

  • Describe the fundamental elements of relational database management systems.

  • Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL.

  • Able to differentiate physical and logical data independence

  • Design ER-models to represent simple database application scenarios

  • Improve the database design by normalization.

  • Differentiate about various normal forms like 1NF,2NF and 3NF

  • Concurrency control( from scratch to advance).

  • Database indexing ( B and B+ Trees).

  • Able to create complex SQL queries using multiple tables.

  • In-depth knowledge over database design or database engineer.

  • Learn core concepts of database design.

  • Capable to answer any level of competitive exams like GATE, ISRO, PSU's or any other.

  • Write Efficient SQL Queries – Use DDL, DML, subqueries, joins, views, and indexing for performance optimization.

  • Work with Microsoft Fabric SQL – Understand schemas, stored procedures, CTEs, temp tables, and string aggregate functions

Who this course is for:

  • Begineers who wants to learn about DBMS

Report abuse