Oracle Database 11g: Architecture, SQL Tuning, and Optimization

Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisite
Oracle Database 11g: Introduction to SQLOracle Database 11g: SQL Fundamentals I

Expected Duration
120 minutes

Description
The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical storage structures. It also examines SQL tuning, identifying the attributes of a SQL statement that can make it perform poorly, SQL tuning tools, and common tuning tasks. The steps involved in the execution of a SQL statement, the optimizer and its phases, and controlling optimizer behavior are also covered.

Objective

Database Architecture and SQL Tuning

  • recognize Oracle database structures
  • recognize how to manage memory and database structures
  • identify SQL statements that cause poor performance
  • identify tools and tasks in SQL tuning

SQL Processing and the Optimizer

  • recognize how SQL statement execution works
  • recognize the basic features of the optimizer
  • avoid common SQL mistakes
  • recognize optimizer decisions in a given scenario

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.