HOT LINE:

+919019191856

+1 (201) 720-5410 (USA)

My Cart

0

Oracle PL/SQL

Training Mode: Class Room / Live Online


Need Help? please call us on +919019191856 or Click Here to send us an Enquiry

QUICK OVERVIEW

PL SQL Training in Bangalore - Live Online & Classroom

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 stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency. PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.
myTectra the Market Leader in PL SQL Training in Bangalore
myTectra offers PL SQL training in Bangalore using Class Room. myTectra offers Live Online PL/SQL Training Globally.

 

DQL-The Select Statement1
Identifying Table and Column Names1.1
Components of a Simple SELECT1.2
Examples of Simple SELECT statements1.3
Creating Character Values in the SELECT clause1.4
Computing Numeric Values in the SELECT clause1.5
Limiting The Database Records Retrieved –WHERE2
Evaluation Operators Used in the Where Clause2.1
Using the Equal (=) and IS operators2.2
Using the Greater Than (>) and Less Than (<) Operators2.3
Using the In Operator2.4
ANY, SOME, or ALL Keywords2.5
Using the Between Operator2.6
Using the LIKE Operator2.7
Using AND or to Document Multiple Conditions2.8
Mixing AND OR in the WHERE clause2.9
Sorting Records -ORDER BY3
Ascending/Descending Order3.1
Using Expression Numbers as the Names of Sort Columns3.2
Joins4
Retrieving Records from Multiple Tables4.1
How to Combine or Join Tables4.2
What to Do with Join Columns with the Same Name4.3
Join Types4.4
Joining Tables When the Value Exists in Only One Table4.5
The Outer Join4.6
LEFT OUTER JOIN4.7
RIGHT OUTER JOIN4.8
FULL OUTER JOIN4.9
Non-equijoins4.10
Self Joins4.11
Cartesian Joins4.12
GROUP BY Clause And Functions5
Group Functions5.1
COUNT5.2
SUM5.3
AVG5.4
MIN5.5
MAX5.6
GREATEST5.7
LEAST5.8
HAVING Clause5.9
Character Functions6
The INITCAP Function6.1
The INSTR Function6.2
The LENGTH Function6.3
The LOWER Function6.4
The LPAD Function6.5
The LTRIM Function6.6
The REPLACE Function6.7
The RPAD Function6.8
The RTRIM Function6.9
The TO_CHAR Function6.10
The TRIM Function6.11
The UPPER Function6.12
DECODE Function7
How to use DECODE Function?7.1
Simple CASE7.2
Searched CASE7.3
Difference between CASE and DECODE7.4
Creating New Values With Numeric And Date Functions8
Using the NVL, NVL2 and Coalesce Functions8.1
The ROUND Function8.2
The TRUNC Function8.3
Dates And Date Functions9
The ADD_MONTHS Function9.1
The LAST_DAY Function9.2
The MONTHS_BETWEEN Function9.3
The NEXT_DAY Function9.4
The ROUND and TRUNC Data Functions9.5
The TO_DATE Function9.6
Set Operators10
UNION10.1
UNION ALL10.2
MINUS10.3
INTERSECT10.4
Subqueries11
Multiple-Row Subqueries11.1
Multiple-Column Queries11.2
Correlated Subqueries11.3
The Data Definition Language12
CREATE12.1
DROP12.2
ALTER12.3
TRUNCATE12.4
The Data Manipulation Language13
INSERT13.1
UPDATE13.2
DELETE13.3
The Data Control Language14
GRANT14.1
REVOKE14.2
The Transaction Control Language15
COMMIT15.1
ROLLBACK15.2
SAVEPOINT15.3
Views16
Simple and Complex Views16.1
Create view16.2
Drop view16.3
Alter view16.4
Select data through view16.5
Force View16.6
Synonyms17
Create synonym17.1
Drop synonym17.2
Public and Private Synonym17.3
Usage17.4
Sequences18
Create sequence18.1
Drop Sequence18.2
Alter Sequence18.3
CURRVAL18.4
NEXTVAL18.5
Using in select statement18.6
Indexes19
Create index19.1
Drop Index19.2
Alter Index19.3
BTREE Index19.4
Bitmap Index19.5
Cardinality19.6
Integrity Constraints20
Primary Key -Table Level and Column Level20.1
Foreign Key -Table Level and Column Level20.2
Check constraint20.3

 

To Learn Live Online PL SQL Training Globally and PL SQL Training in Bangalore using Class Room, ENROLL TODAY at myTectra .

 

Customer Reviews

1 Item(s)

per page
best institute in bangalore Review by Frince
Price
Quality
Value
I completed my Oracle PL/SQL course in mytectra. I also did my internship there along with the course. They provide realtime projects and support our career.

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

brand
myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


WHY DO YOU AWAIT FOR FIXED SCHEDULES ? CHOOSE MYTECTRA LEARN AT YOUR CONVENIENT TIME

myTectra flexible batch schedules enables you to start your class at your convenient date and time.


1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time


Do you have any questions ? please call us on +919019191856 or email to [email protected]