People Innovation Excellence

DATABASE FUNDAMENTAL (4/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to:

  1. Describe terminologies, concepts, and environment of relational model in database systems
  2. Recognize database objects, the privileges in database security, and database transactions
  3. Apply Structured Query Language that is suitable for the problem

Topics :

  1. Database Systems and Data Models
  2. The Relational Database Model and The Entity-Relationship Diagram
  3. Data Definition Language
  4. Constraints
  5. Database Security, Privileges, and Transaction Control Language
  6. Data Manipulation Language
  7. Basic SELECT Queries
  8. Single Row Functions
  9. JOINs
  10. Group Functions
  11. Subqueries
  12. Views
  13. Sequences and Synonyms, and Regular Expressions
  14. The Relational Database Model and The Entity-Relationship Diagram
  15. Constraints
  16. Database Security, Privileges, and Transaction Control Language
  17. Data Manipulation Language
  18. Basic SELECT Queries
  19. Single Row Functions
  20. JOINs, Sequences, Synonyms, and Regular Expressions
  21. Group Functions
  22. Subqueries
  23. Views
  24. Data Definition Language

 

Published at : Updated
SHARE THIS

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