Oracle Training in OMR Chennai

• Dinesh work as an Oracle Consultant & Instructor, He has over 11 years of Oracle Implementation experience and recognized expert in Oracle data warehouse technologies, advanced analytics and Oracle data mining.  Mr. Dinesh specializes in Oracle Discoverer, Oracle OLAP and Oracle Data Warehouse Builder.
• He is also been as Senior Instructor of Oracle University and provided 120 Corporate trainings, trained 2500 corporate & fresher employees.
• He is an Oracle Certified Master (OCM). Expertised with RAC, Data Guard, ASM, Oracle Exadata, RMAN, Oracle Performance Tuning, Streams, Security & more.
• He is among few of the Oracle Certified Master (OCM’s) in the World to achieve below certifications in his area of research.
  • Oracle Certified Professional (OCP) 9i
  • Oracle Certified Professional (OCP) 10g
  • Oracle Certified Professional (OCP) 11g
  • Oracle 10g Certified RAC Expert
  • Oracle 10g Certified Master (OCM)
  • Oracle 11g Exadata Certified Implementation Specialist

Conducting regularly online- training for US peoples in all time zones (PST, CST, EST, HST, MST) My training is 100% Money Back Guarantee (Tuition fee) for Passing Online Examination with cent percent and ready to go live with production system immediately. If my training does not satisfy you at any point of time, even during the training period, you need not pay the tuition fee.

100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.

Talk to the Trainer @ +91-89399 15577
FREE Demo Session: Try two FREE CLASS to see for yourself the quality of training.

Free Materials Provided during Demo sessions.

Learn Oracle from the same team involved in Oracle product development. We are the Leading Oracle real time training institute in Chennai. We offer best oracle training with real-time project scenarios. We can guarantee classes that makes you as a Oracle Certified Professional.

Oracle Certification Training in Chennai

Best OCA / OCP Training in Chennai with in-depth Oracle Exam preparation towards Oracle 10g, Oracle 11g, Oracle 12c Certification.

Oracle Developer Certification Training

• 1Z0-061 Oracle Database 12c: SQL Fundamentals
• 1Z0-047 Oracle Database SQL Expert
• 1Z0-117 Oracle Database 11g Release 2: SQL Tuning
• 1Z0-051 Oracle Database 11g: SQL Fundamentals I
• 1Z0-147 Program with PL/SQL
• 1Z0-144 Oracle Database 11g: Program with PL/SQL

Oracle Database Administrators Certification Training

• 1Z0-062 Oracle Database 12c: Installation and Administration
• 1Z0-063 Oracle Database 12c: Advanced Administration
• 1Z0-051 Oracle Database 11g: SQL Fundamentals I
• 1Z0-052 Oracle Database 11g: Administration I
• 1Z0-053 Oracle Database 11g: Administration II

Oracle Database 10g: Real Application Clusters (RAC) Administrator Certified Expert Training

• 1Z0-048 Oracle Database 10g R2: Real Application Clusters for Administrators

Introduction

• Describe the features of Oracle Database 12c
• Describe the salient features of Oracle Cloud 12c
• Explain the theoretical and physical aspects of a relational database
• Describe Oracle servers implementation of RDBMS and object relational database management system (ORDBMS)

Basic DATABASE Concept and SQL

• Basic history of database concept: DBMS, RDBMS, ORDBMS
• Advantage of ORACLE database and version information
• Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad
• SQL Language overview : DQL, DML, DDL, DCL, TCL
• What is the usage of ANSI standard.
• SELECT Command – Column Alias Rules, String data,
• Concatenations with various data
• Null Value handling with number and characters,
• Arithmetic Operator
• Concatenation Operator,
• Eliminating Duplicate Rows

Restricting and Sorting Data

• WHERE Clause – Character Strings and Dates, number
• General Comparison Conditions = > >= < <= <>
• Other Comparison BETWEEN , IN , LIKE , NULL
• Logical Conditions AND OR NOT
• ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns

Single-Row Functions

• Character Functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR, INSTR, LPAD, RPAD, CONCAT, LTRIM, RTRIM, TRIM, REPLACE, TRANSLATE, REVERSE
• Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
• Dates Functions: SYSDATE, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, ADD_MONTHS, ROUND, TRUNC, Arithmetic on Date
• Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
• General Functions: NVL , NVL2 , NULLIF, COALESCE
• CASE Expression, DECODE
• Nested function with real-time usage

JOINS

• EQUI JOIN / SIMPLE JOIN / NORMAL JOIN
• ANSI JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER
• NATURAL JOIN, NATURAL OUTER JOINS
• INNER JOIN, JOIN … USING clause, JOIN … ON clause,
• CROSS JOIN, NON-EQUI JOIN, SELF JOIN
• ORACLE STANDARD OUTER JOINS.
• Multi table Joins, Complex Joins How to simplified complex joins.

Multi-row Functions

• Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
• Creating Groups of Data: GROUP BY Clause
• Filtering Group Results: The HAVING Clause

Sub-queries

• Single-Row Subqueries- Rules, Operators : = > >= < <= <>
• Null Values in a Subquery
• Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL

Reporting data using interface commands

• pagesize, linesize , column heading , column format , colsep
• tTitle , bTitle , break on column, spool , CSV file generation, Text file generation

Data Manipulation Language DML and Transaction Control Language TCL

• DML : INSERT, UPDATE, DELETE, MERGE
• TCL : COMMIT, ROLLBACK, SAVEPOINT

Data Definition Language – DDL

• DDL : CREATE, ALTER, RENAME, DROP, TRUNCATE
• DEFAULT OPTION.
• Constrain table copy

Constraints

• NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
• Column Level Constraint, Table Level Constraint Naming constraints and usage
• Adding a Constraint, Dropping a Constraint,
• Disabling Constraints, Enabling Constraints
• Validating Constraints

Views

• Simple Views and Complex Views , Create, Drop, Source Code
• Rules for Performing DML Operations on a View
• WITH CHECK OPTION , WITH READ ONLY
• Inline Views
• Materialized View , Create, Refresh, Drop – Usage

Other Database Objects

• Sequence- NEXTVAL and CURRVAL
• Index – When to Create an Index, When Not to Create an Index.
• Synonyms

DCL COMMANDS

• Creating Users
• Granting / Revoking Privileges
• Creating and Granting Privileges to a Role

Dictionary Tables

• Tables, Views, Synonyms, Index, Sequence, Constrains, Source and other Dictionary

SET Operators

• UNION ,
• UNION ALL ,
• INTERSECT ,
• MINUS

Advanced Date-time Functions

• TIME ZONES ,
• SYSDATE, SYSTIMESTAMP,
• CURRENT_DATE , CURRENT_TIMESTAMP
• SESSIONTIMEZONE ,
• Storing time zone data in Table
• EXTRACT ,
• TO_YMINTERVAL

Advanced GROUP BY Clause

• Group by with ROLLUP,
• Group by with CUBE,
• GROUPING SETS

Advanced Subqueries

• Pairwise Comparison Subquery ,
• Nonpairwise Comparison Subquery
• Correlated Subqueries,
• Correlated UPDATE,
• Correlated DELETE
• EXISTS , NOT EXISTS Operator

Hierarchical Retrieval

• Walking the Tree: From the Bottom Up , From the Top Down
• LEVEL Pseudo column,
• Connect by prior,

Multi-table Insert

• Unconditional INSERT ALL
• Conditional INSERT ALL
• Conditional FIRST INSERT

DATA LOADER

• SQLLDR Loading CSV file / Flat file into ORACLE table.

Analytic Functions

• WM_CONCAT, LAG, LEAD, RANK, DENSE_RANK
• Query_by partition_clause with sum, min, max, avg, count,
• order_by_clause with sum, min, max, avg, count,
• Psudo column : Rownum, Rowid, – Elimination duplicate data
• Connect by rownum , Connect by Level Generating random numbers, random dates,
• Quote Operator syntax and usage

Backup

• Export / Import SCHEMA

General discussion

• What is migration?
• Migration Estimating, Planning, Preparation Simple Scenario / Complex Scenario.