Comprehensive Introduction to Programming with PL/SQL on Oracle 10g
Short summary:
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The. grammar syntax and benefits of using the PL/SQL language ...
Long summary:
Comprehensive Introduction to Programming with PL/SQL on Oracle 10gPage 1Comprehensive Introduction to Programming with PL/SQL on Oracle10gCourse length: 5 daysCourse Web Page: http://www.webucator.com/Database/ORA101.c fmClass OverviewThe Oracle PL/SQL language provides for programming logic features not contained within SQL. Thegrammar syntax and benefits of using the PL/SQL language within an Oracle database environment areconsidered. This course can be tailored for Application designers and developers or Database administrators.Class GoalsUnderstand the environment and context in which PL/SQL operatesLearn the advantages and benefits of PL/SQL within a database environmentLearn to declare program variables and complex data typesLearn to develop logic within PL/SQL program blocksLearn to fetch data from the database into program variablesReturning program output to usersLearn to handle program exceptionsLearn to use explicit and implicit database cursorsLearn to use the advanced features of nested blocks and subprogramsLearn to take advantage of new features such as regular expression support and handling of stringliteralsUnderstand application partitioning within a client/server or multitiered webbased architectureUnderstand the basic form and structure of program units stored within the databaseLearn to build and maintain database stored program unitsLearn to encapsulate stored units within packages and taking advantage of accompanying advancedprogramming techniquesLearn to build and maintain DMLevent and systemevent database triggersUnderstand the storage and execution model for database programs and how one can write efficientprograms to maximize performanceLearn to use systemsupplied packages to extend the power of your SQL statements and PL/SQLapplications.Class PrerequisitesSQL as taught in Webucator's Comprehensive Introduction to Oracle SQLClass OutlineLanguage FeaturesUnderstanding Pl/SQLStructure Of A Pl/SQL Program BlockPl/SQL From Interactive ToolsGen ...
Source: www.webucator.com
Related
SQL Injection in Oracle Forms, All Oracle Forms applications are
vulnerable against SQL Injection by.
default. ... About Oracle Forms: Oracle
Forms 10g is Oracle's award winning Web
Rapid ...,
more
ORACLE PL/SQL Programming Performance Objectives, ORACLE: PL/SQL Programming. Performance
Objectives. SYS-ED with Oracle.How to
branch to/from exceptions. How to add
fields containing error information.
Processing after an exception ...,
more
Protecting Oracle Databases, Securing your database involves not only
stablishing strong password policy, but
also establishing adequate access
controls. In this paper, we will cover
various ways databases. programming
guideline for web programmers that
includes emphasis on using parameterized
queries ...,
more
