Základní info
In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.bLearn To:/pse Oracle tools to identify inefficient SQL statements.se Automatic SQL Tuning.se Real Time SQL monitoring.rite more efficient SQL statements.onitor and trace high load SQL statements.anage optimizer statistics on database objects.nderstand the optimizer process steps and operators.nterpret execution plans.erform application tracing.bBenefits To You:/penefit from gaining a deeper understanding of Oracle SQL statement tuning and how to 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.bLive Virtual Class Format/p Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
