- #Oracle database training how to#
- #Oracle database training install#
- #Oracle database training update#
- #Oracle database training upgrade#
Materialized Views and Query Rewrite Enhancements. Create multiple indexes on the same set of columns. Run the duplicate operation with the NOOPEN option. Restore and recover datafiles across the network. Query the data dictionary to obtain information on masking policies. Understanding the masking of statements containing subqueries. Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values. Use the mandatory INHERIT PRIVILEGES privilege to execute the invoker's rights procedure. Create, start and stop privilege captures. Grant the CAPTURE_ADMIN role to enable management of privilege captures. Implement the separation of duties for Database Administration tasks. Configure the Unified Audit Trail to set a tolerance level for lost of audit records. Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles. Create a tablespace for the Unified Audit Trail. Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause. Use predicate on ORA_ARCHIVE_STATE column. Set the ROW ARCHIVAL VISIBILITY for session level visibility control. Use the ROW ARCHIVAL clause to enable row lifecycle state for applications. Online Datafile Move and Automatic Data Optimization Recover a CDB from the loss of redo log files, control files and undo datafile loss. Manage Backup, Recovery and Flashback of a CDB and PDB Manage system and object privileges to common and local grantees. Manage common and local schemas and users in the Root and PDBs. Manage Common and Local Users, Roles And Privileges Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes. Online rename and relocation of an active datafile. Create permanent tablespaces in the root and PDBs. Open and close a PDB Using SQL*Plus and EM. Manage a Container Database and Pluggable Databases Clone a PDB into the same CDB using DB links. Administer the database using Enterprise Manager and SQL*Plus. Examine the structure of a CDB using Enterprise Manager and the CDB_xxx Views. Create and configure a CDB using Enterprise Manager. Import data using a Data Pump network linkĬonfigure and Create a Container Database and Pluggable Databases. #Oracle database training upgrade#
Upgrade a database with the Database Upgrade Assistant (DBUA). Perform an Upgrade to Oracle Database 12c #Oracle database training install#
Backup and Install the Oracle Database 12c software. Methods used to perform upgrade and migrate data. Preparation for Upgrade To Oracle Database 12c Set the NLS_LANG initialization parameter. Select a character set for the database. Select a database type based on workload. The structure of a Pluggable Database (PDB)Ĭreate a Database with the Database Configuration Assistant. The root container and Pluggable Database containers. The benefits of Multitenant Architecture. An overview of a Container Database (CDB). Overview of the Oracle database architecture. Enterprise Manager Cloud Control Home Page and Express home page. The following subjects will be taught during this course: Oracle Database 12c R2: New Features for 12c R1 Administrators Ed 1 Course Outline The examinations are not included as a part of this course and will need to be purchased separately via Pearson Vue Show more Other vital skills that delegates will learn include performing flashback operations, creating and using external tables as well as controlling user access to database objects. #Oracle database training how to#
The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts.Īfter successfully completing this certification, delegates will be able to learn how to create Oracle SQL statements to query database tables, use standard aggregate functions and related SELECT statement clauses, Implement extended SQL functions and many other useful skills.
#Oracle database training update#
Who should attend this Oracle Training Course?Īnyone who needs to use and understand Oracle SQL to query and update data in an Oracle database There are no formal pre-requisites for the Oracle SQL Fundamentals course, although an understanding of databases and exposure to information technology would be useful.
Session 22: Manage objects with the data dictionary. Session 20: Date, time and timezone support. Session 15: Retrieve data using subqueries. Session 14: Managing sequences and synonyms. Session 8: Conversion and miscellaneous. Session 7: Numeric character and date functions. Session 4: Retrieving data with the select statement. Session 1: Relational database concepts. The following sessions are taught during this Oracle course:
0 kommentar(er)
