Applied Database I

Learning Outcomes:

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:

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