UrbanPro
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

true
true

"Online Workshops : Learn Oracle 11g SQL & PL/SQL on 17th May, 2015" is no longer available

No Reviews Yet

Course type: Instructor led Course

Platform: Skype or Google Hang out

Course ID: 13593

Course type: Instructor led Course

Platform: Skype or Google Hang out

Batches conducted 1

Total Students 2

₹ 5,500

Chandrasekhar N
No Reviews Yet

About the Course

Online Workshops : Learn Oracle 11g SQL & PL/SQL,

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

Who should attend

Any student/working people who had basic knowledge of computers.

Pre-requisites

Basic Knowledge of Computers

What you need to bring

Should have a computer and internet connection""

Key Takeaways

Every participant will get a participation certificate.

Oracle SQL & PL/SQL notes & Assignments will be given for practise.

Every participant will have a computer at the venue for hands on practice on oracle in the workshop
Tea/Coffee will be provided.

All the participants will get certificates & Assignments also.

You will gain knowledge of how to write Oracle SQL queries & PL/SQL Blocks.

Date and Time

Not decided yet.

About the Trainer

Avg Rating

Reviews

Students

Courses

Chandrasekhar N

MCA & Many Computer Diploma

20 Years of Experience

I have more than 19 years of experience as a Software trainer in the IT Industry.


Have conducted Class Room Training, Online Training, as well as conducted IT Workshops & Seminars from time to time across the country.

Have also conducted corporate Training's also from time to time.

Have trained people from all walks of life like college/engineering students and corporate employees.

Have trained more than 500 corporate batches and 5,000 students.

Have been conducting training for various IT Programs like

RDBMS, Oracle10g/11g (SQL & PL/SQL)
SQL Tuning.
Database Tuning.
Oracle 10g (Forms & Reports)
Oracle Developer Suite 10g
Oracle 11g SQL Tuning
Oracle 11g Database Tuning
MySQL
Oracle SQL Developer.
MS-SQL Server 2008 / 2012.

Oracle DBA
MySQL DBA
C & C++.
Core Java.

MySQL
Unix, Linux, Shell Script.
HTML, HTML5, CSS3, Java Script, VBScript.

Python, Ruby, Ruby on Rails.
Advance Excel & VBA Macros
MS-Access.

Reviews

No reviews currently

Chandrasekhar N

No Reviews Yet

Batches conducted 1

Total Students 2

₹ 5,500

Copy

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at

hour

To join, click

Add to Google Calendar

Share this Master class

Message copied

How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more