People Innovation Excellence

DATABASE SYSTEMS (4/2 credits)

Learning Outcomes:

On completion this course, students will be able to: LO1 – describe database systems, terminologies, environment, and new concepts of database; LO2 – apply database languages and SQL Programming languages; LO3 – design database using structured data model; LO4 – perform database processing and security mechanism.

Topics:

  1. Introduction To Database;
  2. Database Environment;
  3. Database Architectures and the Web;
  4. The Relational Model;
  5. Relational Algebra and Relational Calculus;
  6. SQL – Data Definition Language (Table, Index);
  7. SQL – Data Manipulation Language (Basic Queries);
  8. SQL – Data Manipulation Language (Advanced Queries);
  9. SQL – Data Definition Language (View);
  10. Advanced SQL;
  11. Database System Development Lifecycle;
  12. Database Analysis;
  13. Transaction Management;
  14. Normalization;
  15. Advanced Normalization;
  16. Security and Administration;
  17. Distributed DBMS-Concept and Design;
  18. Entity Relationship (ER) Modelling; Enhanced Entity Relationship (ER) Modelling;
  19. Data Warehousing Concepts;
  20. Data Mining;
  21. Normalization & Entity Relationship (ER) Modelling;
  22. SQL – Data Definition (1);
  23. SQL – Data Manipulation (1);
  24. SQL – Data Manipulation (2);
  25. Quiz & SQL – Data Manipulation (2);
  26. SQL – Data Manipulation (2);
  27. SQL –Data Definition (2);
  28. Advanced SQL;
  29. Database Environment;
  30. Project.

 


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