Oracle PL/SQL

Course Features

Course Details

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
 
This course does not have any sections.

More Courses by this Instructor