Overview/Description Transparent Data Encryption (TDE) is available with Oracle Advanced Security (ASO) and provides easy-to-use protection for your data without requiring changes to your applications. This course demonstrates how to set up the database master encryption key and implement TDE. It also explores how to encrypt column and tablespace data. Using Recovery Manager (RMAN)-encrypted backups, Oracle Secure Backup (OSB), and Data Pump Export encryption are also covered. Target Audience Database administrators, security administrators, security compliance auditors, security compliance...

Overview/Description To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters. 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) 1.7 Lesson ObjectivesOracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors recognize the steps for creating user-defined PL/SQL records...

Overview/Description To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI) Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms recognize the steps for...

Overview/Description To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables. 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 Exceptions, Subprograms, JDeveloper, and REF Cursors identify the steps for trapping non-predefined exceptions...