Oracle and PL/SQL - Training Course
Introduction to the SQL query language and the Oracle
Relational Database Management System. This course
of "Oracle and PL/SQL" provides you with detailed
introduction to the SQL query language and the Oracle
Relational Database Management System. You will learn
about Oracle (Procedural Language ) PL/SQL which is
an Oracle extension of the SQL statement set which allows
the developer to impose flow control and logic design
onto unstructured SQL command blocks. PL/SQL also implements
basic exception handling. Oracle database is normally
use in large corporation or organization and well known
to its reliability and high performances.
Days : 3 days
TIME : 9:00 till 17:00 (Overtime Expected).
INCLUDE: Free parking + 2 Snack meals and beverages.
Disk support to trainee.
EQUIP: Computer at least Pentium II as well real
SERVER.
CLASS COVERING DETAILS & CONTENTS OF:
- Create, Edit and Modify TABLE
- How to Create Constraint (restriction) for Table
- Managing Your Data
- Create and understand Query and technique of data
QUERY
- Understanding FUNCTION: Character function ,Number
function , Date Function
how to utilize Single Row function and etc…
- Handling your "File" using SQL* Plus
command
- Set property value for "Environment"
in Oracle
- How to Create "Report" within "Oracle
Environment"
- JOIN data "Technique" using Cartesian
Product and command; Equi Join, Non-equi Join,
Outer Join and Self Join
- Learn about Aggregating Data and how to use Group
Function
- How to create View, Sequence, Index, Synonym
- Create and assigned User for security control
- Understanding what is and learn about "PL/SQL
Block"
- How to "Control Structure" in PL/SQL Block
- Create "Cursor" both Implicit and Explicit
- Create "Composite Datatype"
- Taking of Exception Handling
|
