Overview/Description To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Using Triggers and the PL/SQL Compiler identify the steps for creating and using database triggers....

Overview/Description A Virtual Private Database (VPD) uses fine-grained access control (FGAC) to limit row and column access and an application context to provide the information that is used to set the policy predicates. This course describes VPD, how to implement VPD, and group policies. It also explores how FGAC is used with VPD, as well as tools, policies, and policy types. Target Audience Database administrators, security administrators, security compliance auditors, security compliance professionals Prerequisites The learner is assumed to have working experience with Oracle Database 11g...

Overview/Description This course introduces the Human Workflow task component and its functionality. It also introduces you to Oracle Business Rules and its features. Target Audience Business Analysts, Sales Consultants, Technical Consultants, SOA Architects, Application Developers, and J2EE Developers. Expected Duration (hours) 1.5 Lesson ObjectivesOracle SOA Suite 11g: Human Task and Business Rules Components identify the features of a Human Workflow task describe a workflow as a service create a Human Task component in an SOA composite use a Worklist application identify the need for...

Overview/Description This course introduces you to the Mediator component and its routing functionality. You will also be introduced to process orchestration concepts and using the BPEL component. Target Audience Business Analysts, Sales Consultants, Technical Consultants, SOA Architects, Application Developers, and J2EE Developers Expected Duration (hours) 2.0 Lesson ObjectivesOracle SOA Suite 11g: Mediator and BPEL Components identify the features of the Mediator component describe the Event Delivery Network create an Oracle Mediator component identify the features of Mediator routing rules...