Register for Waitlist
,
This class if full now. You can register on the wait list to be notified when a seat becomes available.
Oracle Database 11g: SQL Tuning Workshop Training
Live Online & Classroom Enterprise Certification Training
Powered By
This Database 11g SQL Tuning Workshop training teaches database developers, DBAs and SQL developers to identify and tune inefficient SQL statements. Learn how to investigative methods to reveal how the Oracle database executes the SQL statement.
Powered By
Looking for a private batch ?
REQUEST A CALLBACKNeed help finding the right training?
-
Certified Trainer
-
Authorized Courseware
-
Completion Certificate from ATP
-
Enterprise Reporting
-
Lifetime Access
-
CloudLabs
-
24x7 Support
-
Real-time code analysis and feedback
What is 11g: SQL Tuning Workshop Certification Training about?
What are the objectives of 11g: SQL Tuning Workshop Certification Training ?
Who is 11g: SQL Tuning Workshop Certification Training for?
What are the prerequisites for 11g: SQL Tuning Workshop Certification Training?
Available Training Modes
Live Online Training
24 HoursClassroom Training
3 DaysCourse Outline Expand All
Expand All
- Oracle Database Server Architecture: Overview
- Automated SQL Execution Memory Management
- Database Storage Architecture, Logical and Physical Database Structures
- Physical Structure
- Segments, Extents, and Blocks & SYSTEM and SYSAUX Tablespaces
- Automatic Shared Memory Management
- Connecting to the Database Instance
- Oracle Database Memory Structures: Overview
- Monitoring and Tuning Tools: Overview
- Scalability with Application Design, Implementation, and Configuration
- Simplicity in Application Design
- Reason for Inefficient SQL Performance
- Performance Monitoring Solutions
- Common Mistakes on Customer systems & Proactive Tuning Methodology
- CPU and Wait Time Tuning Dimensions
- Data Modeling, Table Design, Index Design, Using Views, SQL Execution Efficiency, Overview of SQL*Plus & SQL Developer
- Transformer & Estimator
- Optimization During Hard Parse Operation
- SQL Statement Parsing: Overview
- Structured Query Language
- Plan Generator
- Cost-Based Optimizer
- Controlling the Behavior of the Optimizer, Optimizer Features and Oracle Database Releases
- Why Do You Need an Optimizer?
- Looking Beyond Execution Plans
- Automatic Workload Repository (AWR)
- Interpreting an Execution Plan
- Using the V$SQL_PLAN View
- What Is an Execution Plan? Where To Find Execution Plans and Viewing Execution Plans
- Reading More Complex Execution Plans and Reviewing the Execution Plan
- SQL Monitoring: Overview
- Plan Table & AUTOTRACE
- End-to-End Application Tracing Challenge
- Use Enterprise Manager to Trace Services
- tkprof Output with and without Index: Example
- Location for Diagnostic Traces
- What is a Service? Use Services with Client Applications & Tracing Services
- Session Level Tracing: Example
- The trcsess Utility and SQL Trace File Contents
- Invoking the tkprof Utility and Output of the tkprof Command
- Row Source Operations, Main Structures and Access Paths
- Index-Organized Tables
- Bitmap Indexes, Bitmap Operations and Bitmap Join Index
- Guidelines for Managing Indexes and Investigating Index Usage
- Using Indexes: Considering Nullable Columns
- Full Table Scan
- Indexes: Overview and B*-tree Indexes and Nulls
- Composite Indexes and Invisible Index
- Hash Join and Cartesian Join
- Equijoins and Nonequijoins
- Outer Joins
- Antijoins
- Nested Loops Join
- Nested Loops Join: 11g Implementation
- Semijoins
- Sort Merge join
- Result Cache Operator
- When Are Clusters Useful?
- Filter operations and Concatenation Operations
- Count Stop Key Operator
- Min/Max and First Row Operators and Other N-Array Operations
- Sorting Operators and Buffer Sort Operator
- Inlist Iterator and View Operator
- UNION [ALL], INTERSECT, MINUS
- Star Transformation Hints
- Using Bitmap Join Indexes
- The Star Schema Model and The Snowflake Schema Model
- Bitmap Join Indexes: Join Model 1 to 4
- Star Transformation Plan Examples
- Star Transformation
- Retrieving Fact Rows from One Dimension and from All Dimensions
- Joining the Intermediate Result Set with Dimensions
- Locking Statistics, Export/Import Statistics and Set Statistics
- Gathering System Statistics and Statistic Preferences
- Manual Statistics Gathering
- Table, Index and Column Statistics
- Histograms, Frequency Histograms and Histogram Considerations
- Types of Optimizer Statistics
- Multicolumn Statistics and Expression Statistics Overview
- Index Clustering Factor
- Bind Variable Peeking
- Cursor Sharing Enhancements
- The CURSOR_SHARING Parameter
- Interacting with Adaptive Cursor Sharing
- Cursor Sharing and Different Literal Values
- Forcing Cursor Sharing
- Adaptive Cursor Sharing
- Cursor Sharing and Bind Variables
- Tuning SQL Statements Automatically
- Database Control and SQL Tuning Advisor
- Stale or Missing Object Statistics and SQL Statement Profiling
- SQL Tuning Loop, Access Path Analysis and SQL Structure Analysis
- Application Tuning Challenges
- SQL Tuning Advisor: Overview
- Implementing Recommendations
- Plan Tuning Flow and SQL Profile Creation
- SQL Access Advisor: Overview
- SQL Access Advisor: Schedule and Review
- SQL Access Advisor: Workload Source
- SQL Access Advisor: Results
- Possible Recommendations
- SQL Access Advisor Session: Initial Options
- SQL Access Advisor: Recommendation Options
- SQL Access Advisor: Results and Implementation
- Automatic SQL Tuning
- Automatic SQL Tuning: Result Summary
- Configuring Automatic SQL Tuning
- SQL Tuning Loop
- Automatic SQL Tuning: Result Details
- Automatic SQL Tuning Result Details: Drilldown
- Automatic SQL Tuning Considerations
- Automatic Tuning Process
- SQL Plan Baseline: Architecture
- Maintaining SQL Performance and SQL Plan Management: Overview
- SQL Plan Selection
- Enterprise Manager and SQL Plan Baselines
- Possible SQL Plan Manageability Scenarios
- SQL Performance Analyzer and SQL Plan Baseline Scenario
- Loading a SQL Plan Baseline Automatically and Purging SQL Management Base Policy
- Important Baseline SQL Plan Attributes
Who is the instructor for this training?
The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.
11g: SQL Tuning Workshop Certification Training - Certification & Exam
- SpringPeople is the Authorized Training Partner of Oracle.
- The training fees is exclusive of exam cost.
- For any queries; feel free to reach us at oracle@springpeople.com
Reviews
Previous
Next
My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!
Shweta Priya
Sony
I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.
Swati Singh
GE
I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.
Nikhil Kohli
Stryker
I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!
Heena Rajan
Mindtree
