This package offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This package provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones. This package introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In this package, you will build, test and deploy Internet applications with Oracle Forms. Working in a graphical user interface (GUI) environment, you learn how to build forms with user input items such as check boxes, list items, and radio groups. You will also display Form elements in multiple windows and customize data access by creating event-related triggers.

• Retrieve row and column data from tables with the SELECT statement.
• Employ SQL functions to generate and retrieve customized data.
• Run data manipulation statements (DML) to update data in the Oracle Database 10g.
• Control user access and manage schema objects.
• Search data using advanced sub queries.
• Design PL/SQL anonymous blocks that execute efficiently.
• Write PL/SQL code to interface with the database.
• Describe the features and syntax of PL/SQL.
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors).
• Handle runtime errors.
• Create simple procedures and functions.
• Design PL/SQL courses to group and contain related constructs.
• Categorize and Use the Oracle supplied PL/SQL courses to generate screen output, file output, web output, and mail output.
• Schedule PL/SQL jobs to run independently.
• Write dynamic SQL for more coding flexibility.
• Create triggers to solve business challenges.
• Manage dependencies between PL/SQL subprograms.
• Create form modules, including components for database interaction and GUI controls
• Link one form module to another
• Implement triggers
• Debug form modules in a 3-tier environment
• Test form modules in a Web browser
• Reuse objects and code
• Display form modules in multiple windows and use a variety of layout styles.

Topics :