|
Provided by: Ahana Systems and Solutions (P) Ltd PLSQL TrainingComputer |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
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
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
|
|
||||||||||
PLSQL Training
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
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
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of starting up their career,...
There are no comments. Be the first to add one!