Signup as a Tutor

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

"Oracle PL/SQL" is no longer available

No Reviews Yet

Gurgaon HO, Gurgaon

Course ID: 35677

Gurgaon HO, Gurgaon

No Reviews Yet

About the Course


DATA WAREHOUSING CONCEPTS ? Class 0 (Complimentary)

Basic data warehousing sessions

?Slowly changing dimensions

?Data marts

?Normalization denormalization

Class 1

1: Introduction - Architecture

2: Retrieving Data Using the SQL SELECT Statement


Class 2

3: Restricting and Sorting Data

4: Using Single-Row Functions to Customize Output



Class 3

5: Reporting Aggregated Data Using the Group Functions

6: Displaying Data from Multiple Tables



Class 4

7: Using Subqueries to Solve Queries

8: Using the Set Operators



Class 5

9: Manipulating Data

10: Using DDL Statements to Create and Manage Tables



Class 6

11: Creating Other Schema Objects

12: Managing Objects with Data Dictionary Views

Class 7

13: Controlling User Access

14: Managing Schema Objects



Class 8

15: Retrieving Data Using Subqueries

16: Introduction to PL/SQL



Class 9

17: Declaring PL/SQL Variables

18: Writing Executable Statements



Class 10

19: Writing Control Structures

20: Handling Exceptions



Class 11

21: Creating Stored Procedures

22: Performance tuning



Class 12

Questions and Interview preparation

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

7 Reviews

45 Students

4 Courses



EduGuys (Formerly Stay Ahead) was founded in 2010 by a group of highly qualified Engineers (with proven expertise in varied technology domains) as a Center for education, training & software development at Gurgaon.
Stay Ahead holds the distinction of being a unique group, offering a variety of services with their comprehensive training and online consultancy experiences.
We are with a mission to provide comprehensive and accurate training information to all the prospective value conscious training buyers for any domain.
At Stay Ahead, we are your career partner, providing you with a lifetime of progressive learning products, which will ensure you have the knowledge, flexibility and interest to sustain a rewarding and exciting career.
Whether you are just starting out in the IT industry, want to change jobs, looking for a promotion or set up your own consulting business, Stay Ahead has the right building blocks for your career. We recognize that your career must be built to your own specifications.
Wherever possible, we make learning at your own pace, in your own time (and with your own special focus) as easy as possible, with online peer forums, articles, mentoring support and other support services.
Our business is dedicated to delivering good quality, inexpensive services that will improve the quality of work at all levels in an organization. We strongly believe in "Building a Network" which will help not only our clients but also us".


No reviews currently Be the First to Review


Post your requirement and let us connect you with best possible matches for Oracle Training Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on 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