Overview/Description identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering. Target Audience Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g Prerequisites The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role Expected Duration (hours...

Overview/Description To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules. Target Audience Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants Prerequisites The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths. Expected Duration (hours) 1.9...

Overview/Description To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information. Target Audience Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators. Prerequisites Familiarity with data processing concepts and techniques Expected Duration (hours) 2.2 Lesson ObjectivesOracle Database 11g: Querying a Database with SQL identify the functions, capabilities, and...

Overview/Description Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance by tuning your RAC system the same as you would with a single-instance system. The same tuning tools are available for RAC as would be for a single-instance system. This course explains instance recovery in RAC,...