People Innovation Excellence

INTRODUCTION TO DATABASE SYSTEMS (2/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Describe concepts, terminologies, environment, and relational model in database system; Apply user role and right access to increase security in database system; Construct query of SQL that suitable with the problem; Design database using structured data model; Recognize database technology concept.

Topics:

  1. Introduction to Databases
  2. Database Architectures & The Relational Model
  3. SQL – Data Definition
  4. SQL – Data Manipulation (Basic Queries 1)
  5. Security and Administration
  6. SQL – Data Manipulation (Basic Queries 2)
  7. SQL – Data Definition & Data Manipulation Exercise
  8. SQL – Data Manipulation (Multi table Queries)
  9. SQL – Data Manipulation (Sub Queries) and View
  10. Normalization
  11. Entity Relationship (ER) Modelling
  12. Enhanced Entity-Relationship Modelling
  13. Data Warehousing Concepts
  14. Database Environment
  15. Security and Administration
  16. SQL – Data Definition
  17. SQL – Data Manipulation (Basic Queries 1)
  18. Online Quiz
  19. SQL – Data Manipulation (Basic Queries 2)
  20. SQL – Data Manipulation (Multi Table Queries)
  21. SQL – Data Manipulation (Sub Queries)
  22. View
  23. Normalization & ER Modelling
  24. Project Collection.

Published at : Updated

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9
Close