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
Oracle Sql Course Oracle Plsql Course
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
ORACLE – PLSQL Course Content
• 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
Our Students are working in
