Oracle PL SQL online training course provide a more comprehensive solution for building mission-critical applications running on Oracle database.
Instructor-Led Live Online Training
PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax. PL/SQL program units are compiled by the Oracle Database server and are stored inside the database. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.
Oracle PL SQL Training Curriculum
The Oracle database environment, Reviewing basic architecture concepts, Oracle 10g Architecture, Main features of 9i and 10g
Basic SELECT Statement
Writing the statement in sqlplus, Running the SELECT statement
Ordering the Output
Single Column, Descending order, Multiple column sort
Conditional Retrieval of Data
Working with complex conditions, AND OR NOT LIKE BETWEEN
Pseudo Columns and Functions
Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table
Working With Character Functions
UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST()
Working With Date Functions
TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()
Using non-character function
ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins
Writing Outer Joins
Using the SET Operators
Union, Intersect, Minus
Aggregating Data Using Group Functions
GROUP BY, HAVING
Single Row subqueries, Multiple row Subqueries
Enhancing Groups Function
Transaction Control Language
Rollback, Commit, Savepoint
Creating the Tree structure, LEVEL, CONNECT BY
Data Manipulation Language
INSERT, UPDATE, DELETE
Data Definition Language
CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE.
Using Declarative Constraints
Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null.
Other Database Objects
Views, Sequences, Synonyms, Indexes, USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS
Object Privileges, Granting access to objects
Structure, Writing Anoyomous Blocks
Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments
IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END, LOOP statement, WHILE condition, FOR condition
Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN
Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions
Creating and Calling Procedures
Creating and Calling Functions
Package Header, Package Body
Design Tips and Techniques
Format of standard packages in an application, Spec and Body, NOCOPY hint theory
Database triggers, CALLing procedures from triggers
EXECUTE IMMEDIATE, DBMS_SQL package
Oracle Supplied Packages
Associative Arrays, Nested tables, VARRAYs
The online course session was good with a lot of discussion on the subject in depth. Demo's were good and the trainer cleared my doubts clearly.The trainer having a very good command on the subject.
Real time/live scenario's were included in the training sessions. The trainer's has very good command on the subject. Thank you..
I like the training period from Tekslate. The course is very well designed that helps to keep track until we demonstrate subject mastery.
Using most innovative teaching techniques, Tekslate intended to help students to learn through online. A great part of the coursework is allowed to use and earn certification by the time they finish t ...