Oracle Database 11g: Using SQL to Query Your Database
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 ...
Oracle Database 11g: Using Subqueries and Regular Expressions
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
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.
Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code
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.
Oracle Database 11g: Virtual Private Database
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 ...
Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
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.
Oracle Database 12c - Administration: Backup, Recover, and Move Data
Preparing for and performing data recovery and completing database backups are the responsibilities of a DBA. This ensures that the database is available for users when they require it. DBAs also ...
Oracle Database 12c - Administration: Data Concurrency and Auditing(New)
Oracle Database 12c is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented ...
Oracle Database 12c - Administration: Database Architecture and Management Tools
To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database ...
Oracle Database 12c - Administration: Maintenance and Performance Tuning
General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database ...