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
- myTectra Won The Best Training Company of the Year 2018
- myTectra Won The Best Online Training Company of the Year 2017
- myTectra is an ISO 9001:2015 Certified Company
- myTectra Won Innovative Online Training Company of the Year 2016!
- myTectra Won the Best Training Institute in Bangalore
- myTectra Won Global Learning Company of the Year 2015
- myTectra Won Gold Winner for the best training company of the year 2014
- myTectra is certified by Norsk Akkreditering of Norway
- myTectra is an ISO 9001:2008 Certified Company
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
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
-
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.Price Quality Value
1 Item(s)
per page
 |
| 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]
myTectra a global learning solutions company helps transform people and organization to gain real, lasting benefits.Join Today.Ready to Unlock your Learning Potential !
- 10P, IWWA Building,2nd Floor,
7th Main Road,BTM Layout 2nd Stage,Bangalore-560076,Karnataka,India - Telephone:India:;+91 9019191856 US: +1 (201) 720-5410
- E-mail: [email protected]
