- Duration: 3 Days
Course details
Introduction
This three day Oracle Database: SQL Tuning for Developers course will teach you about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how write well-tuned SQL statements appropriate for the Oracle database in this application development-centric course. You will learn how to decipher, decide and then apply tuning to your SQL code. Various tuning techniques are demonstrated.
Course Content
- Lesson 1: Course Introduction
- Lesson 2: Introduction to SQL Tuning
- Lesson 3: Using Application Tracing Tools
- Lesson 4: Understanding Basic Tuning Techniques
- Lesson 5: Optimizer Fundamentals
- Lesson 6: Generating and Displaying Execution Plans
- Lesson 7: Interpreting Execution Plans and Enhancements
- Lesson 8: Optimizer: Table and Index Access Paths
- Lesson 9: Optimizer: Join Operators
- Lesson 10: Other Optimizer Operators
- Lesson 11: Introduction to Optimizer Statistics Concepts
- Lesson 12: Using Bind Variables
- Lesson 13: SQL Plan Management
- Lesson 14: Workshops
About Torque IT
About Torque IT
With over 20 years of experience, Torque IT is recognised throughout the globe as the principal InformationCommunication Technology (ICT) training solutions provider to blue chip companies and the public sector.
The Torque IT business is based on a culture of customer service and an unwavering commitment to always providing the highest quality product and service available. Torque IT offers completely customizable training and enablement solutions that are tailored to your specific requirements whilst retaining the quality and credibility associated with standard vendor authorized training courses.
See all Torque IT courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Oracle 11g PL/SQL Beginner Skill-UpUSD 15
USD 240Duration: Upto 10 Hours - Practical Database Design – Blog Schema Course LineUSD 24Duration: Upto 6 Hours