The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.
From an examination of single table operations to the complexities of accessing multiple tables using joins or subqueries, this course provides a thorough introduction to interactive SQL. This course also introduces the student to basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. Coding examples and workshops serve to reinforce the material presented in class.
This course teaches students the aspects of Oracle 11g RAC administration. Students will begin with gaining a solid foundation in the Oracle Clusterware and the RAC architecture. Students will review the RAC setup and installation and will learn how to configure both the Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important detailed topics include failover, flashback, troubleshooting, tuning, and backup and recovery. Students will also learn and get experience with the Automatic Storage Management feature.
Try Oracle 12c’s new features for SQL and PL/SQL and their related features here first. Through hands-on exercises, Oracle Developers and End Users can find out which features might provide the most benefits and learn how to properly implement and take advantage of them.
The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers.
This course is intended to provide experienced Oracle developers with the advanced SQL skills needed to effectively design and code complex queries and applications required to solve enterprise business problems. Coding examples and workshops serve to reinforce the material presented in class.
Oracle Application Express Release 4.1 further streamlines the development of database-centric Web applications. In this course, you'll learn to rapidly develop a Web application and then deploy using Oracle Application Express.
In this intensive course, you'll learn the concepts and functions that are critical to the System Administrator role. This includes managing security, managing concurrent processing, monitoring your system using Oracle Applications Manager, SOA and web services for system administration, and other related topics.
This course gives the Oracle database administrator (DBA) a firm foundation in Oracle backup and recovery operations. It addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations. This course includes interactive workshops that provide participants with the opportunity to walk through real-world backup and recovery case studies.
The overall objective of this course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. This 5-day course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.
In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues.
This course provides students with the skills needed to administer and maintain an Oracle database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery. The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create an awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also examined to provide access to additional information about a database and instance.
In this course students will clearly define the various methodologies one can use to tune an Oracle Database. The course covers the various components of an Oracle Database where potential performance bottlenecks could occur and how to monitor and tune them.
This Oracle Database: Introduction to SQL training teaches you how to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Expert Oracle University instructors will help you explore how to control privileges at the object and system level.
Approval Framework is delivered as part of Enterprise Components in PeopleSoft Applications being available across multiple product lines. Pre-defined approval processes are provided within each product line. In this course, students will be taught how to configure the approval routings to match the organizational criteria and hierarchy of their own companies. This course is designed with examples from PeopleSoft HCM 9.2 DEMO on a PeopleTools 8.54 toolset.
This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMS_STATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes, and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures, and waits due to locks and latches are presented.
The Workflow course provides the essential skills necessary to develop custom workflow for all PeopleSoft applications using standard development tools such as Appplication Designer and Query. Developers will learn the components of workflow including Roles, Routings, and Navigator Maps, which will allow them to design and enhance existing components to trigger worklist and email routings. Participants will also learn how to set up approval workflow applications using the existing Virtual Router and Virtual Approver functions as well as the Administrative tools used to monitor and debug workflow-enabled applications.
sdjfsdkl fjf fsd fkhsd fhsdfsdhf
This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMS_PROFILER, DBMS_TRACE, DBMS_HPROF, DBMS_WARNING and DBMS_PARALLEL_EXECUTE. Oracle versions 11g and 12c are covered.
This Enterprise Manager Cloud Control 12c training is a foundation course. Expert instructors will help you explore the core functionality of Oracle Enterprise Manager Cloud Control 12c through interactive instruction and hands-on exercises.