Introduction to Database Management Systems (DBMS)

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

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