• Image

Oracle Training In Chennai

In this course, you will receive a hands-on introduction to advanced SQL concepts, especially as they relate to Oracle's implementation of the SQL Language. Topics necessary to the development and administration of an Oracle 12c database are covered. This course is specifically designed for those who know generic SQL but are not familiar with SQL*Plus and more importantly, Oracle's implementation of SQL.

Introduction to SQL

Career Counseling

Effective Cover Letter and Resume

Preparation for Technical Interviews

Preparation Behavioral Interviews

Techniques in Job Application

Writing Basic SQL Statement (SELECT Clause)

Selecting data from tables.

Selecting selective number of columns from table

table types - user table and data dictionary table

Restricting & Sorting Data (WHERE Clause)

Processing Character Strings and Dates

Comparison Operators( > < >= <= = <> != ^=)

Oracle Operators

[NOT] IN

[NOT] BETWEEN .. AND

[NOT] LIKE

IS [NOT] NULL

Logical Operators

AND OR NOT

Rules of Precedence

Sorting Using ORDER BY Clause

Possition based sorting

Column Based Sorting

Sorting By Column Aliases

Sorting by Multiple Columns

NULLS FIRST and NULLS LAST

Single Row Functions

 Describe the differences between single row and multiple row functions

 Manipulate strings with character function in the SELECT and WHERE clauses

 String : UPPER( ) LOWER( ) INITCAP( )

 Character : LENGTH( ) CONCAT( ) REVERSE( )

 SUBSTR( ) INSTR( )

 LPAD( ) RPAD( ) LTRIM( ) RTRIM( )

 REPLACE( ) TRANSLATE( )

 Manipulate numbers and Dates by using

 ROUND( ) TRUNC( ) MOD( ) POWER( )

 CEIL( ) FLOOR( ) ABS( ) SIGN( )

 Date Function

 Arithmetic operation with date

 MONTHS_BETWEEN( )

 ADD_MONTHS( )

 NEXT_DAY( )

 LAST_DAY( )

 Type Conversion Function

 TO_NUMBER( )

 TO_CHAR( )

 TO_DATE( )

 General Function - To Process NULL Values

 NVL( ) NVL2( ) NULLIF( ) COALESCE( )

Multiple Row Function

 Group Function / Aggregate Function

 MIN( ) MAX( ) SUM( ) AVG( ) COUNT( )

 GROUP By and HAVING Clause

 Difference Between GROUP BY and HAVING Clause

DECODE Function and Case Expression

 How to use Decode and Case

 Real Time implementation

Selecting Data From Multiple tables ( Joins )

 Selecting Data from multiple tables

 Different types of Joins

 Equi Join, Outer Join (Right Outer Join, Left Outer Join, Full Outer Join),

 Slef Join, Cross Join, Natural Join

 Difference Between Equi Join and Outer Join

 Writing Join by using ANSI and Oracle Standard

Sub-Queries

 Basic Subqueries with examples

 Subquery Rules and Suggestions

 Single Row Sub Queries

 Single Row Sub Query Operators

 Multiple Row Sub Queries (IN, ANY/SOME, ALL)

 Multiple Row Sub Query operators

 Multiple Column Subqueries

 Using sub Query With all Clauses

 Scalar Sub Query

 Inline View

 Nested Sub Query

 Correlated Subqueries

Data Define Language (DDL)

 Introduction to Data Types

 Creating and Managing Tables

 CREATE , ALTER (ADD, RENAME, MODIFY and DROP), RENAME, DROP, TRUNCATE

 Creating Table by using Sub Query With Data

 Creating Table by using Sub Query Without Data

 Adding Multiple columns by using ALTER Statement

 Difference Between DROP and TRUNCATE

Data Manipulation Language (DML)

 INSERT, UPDATE, DELETE and MERGE

 Inserting data by using sub query

Constraints

 Introduction to Constraints

 Creating constraint at the time of table creation

 Creating Constraint after Table creation

 Types of Constraints

 Adding Constraints by using ALTER Statement

 ENABLE and DISABLE Constraints

 DROPing Constraints

Data Control Language (DCL)

 GRANT and REVOKE

 Creating User

 Introduction to tablepaces

 Types of Tablespaces

 Reseting password to the schema

 Controling User Access

 Allocating space on tablespaces

 Account lock and unlock

 DROP particular user

Transactional Control Language(TCL)

 COMMIT, ROLLBACK and Savepoint

 TCL with DDL Statements

Creating Views

 Understanding the Standards of VIEWS in Oracle

 Types of VIEWS

 Relational Views

 Object Views

 Prerequisites to work with views

 Practical approach of SIMPLE VIEWS and COMPLEX VIEWS

 Column definitions in VIEWS

 Using VIEWS for DML Operations

 Creating Forced Views

 Creating view WITH CHECK OPTION and WITH READ ONLY

Materialized Views
Pseudocolumns

 Understanding Pseudo Columns in Oracle

 Types of Pseudo Columns in Oracle

 USER, UID, ROWNUM, ROWID, NEXTVAL, CURVAL, LEVEL

 NEXTVAL and CURRVAL - Sequence related Pseudocolumns

Creating Sequence
Creating Synonyms
Creating Index
SQL * Loader in Oracle

 SQL * Loader Work File

 Generating / Geting Data file (Input Datafiles)

 Creating and understanding Control file

 Bad file, Discard file and Log file

 .txt and .csv to base table

 Loading data more than one file to single table

Table Partition in Oracle

 Understanding Partition

 Types of Partition(LIST, RANGE, and Composite)

 Sub Partition

 ADD, DROP, RENAME and EXCHANGE Partition

SQL Workshop
Using Set Operators
Oracle 10g Datetime Functions
Enhancements to the Group BY Clause
Advanced Sub Queries
Hierarchical Retrieval
Image

Lakshmanan

  • Oracle Developer

It was an plesant experience getting trained with infycle technologies. The trainer has provided the professional training and it was the hands-on experience that helped me to crack the interview and handle the tasks at adverse case in my projects. I would like to show my gratitude to both Infycle technologies and the Trainer.

Image

Aruna

  • Oracle Developer

I Have completed the Oracle course in Infycle Technologies which was the best Oracle training in Chennai. The training was excllent with the professional & Passionate trainer who never hesitates to clear the doubts. Each & every topic was covered indepth and engages with the task after every session. It fulfilled the purpose of the training. Thanks to Infycle and the Trainer.

Image

Mohamed

  • Oracle Developer

I Completed the Oracle training in Infycle Technologies which is the best solution for those who really look forward for IT jobs. The training is very professional and real-time. Interactive sessions and practicing hours help us to grasp the knowledge very effetively. Interview questions are discussed periodically for better placements. My heartly thanks to Infycle Technologies for Supporting my Career.

Fundamentals of PL/SQL

  Introduction to PL/SQL

  Benefits of PL/SQL

  Creating PL/SQL Blocks

Defining Variables and Datatypes

  Using Variables in PL/SQL

  Recognizing PL/SQL Lexical Units

  Recognizing Data Types

  Using Scalar Data Types

  Writing PL/SQL Executable Statements

  Nested Blocks and Variable Scope

  Good Programming Practices

Using SQL in PL/SQL

  Review of SQL DML

  Retrieving Data in PL/SQL

  Manipulating Data in PL/SQL

  Using Transaction Control Statements

Program Structures to Control Execution Flow

  Conditional Control: IF Statements

  Conditional Control: CASE Statements

  Iterative Control: Basic Loops

  Iterative Control: WHILE and FOR Loops

  Iterative Control: Nested Loops

Using Cursors and Parameters

  Introduction to Explicit Cursors

  Using Explicit Cursor Attributes

  Cursor FOR Loops

  Cursors with Parameters

  Using Cursors for UPDATE

  Using Multiple Cursors

Using Composite Datatypes

  User-Defined Records

  Indexing Tables of Records

Exception Handling

  Handling Exceptions

  Trapping Oracle Server Exceptions

  Trapping User-Defined Exceptions

  Recognizing the Scope of Exceptions

Using and Managing Procedures

  Creating Procedures

  Using Parameters in Procedures

  Passing Parameters

Using and Managing Functions

  Creating Functions

  Using Functions in SQL Statements

  Review of the Data Dictionary

  Managing Procedures and Functions

  Review of Object Privileges

  Using Invoker's Rights and Autonomous Transactions

  Creating Packages

  Managing Package Concepts

  Advanced Package Concepts

Getting the Best out of Packages

  Persistent State of Package Variables

  Using Oracle-Supplied Packages

Improving PL/SQL Performance

  Using Dynamic SQL

  Improving PL/SQL Performance

Using and Managing Triggers

  Introduction To Triggers

  Creating DML Triggers, Part I

  Creating DML Triggers, Part II

  Creating DDL and Database Event Triggers

  Managing Triggers

Recognizing and Managing Dependencies

  Introduction to Dependencies

  Understanding Remote Dependencies

Using the PL/SQL Compiler

  Using PL/SQL Initialization Parameters

  Displaying Compiler Warning Messages

  Using Conditional Compilation

  Hiding Your Source Code

FAQ
  • Is the Oracle training offered covers each and every topic indepth?

    Yes! Other than syllabus all the updated topics are also been covered.

  • Do you cover the updated versions of the Oracle?

    We train you with the currently adopted version in MNC’S and will handle the topics from updated versions and soon will cover the syllabus also.

  • Do you provide course materials and Oracle software? If so do you Charge for it?

    Ofcourse the study materials are provided as softcopy and oracle software is also provided with free of cost.

  • Is Placement assurity is given for oracle training and whether job is Contractual?

    Yeah! We provide better placement Assurance that will more than 100% and job is Permanent.

  • Does the trainer have real time experience in Oracle?

    Yes, the trainer is working professional with high expertised skills and knowledge in the updated versions, as working currently in the same field.

  • Is online training is available? Iam located in Madurai.

    Ofcourse, we provide online training for Oracle with best trainers. Kindly contact the Branch Manager for further schedule timings : 7010541638.

List Of Oracle Certifications Offered:

  11G OCM - Oracle Database 11g Certified Master Exam

  Oracle SQL Tuning for Developers Workshop Ed 1 (TR) TOD

  Oracle Database 11g: Advanced PL/SQL Ed 2 TOD

  1Z0-061 Oracle Database 12c: SQL Fundamentals

  1Z0-047 Oracle Database SQL Expert

  1Z0-147 Program with PL/SQL

  1Z0-144 Oracle Database 11g: Program with PL/SQL

  1Z0-051 Oracle Database 11g: SQL Fundamentals I

  Oracle Certified Associate - DBA 11g

  Oracle Certified Professional - DBA 11g

  Oracle PL/SQL Developer Certified Associate

  Oracle Database 11g: Administrator Certified Professional