Online Workshops to Learn Oracle 11g SQL  PL/SQL  on 17th May, 2015.

Online Workshops to Learn Oracle 11g SQL PL/SQL on 17th May, 2015.

 

Invite friends

Contact Us

Page Views : 123

About The Event

Online Workshops : Learn Oracle 11g SQL & PL/SQL in 1 day on 17th May, 2015.

Ticket/Registration Price: Rs. 2,500/- per participant.
Time: 10 AM to 2.30 P.M

Venue : Online workshops.
Oraganized by Gsoft Computer Education.


Online Oracle SQL & PL/SQL workshop through webex / gomeeting conducted by trainer from Gsoft Computer Education.

Learn Oracle 11g SQL & PL/SQL in 1 day from an expert Faculty with more than 19 years of teaching experience in Oracle SQL & PL/SQL.

Learn how to write sql queries & PL/SQL blocks.

All the participants will get participation certificates & assignments also for practice.

 

Facilities: ---

**********
Every participant will get a participation certificate.
Oracle SQL & PL/Sql notes & assignments will be emailed for practice purpose.
Participant's will gain knowledge of database and writing queries.

Limited Seats Only on first cum first serve basis.

Benefits for Participants
**************************

Every participant will get a participation certificate.
Learn about oracle form a expert faculty with 20 years experience.

Topics Covered

Oracle 11g (SQL *Plus)

What is Databases

What is Oracle 11g.

SQL *Plus Over view.

Data Types

Operators

Expressions

Create Database

Create Table

Drop Table

Insert Query

Update Records

Select Query

Where Clause

AND & OR Clauses

Update Query

Delete Query

Like Clause

Order By

Group By

Distinct Keyword

Sorting Results

Constraints

Primary Key

Foreign Key

Using Joins

NULL Values

Indexes

Alter Command

Using Views

Having Clause

Wildcards

Date Functions

Sub Queries

Aggregate Functions

Character Functions

Numeric Functions

 

Oracle PL/SQL

What is PL/SQL

Basic Syntax

Blocks

Variables

Data Types

Operators

%Rowtype

%Type

Conditional Formatting

Loops

Cursors

Implicit Cursor

Explicit Cursor

Procedures

Functions

Triggers

Exceptions

 

 

 


Terms & Conditions

Fees once paid is not refundable