Oracle (PL/SQL)

Steps Technology provide the industry based training on Oracle (PL/SQL) which covers more than 100 real time scenario which is very helpful for fresher as well as Experience students to get their first job in Oracle (PL/SQL).

SQL:

• History of Sql

• DDL, DML, DCL , TCL

• Architecture Block Diagram Of oracle

• Different types of Data Type (Char, Varchar,Varchar2,Date,Number , Lob etc)

• Difference Between Different Data type

• Select Query

• Sub Query

• Cross Tab Query

• Inline View Query

• Set Operators:- Union , Intersect , Minus , Union All

• Clauses :- In Clause, Exists

• Cartesian Product

• Arithmetic Sql Functions

• Text Functions

• Logical Functions

• Other Functions

• Any ,All, Order BY, Like etc

• Alias Of table and Column of table

• Order By, Between , Like , Group BY

• Aggregate functions with group by and having

• Complex Insert, Update , Delete , Select Statement

PL/SQL:

• Introduction of Plsql

• Relationship Between Sql And Plsql

• Control statements of Plsql

• Different Types of Object of Database

• Procedure

• Functions

• Triggers

• Materialized View

• Synonym

• Sequence

• Job Scheduler

• Array, Varray Table array , Record

• Object

• Advanced Plsql (Bulk Insert ,Bulk Collect etc)

• Ult File

• Json

• Query Optimization