People Innovation Excellence

APPLIED DATABASE I (4 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Explain Basic Oracle Database; Analyze What is required in database system from the perspective of a particular job role (such as Manager or Supervisor) or enterprise application area (such as marketing, personnel, or stock control); Create SQL commands; Create Advance scripts; Combine PL/SQL commands in procedures and functions; Create Packages

Topics:

  1. Introduction & Select Statement;
  2. Restricting, Sorting Data & Using Single-Row Functions to Customize Output;
  3. Reporting Aggregated Data Using the Group Functions & Displaying Data from Multiple Tables;
  4. Using Sub queries to Solve Queries & SET Operators;
  5. Manipulating Data & Using DDL Statements to Create and Manage Tables;
  6. Creating Other Schema Objects Categorize simple and complex views and compare them;
  7. Managing Objects with Data Dictionary Views; Controlling User Access & Manage Schema Objects;
  8. Manipulating Large Data Sets;
  9. Generating Reports by Grouping Related Data & Managing Data in Different Time Zones;
  10. Hierarchical Retrieval;
  11. Regular Expression Support;
  12. Introduction to PL/SQL & Declaring PL/SQL Identifiers;
  13. Writing Executable Statements & Interacting with the Oracle Server;
  14. Writing Control Structures;
  15. Working with Composite Data Types;
  16. Using Explicit Cursors;
  17. Handling Exceptions & Creating Stored Procedures & Functions;
  18. Introduction PLSQL Dev & Creating Stored Procedures; Creating Stored Functions;
  19. Creating Packages & Using More Package Concepts;
  20. Utilizing Oracle Supplied Packages in Application Development & Dynamic SQL and Metadata;
  21. Design Considerations for PL/SQL Code;
  22. Managing Dependencies & Manipulating Large Objects;
  23. Creating Triggers;
  24. Applications for Triggers & Understanding and Influencing the PL/SQL Compiler.

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
Close