Training
Provided by 123-CBT Computer Based Training
Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous easy-to-understand examples ensure that the concepts are amply illustrated. Learn To: - Identify the features and benefits of PL/SQL and understand the PL/SQL program constructs.
- Identify the PL/SQL datatypes
- Identify how to declare PL/SQL variables and identify the PL/SQL programming conventions.
- Retrieve and manipulate data from the database by using PL/SQL commands
- Identify features and attributes of SQL cursors, and manage transactions.
- Use the IF-THEN-ELSE and IF-THEN-ELSIF conditional constructs and the Basic loop, FOR LOOP, and WHILE LOOP looping constructs to control flow in PL/SQL code.
- Declare and reference PL/SQL records and PL/SQL tables
- Identify the types and features of LOB datatypes.
- Understand cursors, how to operate explicit cursors, work with explicit cursor attributes
- Use the advanced functionality of explicit cursors.
- Understand the basic concepts of exceptions, trap predefined, nonpredefined, and user-defined exceptions
- Understand how exceptions are propagated.
Content Emphasis Skills-Based Audience Application Developers, Database Administrators, System Analysts and Technical Support Professionals. Prior to taking this course students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. Total Learning Time 6 - 8 Hour(s) Course Contents Unit 1: PL/SQL: An Introduction Duration: 0.5 - 2 Hour(s) - Identify the features of PL/SQL.
- Identify the benefits of PL/SQL.
- Select the actions by which a PL/SQL engine processes a block of code.
- Identify the features of the sections of a basic PL/SQL block.
- Match the PL/SQL program constructs with their features.
- Identify the syntax rules to be applied in creating a PL/SQL block.
Unit 2: Developing a Simple PL/SQL Block Duration: 0.5 - 1 Hour(s) - Identify the functions of PL/SQL variables.
- Identify the guidelines for declaring PL/SQL variables.
- Match the PL/SQL datatypes with their descriptions.
- Match the scalar datatypes with their descriptions.
- Declare a scalar variable.
- Declare a scalar variable with the %TYPE attribute.
- Write the code to assign a value a to a variable by using the assignment operator.
- Use operators with the PL/SQL variables.
- Manipulate data in PL/SQL variables by using SQL functions.
- Convert the datatype of a variable by using a data conversion function.
- Identify the features of variable scoping in nested PL/SQL blocks.
- Create a bind variable in the SQL*Plus environment.
- Identify the case conventions for writing PL/SQL code.
- Match the identifiers with their naming conventions.
Unit 3: Accessing the Database Using PL/SQL Duration: 1 Hour(s) - Retrieve data from a table by using the SELECT statement..INTO statement.
- Identify the conditions in which various SELECT exceptions are raised.
- Write the code to add rows to a table by using the INSERT statement.
- Write the code to modify the existing data in a table by using the UPDATE statement.
- Write the code to delete data from
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
oracle
designer
sql
basics
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Oracle Designer R6 6i Training from 123-CBT Computer Based Training
Click here for more information or to take this course
|
