Discover Classes. Earn 10% Rewards.

Oracle Database 12c: Tuning For Developers is unfortunately unavailable

Thankfully we have 361 other All Software Classes for you to choose from. Check our top choices below or see all classes for more options.

Certified Information Systems Security Professional (Virtual)

Technical Institute of America See all classes by this school @ Virtual Classroom

Master all 8 CISSP domains through live virtual instruction from experienced, CISSP-certified professionals with a 97% exam success rate. Access official prep materials, and practice exams, with a money-back certification guarantee to ensure you pass.

(633) All levels 18 and older
$1,499

5 sessions

Attend
+14990 pts
Gift it!

Excel Level I: Fundamentals

Noble Desktop See all classes by this school - Virtually Online

Build a confident foundation in Microsoft Excel through this practical workshop at Noble Desktop. You'll work with calculations, functions, charts, formatting, and print layouts to manage data and produce well-structured spreadsheets.

(452) Beginner 18 and older
$299

2 sessions

Gift it!

Excel Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Gain comprehensive Excel expertise in this intensive three-day course that moves from foundational calculations through to advanced automation with macros. Whether you're building on basic knowledge or aiming for expert-level proficiency, this well-paced program covers the full range of tools and techniques that make Excel an indispensable asset in any professional setting.

(452) Beginner 18 and older
$599

6 sessions

Gift it!

Excel Specialist Certification Program

Noble Desktop See all classes by this school - Virtually Online

Become an expert in Microsoft Excel and strengthen your resume through this comprehensive certification program. Get lifetime access to video courses, private training, and free proctored exams. Grow your skills and stand out in the competitive job market.

(452) All levels 18 and older
$959

6 sessions

Gift it!

Excel Expert Certification Program

Noble Desktop See all classes by this school - Virtually Online

Reach advanced Excel proficiency in this complete program. Through group sessions, private instruction, and a certification exam with one free retake, you'll cover formulas, functions, PivotTables, charts, and career-boosting tools.

(452) All levels 18 and older
$1,149

3 sessions

Gift it!
See all All Software classes Online

Oracle Database 12c: Tuning For Developers

  • Intermediate
  • 16 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Live Online Training
  • 24 hours over 3 sessions

Start Dates (0) $2,316/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

In this course, students learn about Oracle SQL tuning and how to apply tuning techniques to their SQL code. This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL. It covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, and how to determine if those are the most efficient ways is a particular database. Student will learn how to ensure that the best method is used.

Learning Objectives:

  • Modifying a SQL statement to perform at its best
  • Identifying poorly performing SQL
  • Tracing an application through its different levels of the application architecture
  • Understanding how the Query Optimizer makes decisions about how to access data
  • Defining how optimizer statistics affect the performance of SQL
  • Listing the possible methods of accessing data, including different join methods

Prerequisites

Required:

  • Familiarity with database architecture
  • Knowledge of SQL and PL/SQL
  • Oracle Database: Introduction to SQL Ed 2

Who Should Go For This Training?

  • Administrator
  • Developer

Course Outline:

  • Introduction
  • Introduction to SQL Tuning
  • Using Application Tracing Tools
  • Understanding Basic Tuning Techniques
  • Optimizer Fundamentals
  • Generating and Displaying Execution Plans
  • Interpreting Execution Plans and Enhancements
  • Optimizer Join Operations
  • Other Optimizer Operators
  • Introduction to Optimizer Statistics Concepts
  • Using Bind Variables
  • SQL Plan Management
  • Workshops

Learn more about Oracle Database 12c: Tuning For Developers at NetCom Learning.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

A student who cancels within 7 days of signing the enrollment agreement but before instruction begins receives all monies returned with the exception of the non-refundable registration fee.

Thereafter, a student will be liable for:

  • The non-refundable registration fee of $100 plus
  • The cost of any textbooks or supplies accepted plus
  • Tuition liability as of the student's last date of physical attendance
If Termination Occurs

  • Prior to or during the first week - 0% Penalty
  • During the second week - 25% Penalty
  • During the third week - 50% Penalty
  • During the fourth week - 75% Penalty
  • After the fourth week - 100% Penalty

The failure of a student to notify CourseHorse in writing of withdrawal may delay a refund of tuition.

Reviews of Classes at NetCom Learning (16)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 23160 points. Earn 10% back in reward points!

NetCom Learning

NetCom Learning is a leading provider of training and certification solutions for businesses, individuals, and government agencies. With over 20 years of experience, NetCom has worked with Fortune 500 companies, serviced thousands of business customers, and advanced the careers of over 50,000 professionals through expert-led training.

View school profile
NetCom Learning
Vetted by CourseHorse

A verified Online educator.

Loading...