4.9/5 stars on Google Reviews
Mohit
- Genpact
Affy Informatics offers the ORACLE training which provides opportunities for getting jobs. The highly proficient trainers at the Institute deliver proper training on this course which assists the students in this arena and they are able to achieve a successful position in IT industry.
Affy Informatics is the most reputed Oracle Institute in Gwalior that has mainly designed to give your career a strong boost in trending technology.
This Oracle training course is designed for consultants new to writing SQL queries with Oracle. The SQL learned in this course is standard to all modern databases, but Oracle will be used in class and syntax and functionality specific to Oracle will be pointed out.
SQL stands for Structured Query Language. It is functionality complete, i.e., through SQL we can insert, manipulate, update, delete data in a database. Without the knowledge of SQL a database administrator cannot administer a database. It is the used as the query language of all the databases in the world.
PL/SQL is Oracle's extension language for standard SQL.In this PL/SQL training class, consultants who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database. PL/SQL is the procedural extension of the SQL language. It has the branching and grouping concept. It also consists of exception, which is used in fourth-generation languages. Using Pl/SQL, we can performs more than one operation on a database at a time, increasing the scalability of a database.
Terminology Used
SQL Connection with RDBMS
Advantages of SQL
Way of Writing SQL
SQL Statements
Character Functions
Number Functions
Date Functions
Conversion Functions
General Functions
Multiple Row Functions
Group Function
Selecting Specific Columns
Column Alias
Concatenation Operator
Arithmetic Operators
Comparison Conditions
Logical Conditions
ORDER BY Clause
Types of Subquery
Group Function
Having Clause
Non-Equijoins
Self Joins
Left Outer Joins
Right Outer Joins
Full Outer Joins
Cross Joins
Natural Joins
Alter
Drop
Rename
Truncate
Update
Delete
Merge
Revoke
Rollback
Savepoint
View
Index
Synonyms
Unique Key
Primary Key
Foreign Key
Check
Dropping a Constraint
Enabling Disabling
Identifiers
Comment
Difference between SQL and PL/SQL
PL/SQL Block Structure
Compound IF Statements
IF-THEN-ELSE Statements
Update
Delete
Merge
Explicit Cursor Life Cycle
Explicit Cursor Attributes
WHILE Loops
FOR Loops
Exception Handlers
Types of Exceptions
Cursor-Based
Programmer-Defined
Function with Arguments
Executing Function
Dropping Function
Block Structure of Subprogram
Types of Subprograms
What is a Procedure?
Procedure with Parameters
Executing Procedures
Dropping Procedures
Statement Trigger
Row Trigger
Using Conditional Operations
DML Operations
Package Body
Creating Package
Execution
Dropping Package