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.

Oracle Database Course Details

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

• INSERT
• UPDATE
• DELETE

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