Home > Working with Data

Module: Working with Data

Introduce Database Management Systems and APIs.

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.

API is an abbreviation for Application Programming Interface which is a collection of communication protocols and subroutines used by various programs to communicate between them. A programmer can make use of various API tools to make its program easier and simpler. Also, an API facilitates the programmers with an efficient way to develop their software programs.

Topics

1. Introduction to database systems
2. Relational databases - Designing
3. RDBMS SQL
4. Big data
5. What is an API
6. API concepts
7. Develop an API
8. API Security

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.
• Design APIs and expose data to other applications