Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Introduction to Database Management Systems (DBMS)
Rating: 4.3 out of 5(159 ratings)
3,932 students

Introduction to Database Management Systems (DBMS)

Learn Fundamental Concepts of Database Management from scratch
Created byEdoreal Learning Solutions
Last updated 8/2019
English
English [Auto],

What you'll learn

  • Introduction to DBMS
  • Why we need DBMS
  • History of Database Systems
  • Data abstraction and database languages
  • Database schema and Instances
  • Transaction Management
  • Data independence
  • Database Architecture
  • Data Mining & Information Retrieval
  • Database Design Process
  • Database Design Process
  • Basic Terms In Database Design
  • Conceptual Design : Case Study
  • Refining The Conceptual Design
  • Additional Features of ER Model
  • Constraints on Specialization & Generalization
  • Specialization & Generalization Hierarchies & Lattices

Course content

2 sections • 18 lectures • 1h 2m total length

  • Introduction to DBMS2:05

    Explore how database management systems and databases power apps. They handle vast data—from banking and telecom to social media—covering traditional textual and numeric data, multimedia, gis, and big data systems.

  • Question-1
  • Question-2
  • Why we need DBMS3:13

    Explore how a database management system—developed since the 1960s—solves traditional file processing problems by organizing data with catalogs and metadata to reduce duplication and inconsistency.

  • Question-3
  • Question-4
  • History of Database Systems3:00

    Trace the evolution from flat files to networked, relational, and object-relational databases, then NoSQL and big data, and grasp data models, schemas, and instances across conceptual, representational, and physical levels.

  • Data abstraction and database languages3:47

    Explore data abstraction and data independence, including program independence and operation independence, at the physical, logical, and view levels, with a data dictionary and language roles.

  • question-5
  • question-6
  • Database schema and Instances2:34

    Define database schemas and instances, highlighting how a database state changes with every update. Explore schema evolution and the three-level architecture: internal, conceptual, and external.

  • question-7
  • question-8
  • Transaction Management1:29

    Define a transaction as a program that performs reading or updating records. Ensure it completes or fails completely, preserving consistency, isolation, and durability under concurrent execution.

  • question-9
  • question-10
  • Data independence3:37

    Explain data independence by distinguishing logical independence and physical independence. Enable changes to the conceptual and internal schema without altering external views or applications.

  • question-11
  • question-12
  • Database Architecture4:31

    Explore centralized and client-server database architectures, noting centralized remote processing versus distributed client work. Understand the three-tier web architecture with presentation, business logic, and database services layers.

  • question-13
  • question-14
  • Data Mining & Information Retrieval3:35

    Learn data mining to extract, cleanse, transform, and visualize data using clustering, regression, and classification, and explore information retrieval ranking of structured, semi-structured (JSON, XML), and unstructured text.

  • question-15
  • question-16

Requirements

  • Basic Computer knowledge

Description

Information is not useful if not organized. In database, data is organized in a way that people find it meaningful and useful. Database Management System (DBMS) is used to input, sort, organize and store data.

Database Management System (DBMS) is a Software for data storage & retrieval, for creating user interface (forms), reports, and for administering a DB system (security, access, etc.).  An implementation of a DBMS product to support various information needs in a company includes one or more databases, logic (business rules), backend code and user interface.

An information system that is built from “applying” a DBMS or a database to a specific domain, supports specific information needs.

Who this course is for:

  • Any person who is willing to learn Fundamentals of Database Sysytems

Report abuse