Introduction to Database Systems

Introduction to Database Systems

Database Architecture, SQL, Normalization, ER Modeling

Author(s)

  • Edi Purnomo Putra, S.Kom., M.MSI
  • Lay Christian, S.Kom., M.MSI

The Managing Department

  • School of Information Systems

Category

  • Development

Language

English

Course Description

In computing, a database is an organized collection of data stored and accessed electronically from a computer system. Where databases are more complex, they are often developed using formal design and modeling techniques.

The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum of the total in the database, the DBMS and the associated applications can be referred to as a “database system”. Often the term “database” is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.

This course introduces concepts and terminologies in database system, like database architecture, relational model, Structured Query Language (SQL), security issues in database environment, normalization technique, ER modeling, and database technologies like Data warehouse concept. It gives student basic knowledge about how to create and modify tables that appropriate to the requirements of organization.

The content format for this course mainly learns from video and take a quiz to assessment knowledge for the course. Total duration for this course is one hour. Short enough for the duration of the learning time, compact and simple to understand.

Course Topics

  1. Introduction to Databases
  2. Database environment
  3. The Relational Model
  4. Entity Relational Model
  5. Functional Dependency
  6. Normalization
  7. SQL-Data Definition (1)
  8. SQL-Data Definition (2)
  9. SQL-Data Manipulation (1)
  10. SQL-Data Manipulation (2)