0(0)

Database Management System

Description

Spread the love

The objective of the course is to present an introduction to database management systems, with an
emphasis on how to organize, maintain and retrieve – efficiently, and effectively – information from a
DBMS.

What Will I Learn?

  • Upon successful completion of this course, students should be able to:
  • • 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.
  • • Design ER-models to represent simple database application scenarios
  • • Convert the ER-model to relational tables, populate relational database and formulate SQL
  • queries on data.
  • • Improve the database design by normalization.
  • • Familiar with basic database storage structures and access techniques: file and page
  • organizations, indexing methods including B tree, and hashing.

Topics for this course

19 Lessons50h

Introduction

Relational data Model and Language

Data Base Design & Normalization

Transaction Processing Concept

Concurrency Control Techniques

Free
Live WhatsApp Chat
Send via WhatsApp
Close Bitnami banner
Bitnami