People Innovation Excellence


Learning Outcomes:

On successful completion of this course, students will be able to: identify identify and extract information from a business process; demonstrate Demonstrate Advanced Database Design techniques Relationship, Normalization; apply Apply Advanced Database Design techniques (Arcs, Hierarchies, and Recursive Modeling); identify row and column data from tables with the SELECT statement; express Business need for combining information from multiple data sources; apply Advanced SQL data retrieval techniques to retrieve data from database tables.


  1. Introduction Database Design;
  2. Entities and Attributes;
  3. Relationship Basics;
  4. Super/Sub Types and Business Rules;
  5. Relationship Fundamentals;
  6. UIDs and Normalization;
  7. Arcs, Hierarchies, and Recursive Modeling;
  8. Changes and Historical Modeling;
  9. Mapping;
  10. Creating Database Projects;
  11. Presenting Database Projects;
  12. Introduction SQl Express;
  13. SELECT and WHERE;
  14. WHERE, ORDER BY, and Intro to Functions;
  15. Single Row Functions Part I;
  16. Single Row Functions Part II;
  17. JOINs Part I;
  18. JOINs Part II;
  19. Group Functions Part I;
  20. Group Functions Part II;
  21. Subqueries;
  22. DML;
  23. DDL;
  24. Constraints;
  26. Sequences and Synonyms;
  27. Privileges and Regular Expressions;
  28. TCL;
  29. Final Project SQL.

Published at :

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