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
- Introduction to database systems
- Relational databases - Designing
- SQL
- Big data
- 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.