Oracle Database Application Developer هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

Oracle Database : Introduction to SQL

Course Topics :
Introducing Oracle Database 11g
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub-queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Managing Data in Different Time Zones
Retrieving Data Using Sub-queries
Regular Expression Support

Oracle database 11g: Program with PL/SQL 

Course Topics :
 
Introduction
Introduction to PL/SQL
Declare PL/SQL Identifiers
Write Executable Statements
Interaction with the Oracle Server
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions and Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage Dependencies

Oracle Forms developer: Build Internet Applications  

 Course Topics :
Introducing Oracle Forms Developer and Forms Services
Creating Forms Modules
Working with Data Blocks and Frames
Working with Input Items
Working with Non Input Items
Working with Windows and Canvases
Producing Triggers
Debugging Triggers
Adding Functionality to Items
Run-Time Messages and Alerts
Query Triggers
Validation
Navigation
Transaction Processing
Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications

Oracle Reports Developer 10g: Build Reports

Course Topics :
 
Introduction to Oracle Reports Developer
Designing and Running Reports
Exploring Oracle Reports Developer
Creating a Paper Report
Enhancing a Basic Paper Report
Managing Report Templates
Creating a Web Report
Enhancing Reports Using the Data Model: Queries and Groups
Enhancing Reports Using the Data Model: Data Sources
Enhancing Reports Using the Data Model: Creating Columns
Enhancing Reports Using the Paper Layout
Controlling the Paper Layout: Common Properties
Controlling the Paper Layout: Specific Properties
Web Reporting
Extending Functionality Using XML
Creating and Using Report Parameters
Embedding a Graph in a Report
Enhancing Matrix Reports
Coding PL/SQL Triggers
Extending Functionality Using the SRW Package
Maximizing Performance Using OracleAS Reports Services
Building Reports: Efficiency Guidelines تحديث بتاريخ 09 August, 2020