Oracle Training in Chennai

Oracle Training

Dhaksha Technology one of the best and real time oracle training in chennai with real time experienced trainer. This training institute has been providing the more support to students to gain knowledge in oracle database within a short period.

Oracle Training in Chennai

Our training will be handled in both weekday and weekend. Here are the major topics we cover under this oracle training syllabus About RDBMS, Tables, Data types, DDL, DML, TCL, DCL, Joins, SQl clauses, Sql Loader, index, view, set operators, advanced functions, String function, Date functions, How to write plsql procedure ,function, packages, exception handing.All the topic will be covered in practical way with real time examples.

Oracle Trainee

Our Oracle trainer is working in Oracle Database development for more than 9 years in MNC’s. Trainer offering industry needs and we are offering Oracle Training in Chennai. Our Oracle trainers offer Oracle in Classroom training, Oracle Online Training and Oracle Corporate Training services. We Have separate team to arrange the interview, resume preparation, interview questions discussion and mock interview. we framed our syllabus to match with the real time requirements for both beginner level to advanced level.

Eligible to study a oracle Database:

Eligibility for the Oracle Developer training – Fresher’s, 2011 – 2016(BE, BTech, ME, BCA, MCA) passed out and Corporate Employees was working in other technologies

Why Oracle Database:

Oracle database is a RDBMS used to stored as a unit. The main advantage of a database is to store and retrieve related data or information from database very easy and fast. Oracle database server is managing large amount of data and multiple user can access same data concurrently. Database more flexible and low cost effective to maintain all the information.,we are providing oracle training in chennai.

Oracle Data base support major platform like Windows, UNIX, Linux and Mac OS, Oracle database developed in Aug-1997 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott.

Certifications’s -Oracle

• Oracle Certified Junior Associate (OJA)

• Oracle Certified Associate (OCA)

• DIS Oracle Certified Professional (OCP)

• FROM Clause Oracle Certified Master (OCM)

• Oracle Certified Expert (OCE)

• Oracle Certified Specialist (OCS)

Dhaksha Technology is a leader in providing Oracle training In Chennai driven by industrial experts with all Real times.

All topics are Completely Real time. Theory Books and interview questions provided at sample class!!

We Referring /Arranging Oracle job assistance at top MNC’s in different location Chennai, Bangalore, pune, Hyderabad end more..

Course Syllabus

Oracle course Concepts

• History of Oracle Database

• Oracle Database version history

• Advantage and Disadvantage of Database

• Oracle Datatypes

DDL -Data Definition Language

• Create, Alter, Rename, Drop, Truncate

DML-Data

• Select, Insert, update, Delete

TCL- Transaction Control Language

• Commit, Rollback, Save point

DCL-Data Control Language

• Grant, Revoke

Constraints

• Definition of SQL Constraints

• Types of Constraints

• NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK

• ADDING, DROPPING, ENABLING and DISABLING of Constraints

SQL-Clauses

• SELECT Clause

• WITH Clause

• DISTINCT Clause

• FROM Clause

• WHERE Clause

• ORDER BY Clause

• GROUP BY Clause

• HAVING Clause

SQL Aliases

SQL – JOINS

• Overview of JOINS

• Types of JOINS

• INNER join, OUTER join, EQUI join, SELF join, CROSS join, ANTI join, SEMI join

SQL – Conditions

• AND, OR, AND & OR, LIKE, IN, NOT, IS NULL, IS NOT NULL, BETWEEN, EXISTS conditions

Single -Row Functions

• String / Char Functions

• ASCII, CHR, NCHR, CONCAT, CONVERT, INITCAP, INSTR

• LENGTH, LOWER, UPPER, LPAD, RPAD, SUBSTR,

• TRIM, LTRIM, RTRIM, REPLACE, TRANSLATE

• REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR

Numeric / Math Functions

• MIN, MAX, AVG, COUNT, SUM, MOD, LEAST, MEDIAN, TRUNC(Numbers)

• FLOOR, POWER, REMAINDER, ROUND(numbers), ROWNUM

Date and Time Functions

• SYSDATE, SYSTIMETAMP, ADD_MONTHS,

• CURRENT_DATE, CURRENT_TIMESTAMP, LAST_DAY, LOCALTIMESTAMP

• MONTHS_BETWEEN, NEXT_DAY, ROUND(dates), TRUNC(dates)

Conversion Functions

• TO_CHAR, TO_CLOB, TO_DATE,

• TO_NCLOB, TO_NUMBER, TO_TIMESTAMP

SQL Analytic Functions

• RANK,DENSE_RANK

• FIRST_VALUE,LAST_VALUE

• LAG, LEAD

SQL Advanced Functions

• CASE, DECODE

• LNNVL, NANVL

• NULLIF, NVL, NVL2

SQL Index

SQL Views

Materialized View

Set operators

• Discussion of SET Operator

• Types of SET Operator

• UNION, UNION ALL, INTERSECT, MINUS

SQL Loader

SQL Sequences

Synonym

Table Partition

Global Temporary Table

• Overview of PLSQL

• Basic Syntax of PLSQL

• PLSQL-Data types

• PLSQL-Variable

• PLSQL-Operators

• PLSQL-Constants

• PLSQL-Conditions

• PLSQL-Loops

• PLSQL-String

• PLSQL-Arrays

• PLSQL-Procedure

• PLSQL-Functions

• PLSQL-Packages

• PLSQL-Cursor

• PLSQL-Records

• PLSQL-Triggers

• PLSQL-Collections

• PLSQL-Transactions

• PLSQL-Date & Time

• PLSQL-DBMS Output

• PLSQL-Exception Handling

Project Class with real time

Resume Preparation

Interview Questions Discussion

Mock Interview -1

Mock Interview -2