Oracle Sql Training

Oracle SQL Training in Chennai

Dhaksha technology, Medavakkam, Chennai is giving the best Oracle sql training in Chennai. We are providing placement focused and real-time training.

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

Free Demo Session is available on Monday’s

oracle sql training in chennai

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