Overview/Description To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions. 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 Expected Duration (hours) 2.3 Lesson ObjectivesOracle Database 11g: Subprograms, Packages...

Overview/Description To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings. 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) 1.8 Lesson ObjectivesOracle Database 11g: Subqueries and Regular Expressions identify the steps for writing multiple-column and scalar subqueries. recognize the steps for solving problems by using...

Overview/Description To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features. Target Audience Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators. Prerequisites Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I Expected Duration (hours) 2.2 Lesson ObjectivesOracle Database 11g:...

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...