UrbanPro
true

Learn ORACLE SQL

LIVE
1 review
Ongoing

Course offered by Shivangi Sharma

6 reviews
This course has been prepared for the beginners to help them understand the basic to advanced concepts related to SQL languages.

Topics Covered

1.Introduction to SQL 1.1 What is SQL? 1.2 What is RDBMS? 1.2.1 Table 1.2.2 Datatypes 1.3 Types of SQL statements 2.Basic Elements of Oracle SQL 2.1. Basic SQL construct 2.2. Importance of NULL 2.3. Operators 2.3.1 Comparison operator 2.3.2 Arithmetic operators 2.3.3 Logical Operators 2.4. Expressions 3.Tables and Table Joins 3.1. Need for joins 3.2. Cartesian products 3.3. Column aliases 3.4. Types of joins 3.5. ANSI Syntax and Oracle Syntax for writing Join statements. 4.Filtering and Sorting data 4.1. Limiting rows retrieved 4.2. Using LIKE for pattern matching 4.3. Using logical operators AND, OR & NOT 4.4. Using BETWEEN & IN operators 4.5. Sorting data using ORDER BY clause 5.Oracle SQL Functions part 1 5.1. SQL Functions overview 5.2. What are single row functions? 5.3. Using Character functions 5.4. Using Number functions 5.5. Using Date and timestamp functions. Avoid the YY and RR pitfall. 5.6. Using CASE and DECODE functions. 5.7. Nested functions 5.8. Data type conversion functions 6.Oracle SQL Functions part 2 6.1. What are multi row functions? 6.2. Various multi row functions 6.3. Grouping data with GROUP BY clause 6.4. Using the HAVING clause 6.5. Sorting GROUP BY data 7.Nested SQL queries 7.1. Need for nested queries 7.2. Types of nested queries 7.3. USING EXISTS, ALL & ANY operators 8.Database Manipulation Language – DML and Transactions 8.1. What is data manipulation in a database? 8.2. Need for data manipulation 8.3. INSERT statement 8.4. UPDATE statement 8.5. DELETE statement 8.6. Definition of Transaction 8.7. COMMIT & ROLLBACK statements 8.8. Using the SAVEPOINT statement 8.9. MERGE statement 9.Database Definition Language – DDL 9.1. Creating tables 9.2. Modifying tables, adding constraints to a table, renaming a table and its columns. 9.3. Dropping columns (set unused command) and dropping tables. 9.4. Creating and replacing views 10.1. Creating and dropping public synonyms 10.2. Creating modifying and dropping sequences 10.3 Grant and Revoke of object privileges between two Oracle database users 11.Indexes and Index types 11.1. What are Indexes and how they work ? 11.2. Need for Indexes 11.3. Types of Indexes 11.4. Composite Indexes 11.5. Function based Indexes 11.6. Analyzing and rebuilding Indexes 12.Others 12.1. Set operators in SQL Language (UNION, UNION ALL, INTERSECT, MINUS) 12.2. RANK() and DENSE_RANK() functions 12.3. ROWID & ROWNUM 12.4. Various other Analytical functions 12.5. Data dictionary views

Who should attend

-Students -IT Developers -IT Testers -IT DBA

Pre-requisites

Nothing

What you need to bring

Laptop

Key Takeaways

-Understanding of SQL concepts -Ability to write SQL statements with ease

About the Trainer

Shivangi Sharma picture

5 Avg Rating

6 Reviews

8 Students

5 Courses

Shivangi Sharma

B.Tech from NIT having 7 yrs of IT experience

1 Years of Experience

I have more than 7 years of IT experience on UNIX and Oracle SQL and PL/SQL programming. I have been teaching UNIX and Oracle for past one year as a full time trainer.

Students also enrolled in these courses

LIVE

Course offered by Real time trainers

28 reviews
LIVE

Course offered by Swapnil Shimpi

0 review

Reviews (1)

5 out of 5 1 review

Shivangi S. https://p.urbanpro.com/tv-prod/member/photo/705434-small.jpg Kundalahalli
5.0051
Shivangi S.
D

Learn ORACLE SQL

"Class was excellent, I will recommend her as a teacher. "

View All
Have you attended any class with Swapnil?

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

Different batches available for this Course

5 out of 5 1 review

Shivangi S. https://p.urbanpro.com/tv-prod/member/photo/705434-small.jpg Kundalahalli
5.0051
Shivangi S.
D

Learn ORACLE SQL

"Class was excellent, I will recommend her as a teacher. "

Have you attended any class with Swapnil?

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 by Shivangi Sharma

Shivangi Sharma picture
LIVE
(1 reviews)

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 by Shivangi Sharma

Shivangi Sharma picture
LIVE
(1 reviews)

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