Oracle Database 12c R2: SQL Tuning for Developers Ed 2
Duration : 3 Days (24 Hours)
Oracle Database 12c R2: SQL Tuning for Developers Ed 2 Course Overview:
Structured Query Language, commonly known as SQL, is a specialized language utilized for programming and designing information within relational database systems. It serves as the most widely used language for extracting and organizing data. In business environments dealing with large volumes of information daily, it becomes crucial to engage knowledgeable professionals to ensure secure and easily accessible data organization.
The Oracle Database 12c R2: SQL Tuning for Developers Ed 2 training program aims to enhance the expertise of database management professionals. This course introduces various tuning techniques that facilitate seamless insertion, searching, updating, and deletion of records. Professionals seeking to optimize their efficiency and effectiveness in database configuration should consider enrolling in this course. For more details and enrollment, please refer to the provided schedule for the Oracle Database 12c R2: SQL Tuning for Developers Ed 2 course.
Intended Audience:
- IT Professionals
- Support Engineers
- NoSQL Developers
- Security Administrators
- Website Administrators
- Data Scientists
- Database Architects
- Database Administrators
- Data Warehouse Developers
- Application Developers
- Technical Support Professionals
- Aspiring Oracle Database Professionals
- Professionals looking to gain a proper understanding of the Oracle Database with SQL Tuning
- Candidates who are looking to sit for the Oracle Database 1Z0-071 certification exam
Learning Objectives of Oracle Database 12c R2: SQL Tuning for Developers Ed 2:
- 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 Operations
- Introduction to Optimizer Statistics and Concepts
- Using Bind Variables
- SQL Plan Management
Module 1: Introduction
- Course Objectives, Course Agenda and Appendixes Used in this Course
- Audience and Prerequisites
- Sample Schemas Used in the Course
- Class Account Information
- SQL Environments Available in the Course
- Workshops, Demo Scripts, and Code Example Scripts
- Appendices in the Course
Module 2: Introduction to SQL Tuning
- SQL Tuning Session
- SQL Tuning Strategies
- Development Environments: Overview
- SQLTXPLAIN (SQLT) Diagnostic Tool
Module 3: Using Application Tracing Tools
- Using the SQL Trace Facility: Overview
- Steps Needed Before Tracing
- Available Tracing Tools: Overview
- The trcsess Utility
- Formatting SQL Trace Files: Overview
Module 4: Understanding Basic Tuning Techniques
- Developing Efficient SQL statement
- Scripts Used in This Lesson
- Table Design
- Index Usage
- Transformed Index
- Data Type Mismatch
- NULL usage
- Tune the ORDER BY Clause
Module 5: Optimizer Fundamentals
- SQL Statement Representation
- SQL Statement Processing
- Why Do You Need an Optimizer?
- Components of the Optimizer
- Query Transformer
- Cost-Based Optimizer
- Adaptive Query Optimization
- Optimizer Features and Oracle Database Releases
Module 6: Generating and Displaying Execution Plans
- Execution Plan?
- The EXPLAIN PLAN Command
- Plan Table
- AUTOTRACE
- V$SQL_PLAN View
- Automatic Workload Repository
- SQL Monitoring
- DBML_SQL_MONITOR
Module 7: Interpreting Execution Plans and Enhancements
- Interpreting a Serial Execution Plan
- Adaptive Optimizations
- Optimizer: Table and Index Access Paths
- Row Source Operations
- Main Structures and Access Paths
- Full Table Scan
- Indexes
- Common Observations
Module 8: Optimizer Join Operations
- Join Methods
- Join Types
Module 9: Other Optimizer Operators
- SQL operators
- Other N-Array Operations
- Result Cache operators
Module 10: Introduction to Optimizer Statistics Concepts
- Optimizer Statistics
- Types of Optimizer Statistics
- Gather and Manage Optimizer Statistics: Overview
Module 11: Using Bind Variables
- Cursor Sharing and Different Literal Values
- Cursor Sharing and Bind Variables
Module 12: SQL Plan Management
- Maintaining SQL Performance
- SQL Plan Management
Module 13: Workshops
Oracle Database 12c R2: SQL Tuning for Developers Ed 2 Course Prerequisites:
In order to sit this Oracle Database 12c R2: SQL Tuning for Developers Ed 2 training, candidates must have completed the Oracle Database: Introduction to SQL course and have;
- Familiarity with database architecture
- Knowledge of SQL and PL/SQL
Discover the perfect fit for your learning journey
Choose Learning Modality
Live Online
- Convenience
- Cost-effective
- Self-paced learning
- Scalability
Classroom
- Interaction and collaboration
- Networking opportunities
- Real-time feedback
- Personal attention
Onsite
- Familiar environment
- Confidentiality
- Team building
- Immediate application
Training Exclusives
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!
Request More Details
