UrbanPro
true

Oracle SQL & PL/SQL Performance Tuning

LIVE
26 reviews
Ongoing

Course offered by Vinay

50 reviews

Learn most advanced & updated content from industry experts having 15+ years of experience.

96 Hrs. of Instructor led online classroom with 3 real time Industry based projects

Course aligned with the official Oracle Certification Guide

Prepares to clear 1Z0 -071 Exam for Developer track & OCP 1Z0-082 exam Admin Track

Hands on practice on Oracle platform and 100+ sample programs Practical Hands-on Workshops

Lifetime access to Oracle Community forum and e-learning content and pdf materials

Course completion certificate.   Resume Preparation and mock Interviews

++++++++ SQL +++++++++++

  Introduction to Database
  Relational Database Concepts
  Data Model
  Normalization
  Introduction to Oracle Database
  Basic Elements of Oracle SQL, Oracle Built-in Datatypes
  Types of SQL
  Retrieving Data Using the SQL SELECT Statement
  Restricting and Sorting Data
  Using Single-Row Functions to Customize Output
  Reporting Aggregated Data Using the Group Functions
  Displaying Data from Multiple Tables
  Using Subqueries to Solve Queries
  Hierarchical Queries
  Using the Set Operators
  Advance Analytical Functions
  Manipulating Data
  Using DDL Statements to Create and Manage Tables
  Managing Schema Objects
  Table Partitions
  Creating Other Schema Objects
  Other Schema Objects
  Control User Access
  Management of Schema Objects with Data Dictionary Views
  Regular Expression Support - REGEXP
 

++++++++++++ PLSQL ++++++

Mastering ORACLE 12c PL SQL for Development
  Overview of PL/SQL
  PL/SQL Programming Language Fundamentals
  PL/SQL Datatypes
  PL/SQL Control Structures and Loops
  Error Handling & Built-in Expressions
  User Defined Exceptions 
  Design Considerations For PL/SQL Code
  Introduction Cursor 
  Advance Cursor
  Triggers  
  Working with Compound, DDL and Event Database Triggers
  Collections
  Records
  Using Static SQL
  Dynamic SQL
  PL/SQL Bulk Operation and Exception handling
  Procedures
  Functions
  Packages
  Tuning PL/SQL Applications for Performance
  Using Oracle Supplied Packages in Application Development
  Wrapping PL/SQL Source Code
 +++++++++++++ Performance tuning +++++++++++
    What is causing modern day performance issues?
    How to overcome modern day performance issues?
    Performance Gains by SQL Tuning (Behind Indexes)
    Types of Indexes.
    Understanding Structures of B-TREE, BITMAP Indexes
    Function based Indexes (FBI), Foreign Key Indexes (FKI)
    VISIBLE and INVISIBLE Indexes. 
    Monitoring and Managing Unused Indexes.
    Optimizer Fundamentals
    Displaying PLAN_TABLE: AUTOTRACE, TRACEONLY, STATISTICS
    Optimizer : Table and Index Access Paths
    Understanding Explain Plan
    Joins, Loops
    Writing Optimized SQL
    Effective indexing, Single Column Indexes , Composite Indexes
    How to Measure Index SELECTIVITY
    Gather Stats , Introduction to Histograms
    Table Partition , Index Partition, LOCAL and GLOBAL Indexes
    Partition Pruning
    Introduction to IOT tables
    Use of Optimizer HITS, PARALLEL, INDEX, ALL_ROWS, FIRST_ROWS
    Issues with Delete, Resetting High Water Mark
    Using Bind Variables
    Issues with Skew data
    Tracing SQL Executions
    Oracle dictionary tables for Indexes Monitoring, DBA_INDEXES, DBA_IND_COLUMNS
    Concept of RESULT_CACHE and Usage

Curriculum for ADMINâ??s
    Performance Gains by Instance Tuning/Database configuration (Behand Indexes)
    Introduction to Oracle Memory Management and caches
    Understanding SGA/PGA/ Shared Pool, KEEP pool, Recycle pools.
    Fixed allocation memory allocation v/s automatic Memory Management (AMM)
    Tuning the Shared Pool
    Tuning the Buffer Cache
    Impact of REDO LOGS Switch, Archive, NO Archive databases
    Understanding diagnostic reports such as AWR, ADDM and ASH reports
    Working in RAC Database. Importance of sequence caching
    Reverse Key Indexes, Use of HASH Partitioned Indexes.
    About SQL Tuning Sets (STS)
    Concept of cursor sharing attributes, Adaptive Cursor Sharing

Gallery (8)

+1 more

About the Trainer

5 Avg Rating

50 Reviews

69 Students

9 Courses

Vinay

BE Computer Science

IT Professionals with more than 15 years of Experience worked in highly reputed MNC across Europe, USA and APAC region. Proven track of experience in delivering End to End enterprises level solutions globally. Had written book on oracle performance tuning. documented 1000+ sample programs based on real time problems and industry needs.

Worked in Global brans like Oracle , IBM also in TOP Indian MNC'sl like TCS , Mphasis and leading banks like JP Morgan. Deep knowledge in oracle database technologies and trained 100+ students and successfully placed in leading IT companies

Students also enrolled in these courses

LIVE

Course offered by Inventateq

44 reviews
LIVE
4 reviews
28 Hours

Course offered by Sasidhar

34 reviews
LIVE
5 Hours

Course offered by Avinash Kumar

0 review

Reviews (26)

5 out of 5 26 reviews

Ignited Minds Technologies https://www.urbanpro.com/assets/new-ui/institute-100X100.png Yelahanka
5.00526
Ignited Minds Technologies
A

Oracle SQL & PL/SQL Performance Tuning

"These people are dedicated too much towards students. They make us understand concepts very well by providing various examples. It's best training institute I can suggest. They train us very well. "

Ignited Minds Technologies
C

Oracle SQL & PL/SQL Performance Tuning

"It's a wonderful opportunity to get a job and I am so happy to knowing dis one before going to this he is good person and teaching level is good and heartly thanks to sir is look like god to every student. It is good platform to learn. I suggesting every one to join this institute otherwise don't know about this ..Once join u get a lot of information and get a job."

Ignited Minds Technologies
B

Oracle SQL & PL/SQL Performance Tuning

"Best place to learn something new. I have attended similar courses before; But yours is most useful and memorable. "

Ignited Minds Technologies
L

Oracle SQL & PL/SQL Performance Tuning

"It was a really very good experience. All the details covered by sir is really great. Every smallest information was well explained by sir. I am really thankful to sir "

View All
Have you attended any class with Avinash?

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 26 reviews

Ignited Minds Technologies https://www.urbanpro.com/assets/new-ui/institute-100X100.png Yelahanka
5.00526
Ignited Minds Technologies
A

Oracle SQL & PL/SQL Performance Tuning

"These people are dedicated too much towards students. They make us understand concepts very well by providing various examples. It's best training institute I can suggest. They train us very well. "

Ignited Minds Technologies
C

Oracle SQL & PL/SQL Performance Tuning

"It's a wonderful opportunity to get a job and I am so happy to knowing dis one before going to this he is good person and teaching level is good and heartly thanks to sir is look like god to every student. It is good platform to learn. I suggesting every one to join this institute otherwise don't know about this ..Once join u get a lot of information and get a job."

Ignited Minds Technologies
B

Oracle SQL & PL/SQL Performance Tuning

"Best place to learn something new. I have attended similar courses before; But yours is most useful and memorable. "

Ignited Minds Technologies
L

Oracle SQL & PL/SQL Performance Tuning

"It was a really very good experience. All the details covered by sir is really great. Every smallest information was well explained by sir. I am really thankful to sir "

Ignited Minds Technologies
V

Oracle SQL & PL/SQL Performance Tuning

"Vinay sir is so dedicated towards training and professional.I am so glad to join ignited minds because I am so happy that my confidence level has been risen tremendously of getting a job. "

Ignited Minds Technologies
N

PL/SQL

"Training is very good. It is helpful for both freshers as well as experienced professionals to revise concepts. "

Ignited Minds Technologies
H

Oracle SQL & PL/SQL Performance Tuning

"I have been taking course and this is helping me a lot. Even now what they are teaching is something taking me an interest in python sql and plsql. "

Ignited Minds Technologies
N

Oracle SQL & PL/SQL Performance Tuning

"This training centre & institute is located at good place & doing wonders for students as well as aspiring people. Thank you so much for your support. Highly recommended to all. Has good grip in the concept. "

Ignited Minds Technologies
G

PL/SQL

"Very knowledgeable and out spoken, well experienced faculty. Very supportive and helps trainees to clear interviews. Online coaching too available. "

Ignited Minds Technologies
R

PL/SQL

"A friendly training institute which provides industry based training with placement. The faculties have industry based knowledge from 15+years . Highly recommended for students who are looking for IT software carrier in duration of 2 months. I got job after training. Many thanks. "

Ignited Minds Technologies
A

Oracle SQL & PL/SQL Performance Tuning

"Excellent teaching and Easy understanding. Its very useful for people who want to learn SQL and PLSQL. Thank you so much for your support. "

Ignited Minds Technologies
A

Oracle SQL & PL/SQL Performance Tuning

"I joined this institute to take training for oracle sql & pl/sql. My all over experience is very good. The knowledge given by sir is very helpful to me during and after the completion of training program. "

Ignited Minds Technologies
U

Oracle SQL & PL/SQL Performance Tuning

"Best place to skill up. Great presentation style with lots of examples ,industrial projects and continuous assessment which will help us to grow in professional life. Trainer is having more than 18+ years of IT experience. "

Ignited Minds Technologies
N

PL/SQL

"Ignited Minds is one of the best training institute to get placed. Here vinay is very supportive and he teach us concepts very well. Thank you ignited minds. "

Ignited Minds Technologies
U

Oracle SQL & PL/SQL Performance Tuning

"Excellent training. Assignments on each topics and before start the new topics will discuss assignment, clear all the doubts and continue with new topic. Mock interviews. "

Ignited Minds Technologies
S

Oracle SQL & PL/SQL Performance Tuning

"The best tutor for PL sql and SQL in Bangalore with python. Experienced dedicated and makes it affordable to all. Excellent on placements. "

Ignited Minds Technologies
M

Oracle SQL & PL/SQL Performance Tuning

"Trainers having more than 15 years of experience in software field...One of the best institution to get job in your dream company... A best experiences which I earned here making me to suggest all others...Soo don't time as a unemployed...So join here as early as possible to these institution and transform all your dreams into reality... "

Ignited Minds Technologies
A

Oracle SQL & PL/SQL Performance Tuning

"Excellent coaching center.My trainer was Vinay he had such a great experience in oracle plsql and he is such a good human being. "

Ignited Minds Technologies
P

Oracle SQL & PL/SQL Performance Tuning

"I was Trained by Vinay on Oracle Plsql it was Excellent coaching and placement garuntee.... Highly recommended for who needs break through in IT career. "

Ignited Minds Technologies
C

Oracle SQL & PL/SQL Performance Tuning

"Thank you so much for making a subject I was worried about disliking, a class that I was excited to show up to. You truly made my semester one of the best I’ve ever had. The teaching was fantastic, teaching so keenly makes us understand very accurately and yeah doing a lot of assignments made it easy for me. Had a great experience learning here. "

Ignited Minds Technologies
A

PL/SQL

"I am very happy to join with this Institute. The faculty are very friendly and teaches with simple real time examples to understand concepts better. Faculty having a wide experiences in this domain they enjoying their passion by providing good teaching and interaction methods. "

Ignited Minds Technologies
S

Oracle SQL & PL/SQL Performance Tuning

"I started to studying in this institution, a very good institute better than others, better to study before joining the JOB. "

Ignited Minds Technologies
S

Oracle SQL & PL/SQL Performance Tuning

"I had a nice experience in ignited mined institution because i have learnt a lot and faculties are very good they are well knowledgeable and well experienced at top most MNCâ??s. They are also providing materials nicely and fluently. I am personally suggesting ignite minds whoever is looking to learn software applications join their get trained by the most experienced faculties come out, definitely you will be placed at your dream company. Thank you! "

Ignited Minds Technologies
C

Oracle SQL & PL/SQL Performance Tuning

"Good guys on training and development, good faculty and industry experts. Nice infra and convenient location around yelahanka for IT training. "

Ignited Minds Technologies
M

Oracle SQL & PL/SQL Performance Tuning

"Best in class training, Trainers are all from Industries with minimum 10 Years of exp. This is not traditional training institute, here lot of importance given to real world problems. Lot of Mock interviews will be conducted and will make sure you are ready for your dream job. "

Ignited Minds Technologies
H

Oracle SQL & PL/SQL Performance Tuning

"Great place to learn gains knowledge step by step packed with lots of useful information. Best coaching given. "

Have you attended any class with Avinash?

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

Oracle SQL & PL/SQL Performance Tuning by Vinay

Samarth picture
LIVE
(26 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

Oracle SQL & PL/SQL Performance Tuning by Vinay

Samarth picture
LIVE
(26 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