Call us: +91-89599 99775 | E-mail: amusolutions01@gmail.com

Leading PHP Trainer in Indore | AMUSolutions.com

Oracle Database Course Details

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