Oracle Database 12c Data Guard Administration Training

Oracle Database 11g: SQL Tuning Workshop Training

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.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Database11g Sql Tuning UpComing Batches

Dec-21 - Feb-01

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-14 - Jan-25

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-21 - Feb-01

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-28 - Feb-08

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Jan-04 - Feb-15

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-11 - Feb-22

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

DOWNLOAD BROCHURE

Oracle Database 11g: SQL Tuning

SELF PACED

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.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content
Topics:
  • 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.
Topics:
  • 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.
Topics:
  • 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?

Topics:
  • Looking Beyond Execution Plans.
  • Automatic Workload Repository (AWR).
  • Interpreting an Execution.
  • 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.
Topics:
  • End-to-End Application Tracing Challenge.
  • Use Enterprise Manager to Trace Services.
  • tkprof Output with and without Index: Example.
  • Location for Diagnostic.
  • 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.

Topics:
  • 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.

Topics:
  • Hash Join and Cartesian Join.
  • Equijoins and Nonequijoins.
  • Outer Joins.
  • Anti Joins.
  • Nested Loops Join.
  • Nested Loops Join: 11g Implementation.
  • Semi Joins.
  • Sort Merge Join.

Topics:
  • Result Cache Operator.
  • When Are Clusters Useful?
  • Filter Operations and Concatenation Operations.
  • Count Stop Key Operators.
  • 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.

Topics:
  • 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.
  • Star Transformation.
  • Retrieving Fact Rows from One Dimension and from All Dimensions.
  • Joining the Intermediate Result Set with Dimensions.

Topics:
  • Locking Statistics, Export/Import Statistics and Set Statistics.
  • Gathering System Statistics and Statistic.
  • 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.

Topics:
  • 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.

Topics:
  • 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.

Topics:
  • 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.

Topics:
  • 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.

Topics:
  • 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.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Curriculum

Course Description

About The Course
What is 11g: SQL Tuning Workshop Certification Training about? This Oracle Database 11g: SQL Tuning Workshop Release 2 training assists database developers, DBAs and SQL developers in identifying and tuning inefficient SQL statements. You'll explore investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement; this helps you determine the root causes of the inefficient SQL statements. Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data.These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
Expert instructors will also help you explore how the optimizer chooses the path. You'll also learn how to influence the optimizer to ensure the best method is used.
This course covers Automatic SQL Tuning tools and resources available in the Automatic Workload Repository. Furthermore, take advantage of bind variables, trace files and different types of indexes.
Note: this course is based on Oracle Database 11g Release 2.
Objectives Of Our Online PySpark Training Course
What are the objectives of 11g: SQL Tuning Workshop Certification Training ?
  • Trace an application through its different levels of the application architecture.
  • Understand how the Query Optimizer makes decisions about how to access data.
  • Define how optimizer statistics affect the performance of SQL.
  • List the possible methods of accessing data, including different join methods.
  • Identify poorly performing SQLModify a SQL statement to perform at its best.
Go For Online Spark Training
Who is 11g: SQL Tuning Workshop Certification Training for?
  • Application Developers.
  • Database Administrators.
  • Developer.
  • Support Engineer.
  • Data Warehouse Developer.
  • Data Warehouse Administrator.
  • PL/SQL Developer.
Learning With Our PySpark Certification Training
What are the prerequisites for 11g: SQL Tuning Workshop Certification Training? No Prerequisites required.

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers