Oracle PL/SQL Training Overview
Live Training In Oracle PL/SQL
| PL/SQL | Oracle Database Training|PL/SQL Programming
AMU Solutions is well known organization in the area of Software Training in Oracle Platform and acknowledged for giving quality education in domains such as Oracle PL/SQL Training.
We Are Leading Institute in Indore For Oracle PL/SQL Training.
Duration : 2 Month|Oracle|PL/SQL
The Oracle database Environment
Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g
Basic SQL*PLUS commands
Using script files, START, @, GET , SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL
Basic SELECT Statement
Writing the statement in sqlplus, Running the SELECT statement
Hibernate
- Hibernate Introduction
- QRM Using Hibernate
Ordering the output
Single Column, Descending order, Multiple column sort
Conditional retrieval of data
Working with complex conditions, AND OR NOT LIKE BETWEEN
Working with variables
Creating and using variables, Command substitution
Pseudo columns and functions
- Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table
- Working with character functions
UPPER, LOWER, INITCAP, RPAD(), RTRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(), DECODE
- Working with date functions
TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()
Using non-character function
ROUND(), TRUNC(), SIGN(), Working with multiple tables, Different type of Joins, Writing Outer Joins
Using the SET operators
Union, Intersect, Minus
Aggregating data using group functions
GROUP BY, HAVING
SQL Functions and Expressions
- Eliminating duplicates with DISTINCT arithmetic expressions
- Replacing null values
- Literals, concatenation, other string functions
- Numeric operations, including rounding
- Date and time functions
- Nested table expressions
- Case logic
- Other expressions in specific dbms Products
SQL Joins
- Inner joins with original and SQL 92 syntax
- Table aliases
- Left, right and full outer joins
- Self-joins
SQL Subqueries and Unions
- Intersection with IN and EXISTS
- Subqueries
- Difference with NOT IN and NOT EXISTS subqueries
- The purpose and usage of UNION and UNIONALL
Transaction Control Language
- Rollback
- Commit
- Savepoint
Processing hierarchies
- Creating the Tree structure
- LEVEL
- CONNECT BY
Data Manipulation Language
Data Definition Language
- CREATE
- TRUNCATE
- ALTER
- DROP
- RENAME
- DESCRIBE
PL/SQL Course Content
- Advantages of PL/SQL
- PL/SQL Variables
- PL/SQL Constants
- PL/SQL Records
- PL/SQL Conditional Statements
- PL/SQL Iterative Statements
- PL/SQL Cursors
- PL/SQL Explicit Cursors
- PL/SQL Procedures
- PL/SQL Functions
- Parameters-Procedure, Function
- PL/SQL Exception Handling
- PL/SQL Triggers