UrbanPro
true

Learn - Oracle SQL PL SQL - Step by Step

LIVE
35 Hours

Just Pay ₹1,500 to Register

- OR -

Course offered by Sagar Waikar

0 review

Learn Oracle – Beginner to Advanced SQL Course – Step by Step

Course Content

Duration: 6 weeks           Hours: 35

Database Concepts

What is the database?

What is relation database?

Introduction to RDBMS

What is a table?

Database Languages

DDL – Data Definition Language

DCL – Data Control Language

DML – Data Manipulation Language

Running Simple Query

Select Statement

Using multiple table in select

Using aliases with tables and columns

Describing a table

Using different SQL Operations

                DISTINCT

                IS NULL

                IS NOT NULL

                BETWEEN

                LIKE / NOT LIKE

                EXISTS

                NOT EXISTS

                IN

                NOT IN

Using Logical Operators

                AND

                OR

                NOT

Group Operations

                Group By

                Group by with having

Sorting / Ordering the results

                Sort by

                Order by

Manipulating the Data – DML

                Inserting data (INSERT Command)

                Updating existing data (Update Command)

                Deleting existing data (Delete Command)

                Commit and Rollback Statements

Working with DDL

                Creating / Renaming a table

                Altering a table

                Dropping a table

                Adding a column

                Dropping or modifying a column

Working with Joins

                Inner or Simple Join

                Right and Left outer join

                Full Outer Join

                Cross Join

Working with Conversion and Conditional Functions

                TO_CHAR

                TO_DATE

                String conversion functions

                DECODE

                CASE

Working with Group / Aggregate Functions

                MIN

MAX

SUM

AVG

COUNT

Working with String Functions

                LPAD/RPAD

                LTRIM / RTRIM

                SUBSTR

                REPLACE

                UPPER & LOWER

                LENGTH

                INITCAP

                CONVERT

                CONCAT

                ASCII

                INSTR

                NVL

                NVL2

                NULLIF

Working with Subqueries

                Single Row

                Multiple Row

Combining the Queries

                UNION/ UNION ALL

                MINUS

                INTERSECT 

Gallery (5)

About the Trainer

Sagar Waikar picture

Avg Rating

0 Reviews

0 Students

1 Courses

Sagar Waikar

Bachelor of Science, Master of Computer Management

17 Years of Experience

IT Industry experience for over 17 years . Have worked on PeopleSoft HCM for over 12 years and also have worked on various databases like Oracle 11g, 12c, Microsoft SQL server.

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Learn - Oracle SQL PL SQL - Step by Step by Sagar Waikar

Sagar Waikar picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Learn - Oracle SQL PL SQL - Step by Step by Sagar Waikar

Sagar Waikar picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free 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

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

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