Skip to content

Latest commit

 

History

History
39 lines (30 loc) · 1.22 KB

README.md

File metadata and controls

39 lines (30 loc) · 1.22 KB

Home > Databases and data storages

Module: Databases and data storages

Introduce Database Management Systems.

Duration
~ 10 weeks
Lectures
~ 19 hours
Self Learning
~ 18 hours
Tutorial & Labs
~ 50 hours
Topics
8

Introduction

A database management system (DBMS) refers to the technology for creating and managing databases. DBMS is a software tool to organize (create, retrieve, update, and manage) data in a database.

Topics

  1. Introduction to database systems
  2. Relational databases - Designing
  3. SQL
  4. Big data
  5. Data warehousing and cloud technologies

Learning Outcomes

  • 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.