oracle database 10g: program with pl/sql

qa ltd.
aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough, united kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' this class is applicable to oracle8i, oracle9i and oracle database 10g users. this course introduces students to pl/sql and helps them understand the benefits of this powerful programming language. in the class, students learn topl/sql blocks of application code that can be shared by multiple forms, reports, and data management applications.

students learn toanonymous pl/sql blocks, stored procedures, and functions. they learn about declaring variables and trapping exceptions. students will also learn to develop stored procedures, functions, packages and database triggers. students will learn to manage pl/sql program units manage dependencies, manipulate large objects, and use some of the oracle-supplied packages. students use isql*plus to develop these program units. demonstrations and hands-on practice reinforce the fundamental concepts.

delegates will learn how to
design pl/sql anonymous blocks that execute efficiently
describe the features and syntax of pl/sql
handle runtime errors
categorize and use the oracle supplied pl/sql packages to generate screen output, file output, web output, and mail output
write dynamic sql for more coding flexibility
create triggers to solve business challenges
write pl/sql code to interface with the database
use pl/sql programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
create simple procedures and functions
design pl/sql packages to group and contain related constructs
schedule pl/sql jobs to run independently
manage dependencies between pl/sql subprograms
outline
introduction to pl/sql

what is pl/sql

pl/sql environment

benefits of pl/sql

overview of the types of pl/sql blocks

create and execute a simple anonymous block

generate output from a pl/sql block

isql*plus as pl/sql programming environment

declaring pl/sql identifiers

identify the different types of identifiers in a pl/sql subprogram

use the declarative section to define identifiers

list the uses for variables

store data in variables

declare pl/sql variables

writing executable statements

describe basic block syntax guidelines

use literals in pl/sql

customize identifier assignments with sql functions

use nested blocks as statements

reference an identifier value in a nested block

qualify an identifier with a label

use operators in pl/sql

use proper pl/sql block syntax and guidelines

interacting with the oracle server

identify the sql statements you can use in pl/sql

include select statements in pl/sql

retrieve data in pl/sql with the select statement

avoid errors by using naming conventions when using retrieval and dml statements

manipulate data in the server using pl/sql

the sql concept

use sql attributes to obtain feedback on dml

save and discard transactions

writing control structures

control pl/sql flow of execution

conditional processing using if statements

conditional processing case statements

handle nulls to avoid common mistakes

build boolean conditions with logical operators

use iterative control with looping statements

working with composite data types

learn the composite data types of pl/sql records and tables

use pl/sql records to hold multiple values of different types

inserting and updating with pl/sql records

use index by tables to hold multiple values of the same data type

using explicit cursors

for loops using subqueries

increase the flexibility of cursors by using parameters

use the for update clause to lock rows

use the where current clause to reference the current row

use explicit cursors to process rows

explicit attributes

cursors and records

handling exceptions

handling exceptions with pl/sql

predefined exceptions

trapping nonpredefined oracle server errors

functions that return information on encountered exceptions

trapping user-defined exceptions

propagate exceptions

use the raise_application_error procedure to report errors to applications

creating stored procedures

describe pl/sql blocks and subprograms

describe the uses of procedures

create procedures

differentiate between formal and actual parameters

list the features of different parameter modes

create procedures with parameters and invoke a procedure

handle exceptions in procedures

view source code in the data dictionary

creating stored functions

describe stored functions

list theor replace function syntax

identify the steps toa stored function

create a stored function in isql*plus and execute a stored function

identify the advantages of using stored functions in sql statements

identify the restrictions of calling functions from sql statements

describe how procedures and functions differ

creating packages

list the benefits or using pl/sql packages

differentiate between a package specification and a package body

create packages

include public and private constructs in a package

call public and private constructs in a package

remove packages

using more package concepts

overload procedure and function definitions

use forward declarations

create a one-time package initialization block

follow the persistent state of constructs in packages

use pl/sql tables and records in packages

wrap code to hide the source

utilizing oracle supplied packages in application development

list the various uses for the oracle supplied packages

reuse pre-packaged code to complete various tasks from developer to dba purposes

use the describe command to view the package specifications and overloading

describe how dbms_output works

use utl_file to direct output to operating system files

use the htp package to generate a simple web page

describe the main features of utl_mail

call the dbms_scheduler package to schedule pl/sql code to run

dynamic sql and metadata

describe using native dynamic sql

list the execution flow of sql

write dynamic sql using the execute immediate syntax

write dynamic sql with the dbms_sql package

generate ddl from metadata using the dbms_metadata package

design considerations for pl/sql code

standardize constants with a constant package

standardize exceptions with an exception package

write pl/sql code that uses local subprograms

use the nocopy compiler hint to pass parameters by reference

use the parallel enable hint for optimization

use the autonomous transaction pragma to run independent transactions within a single transaction

set the authid directive to execute programs with the privileges of the calling user instead of the creating user

use bulk binding for multi-row operations

managing dependencies

describe dependent and referenced objects

track procedural dependencies with dictionary views

predict the effect of changing a database object upon stored procedures and functions

manage local and remote procedural dependencies

manipulating large objects

describe a lob object

create and maintain lob data types

differentiate between internal and external lobs

use the dbms_lob pl/sql package to control lobs

describe the use of temporary lobs

creating triggers

describe different types of triggers

describe database triggers ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

tel: 0844 871 2080
e-mail us: info@qa.com

Jobs & Resumes: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Houses & Roommates: aberdeen, birmingham, bristol, edinburgh, exeter, glasgow, leeds, london, manchester, slough
Travel Agencies: birmingham, bristol, edinburgh, leeds, london, manchester,

Search other schools for oracle database 10g: program with pl/sql training resources.

Oracle 9iAS: Discoverer for End Users
Oracle Enterprise Manager 10g Grid Control
oracle ids
oracleas discoverer 10g:queries and reports
Migrate from SQL Server to Oracle Database 10g
Oracle 10g Database
Oracle 10g: Java Programming
Oracle Application Server 10g R2
oracle database 10g
Oracle Database 10g: SQL Tuning
Oracle Forms Developer 10g
oracle reports developer 10g
oracleas discoverer 10g
oracle database 11g
oracle database 11g: program with pl/sql
Advanced Perl with CGI and Web Applications
Perl 5 Object Oriented Programming
Perl

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.