APPLIED DATABASE I (4 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Evaluate 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;
8. Controlling User Access & Manage Schema Objects;
9. Manipulating Large Data Sets;
10. Generating Reports by Grouping Related Data & Managing Data in Different Time Zones;
11. Hierarchical Retrieval;
12. Regular Expression Support;
13. Introduction to PL/SQL & Declaring PL/SQL Identifiers;
14. Writing Executable Statements & Interacting with the Oracle Server;
15. Writing Control Structures;
16. Working with Composite Data Types;
17. Using Explicit Cursors;
18. Handling Exceptions & Creating Stored Procedures & Functions;
19. Introduction PLSQL Dev & Creating Stored Procedures;
20. Creating Stored Functions;
21. Creating Packages & Using More Package Concepts;
22. Utilizing Oracle Supplied Packages in Application Development & Dynamic SQL and Metadata;
23. Design Considerations for PL/SQL Code;
24. Managing Dependencies & Manipulating Large Objects;
25. Creating Triggers;
26. Applications for Triggers & Understanding and Influencing the PL/SQL Compiler.