Applied Database I

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
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