contactus@gninfotech.org  | 01628-504620,98720-87620

Oracle 11g Database:SQL & PL/SQL Training

Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation. Oracle Database 11g Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry's most advanced database management system.
GN Infotech provides the best Oracle Database 11g Training in Khanna with above mentioned course curriculum. GN Infotech labs are equipped with latest software so that students can get 100% practical training.


At the completion of Oracle SQL & PL/SQL Training the participant will exhibit the following

Understand the basic concepts of relational databases.
Use data manipulation statements
Using single-row functions, conversion functions and conditional expressions.
Using Joins and Group functions.
Use data definition language to create and manage tables.
Perform data management in different time zones.
Understand PL/SQL benefits
Use loops and control statements
Create PL/SQL packages.,br> Create triggers and events
Create PL/SQL blocks, functions and stored procedures.
Certification Exams:
OCP Oracle Database SQL Expert 1z0-047
Program with PL/SQL 1z0-147


Why Oracle 11g Training at GN Infotech ?

Industry Compliant Syllabus
Multi-Platform Demonstration
Product Based Training
Real-Time Case Studies
Use of Latest Tools & Technology
LCD equipped class room
Unlimited Lab facility
Faculty drawn from Industries
Daily Handouts & Lab Exercise
Workshops on New Technologies


Target Auidence

PL/SQL Developer
System Analyst
Business Intelligence Developer

Next Technical Upgrade :

Chapter-1 Introduction (Click to View Detail…)

Overview of Oracle Database 11g and related products
Overview of relational database management concepts and terminologies
Introduction to SQL and its development environments
The HR schema and the tables used in this course
Oracle Database documentation and additional resources

Chapter-2 Retrieve Data using the SQL SELECT Statement (Click to View Detail…)

List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Use arithmetic expressions and NULL values in the SELECT statement
Invoke Column aliases
Concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
Display the table structure using the DESCRIBE command

Chapter-3 Restricted and Sorted Data (Click to View Detail…)

Write queries with a WHERE clause to limit the output retrieved
Describe the comparison operators and logical operators
Describe the rules of precedence for comparison and logical operators
Usage of character string literals in the WHERE clause
Write queries with an ORDER BY clause
Sort the output in descending and ascending order
Substitution Variables

Chapter-4 Usage of Single-Row Functions to Customize Output (Click to View

List the differences between single row and multiple row functions
Manipulate strings using character functions
Manipulate numbers with the ROUND, TRUNC, and MOD functions
Perform arithmetic with date data
Manipulate dates with the DATE functions

Chapter-5 Conversion Functions and Conditional Expressions (Click to View Detail…)

Describe implicit and explicit data type conversion
Describe the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nesting multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Usage of conditional IF THEN ELSE logic in a SELECT statement

Chapter-6 Aggregated Data Using the Group Functions (Click to View Detail…)

Usage of the aggregation functions in SELECT statements to produce meaningful reports
Describe the AVG, SUM, MIN, and MAX function
How to handle Null Values in a group function?
Divide the data in groups by using the GROUP BY clause
Exclude groups of date by using the HAVING clause

Chapter-7 Display Data From Multiple Tables (Click to View Detail…)

Write SELECT statements to access data from more than one table
Join Tables Using SQL:1999 Syntax
View data that does not meet a join condition by using outer joins
Join a table to itself by using a self join
Create Cross Joins

Chapter-8 Usage of Subqueries to Solve Queries (Click to View Detail…)

Use a Subquery to Solve a Problem
Single-Row Subqueries
Group Functions in a Subquery
Multiple-Row Subqueries
Use the ANY and ALL Operator in Multiple-Row Subqueries
Use the EXISTS Operator

Chapter-9 SET Operators (Click to View Detail…)

Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Describe the UNION, UNION ALL, INTERSECT, and MINUS Operators
Use the ORDER BY Clause in Set Operations

Chapter-10 Data Manipulation (Click to View Detail…)

Add New Rows to a Table
Change the Data in a Table
Use the DELETE and TRUNCATE Statements
How to save and discard changes with the COMMIT and ROLLBACK statements
Implement Read Consistency
Describe the FOR UPDATE Clause

Chapter-11 DDL Statements to Create and Manage Tables (Click to View Detail…)

Categorize Database Objects
Create Tables
Describe the data types
Understand Constraints
Create a table using a subquery
How to alter a table?
How to drop a table?

Chapter-12 Other Schema Objects (Click to View Detail…)

Create, modify, and retrieve data from a view
Perform Data manipulation language (DML) operations on a view
How to drop a view?
Create, use, and modify a sequence
Create and drop indexes
Create and drop synonyms

Chapter-13 Introduction to PL/SQL (Click to View Detail…)

PL/SQL Overview
List the benefits of PL/SQL Subprograms
Overview of the Types of PL/SQL blocks
Create a Simple Anonymous Block
Generate the Output from a PL/SQL Block

Chapter-14 PL/SQL Identifiers (Click to View Detail…)

List the different Types of Identifiers in a PL/SQL subprogram
Usage of the Declarative Section to Define Identifiers
Use of variables to store data
Scalar Data Types
%TYPE Attribute
Bind Variables
Sequences in PL/SQL Expressions

Chapter-15 Write Executable Statements (Click to View Detail…)

Basic PL/SQL Block Syntax Guidelines
How to comment code?
SQL Functions in PL/SQL
Data Type Conversion
Nested Blocks
Operators in PL/SQL

Chapter-16 Interaction with the Oracle Server (Click to View Detail…)

SELECT Statements in PL/SQL to Retrieve data
Data Manipulation in the Server Using PL/SQL
The SQL Cursor concept
Learn to use SQL Cursor Attributes to Obtain Feedback on DML
How to save and discard transactions?

Chapter-17 Control Structures (Click to View Detail…)

Conditional processing Using IF Statements
Conditional processing Using CASE Statements
Simple Loop Statement
While Loop Statement
For Loop Statement
The Continue Statement

Chapter-18 Usage of Composite Data Types (Click to View Detail…)

PL/SQL Records
The %ROWTYPE Attribute
Insert and Update with PL/SQL Records
Associative Arrays (INDEX BY Tables)
INDEX BY Table Methods
INDEX BY Table of Records

Chapter-19 Explicit Cursors (Click to View Detail…)

Understand Explicit Cursors
Declare the Cursor
How to open the Cursor?
Fetching data from the Cursor
How to close the Cursor?
Cursor FOR loop
Explicit Cursor Attributes
FOR UPDATE Clause and WHERE CURRENT Clause

Chapter-20 Exception Handling (Click to View Detail…)

What are Exceptions?
Handle Exceptions with PL/SQL
Trap Predefined Oracle Server Errors
Trap Non-Predefined Oracle Server Errors
Trap User-Defined Exceptions
Propagate Exceptions
RAISE_APPLICATION_ERROR Procedure

Chapter-21 Stored Procedures and Functions

What are Stored Procedures and Functions?
Differentiate between anonymous blocks and subprograms
Create a Simple Procedure
Create a Simple Procedure with IN parameter
Create a Simple Function
Execute a Simple Procedure
Execute a Simple Function

Drop a Query for Android Training in GNIT

What Student are saying

I would like to thank GN Infotech team for their excellent support during my industrial training. I would like to especially thank the Training Incharge for all my queries were answered properly,clarify doubts, along with the mock test sessions.

Training program as well as course content is well structured to meet the requirement of Industry.

Btech.(ME)
Catia 3d,PEC

The working environment at GNIT is very professional and I got a peek into the competitive world of IT.

Btech.(CSE)
Advance Android Development,PEC

I would recommend GNIT to anyone who is truly serious about learning .NET.

Btech.(CSE)
Microsoft ASP.NET, UPEC

Practical training modules focusing on problem solving helped me understand real life scenarios.

Btech.(ME)
Networking,VIT University
View all Testimonials