Oracle PL/SQL Training

Curriculum:

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