Understanding Oracle Database Architecture - Oracle Database: Administration Workshop

• Understanding Oracle Database Instance Configurations
• Understanding Oracle Database Memory and Process Structures
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture

Managing Database Instances - Oracle Database: Administration Workshop

• Starting Up Oracle Database Instances
• Using Data Dictionary Views
• Shutting Down Oracle Database Instances
• Using Dynamic Performance Views
• Using the Automatic Diagnostic Repository (ADR)
• Using the Alert Log and Trace Files
• Managing Initialization Parameter Files

Managing Users, Roles and Privileges - Oracle Database: Administration Workshop

• Assigning Quotas to Users
• Applying the Principal of Least Privilege
• Creating and Assigning Profiles
• Administering User Authentication Methods
• Managing Oracle Database Users, Privileges, and Roles

Managing Storage - Oracle Database: Administration Workshop

• Managing Resumable Space Allocation
• Shrinking Segments
• Deferring Segment Creation
• Using Space-Saving Features
• Deploying Oracle Database Space Management Features
• Managing Different Types of Segments
• Using Table and Row Compression
• Understanding Block Space Management

Moving Data - Oracle Database: Administration Workshop

• Using External Tables
• Using Oracle Data Pump
• Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop

• Using the Database Configuration Assistant (DBCA)
• Using Oracle Enterprise Manager Cloud Control
• Using racle enterprise Manager Database Express
• Using SQL Developer
• Using SQL Plus

Configuring Oracle Net Services - Oracle Database: Administration Workshop

• Using Oracle Net Services Administration Tools
• Configuring Communication Between Database Instances
• Configuring the Oracle Net Listener
• Connecting to an Oracle Database Instance
• Comparing Dedicated and Shared Server Configurations
• Administering Naming Methods

Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop

• Viewing Tablespace Information
• Creating, Altering and Dropping Tablespaces
• Managing Table Data Storage
• Implementing Oracle Managed Files
• Moving and Renaming Online Data Files

Managing Undo - Oracle Database: Administration Workshop

• Understanding Transactions and Undo Data
• Storing Undo Information
• Configuring Undo Rentention
• Comparing Undo Data and Redo Data
• Understanding Temporary Undo

Restricting and Sorting Data - Oracle Database: Introduction to SQL

• Applying Rules of precedence for operators in an expression
• Limiting Rows Returned in a SQL Statement
• Using Substitution Variables
• Using the DEFINE and VERIFY commands

Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL

• Applying the NVL, NULLIF, and COALESCE functions to data
• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions

Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL

• Using Self-joins
• Using Various Types of Joins
• Using Non equijoins
• Using OUTER joins

Using SET Operators - Oracle Database: Introduction to SQL

• Matching the SELECT statements
• Using the ORDER BY clause in set operations
• Using The INTERSECT operator
• Using The MINUS operator
• Using The UNION and UNION ALL operators

Understanding Data Definition Language - Oracle Database: Introduction to SQL

• Using Data Definition Language

Managing Views - Oracle Database: Introduction to SQL

• Managing Views

Managing Data in Different Time Zones - Oracle Database: Introduction to SQL

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types

Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL

• Using Column aliases
• Using The DESCRIBE command
• Using The SQL SELECT statement
• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL

• Manipulating strings with character functions in SQL SELECT and WHERE clauses
• Performing arithmetic with date data
• Manipulating numbers with the ROUND, TRUNC and MOD functions
• Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL

• Restricting Group Results
• Creating Groups of Data
• Using Group Functions

Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL

• Using Single Row Subqueries
• Using Multiple Row Subqueries

Managing Tables using DML statements - Oracle Database: Introduction to SQL

• Managing Database Transactions
• Using Data Manipulation Language
• Controlling transactions

Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL

• Managing Indexes
• Managing Synonyms
• Managing Sequences

Managing Schema Objects - Oracle Database: Introduction to SQL

• Creating and using temporary tables
• Managing constraints

Kinh nghiệm đó là nên làm nhuần nhuyễn đề trong khoảng 2 tuần, mỗi ngày tầm 2 tiếng, search thêm các lỗi hay gặp và hiểu hơn về Oracle Database.
Trước ngày thi có thể nhắn tin với mình để trao đổi vài tips để thi nhé :D -Fb: https://www.facebook.com/beatcomputer.01/
Chúc bạn thành công.


English

Dump Oracle Database Professional Certification Exam - Exam to pass Oracle 1Z0-082 in 2024.
 

Understanding Oracle Database Architecture - Oracle Database: Administration Workshop

• Understanding Oracle Database Instance Configurations
• Understanding Oracle Database Memory and Process Structures
• Understanding Logical and Physical Database Structures
• Understanding Oracle Database Server Architecture

Managing Database Instances - Oracle Database: Administration Workshop

• Starting Up Oracle Database Instances
• Using Data Dictionary Views
• Shutting Down Oracle Database Instances
• Using Dynamic Performance Views
• Using the Automatic Diagnostic Repository (ADR)
• Using the Alert Log and Trace Files
• Managing Initialization Parameter Files

Managing Users, Roles and Privileges - Oracle Database: Administration Workshop

• Assigning Quotas to Users
• Applying the Principal of Least Privilege
• Creating and Assigning Profiles
• Administering User Authentication Methods
• Managing Oracle Database Users, Privileges, and Roles

Managing Storage - Oracle Database: Administration Workshop

• Managing Resumable Space Allocation
• Shrinking Segments
• Deferring Segment Creation
• Using Space-Saving Features
• Deploying Oracle Database Space Management Features
• Managing Different Types of Segments
• Using Table and Row Compression
• Understanding Block Space Management

Moving Data - Oracle Database: Administration Workshop

• Using External Tables
• Using Oracle Data Pump
• Using SQL*Loader

Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop

• Using the Database Configuration Assistant (DBCA)
• Using Oracle Enterprise Manager Cloud Control
• Using racle enterprise Manager Database Express
• Using SQL Developer
• Using SQL Plus

Configuring Oracle Net Services - Oracle Database: Administration Workshop

• Using Oracle Net Services Administration Tools
• Configuring Communication Between Database Instances
• Configuring the Oracle Net Listener
• Connecting to an Oracle Database Instance
• Comparing Dedicated and Shared Server Configurations
• Administering Naming Methods

Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop

• Viewing Tablespace Information
• Creating, Altering and Dropping Tablespaces
• Managing Table Data Storage
• Implementing Oracle Managed Files
• Moving and Renaming Online Data Files

Managing Undo - Oracle Database: Administration Workshop

• Understanding Transactions and Undo Data
• Storing Undo Information
• Configuring Undo Rentention
• Comparing Undo Data and Redo Data
• Understanding Temporary Undo

Restricting and Sorting Data - Oracle Database: Introduction to SQL

• Applying Rules of precedence for operators in an expression
• Limiting Rows Returned in a SQL Statement
• Using Substitution Variables
• Using the DEFINE and VERIFY commands

Using Conversion Functions and Conditional Expressions - Oracle Database: Introduction to SQL

• Applying the NVL, NULLIF, and COALESCE functions to data
• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions

Displaying Data from Multiple Tables Using Joins - Oracle Database: Introduction to SQL

• Using Self-joins
• Using Various Types of Joins
• Using Non equijoins
• Using OUTER joins

Using SET Operators - Oracle Database: Introduction to SQL

• Matching the SELECT statements
• Using the ORDER BY clause in set operations
• Using The INTERSECT operator
• Using The MINUS operator
• Using The UNION and UNION ALL operators

Understanding Data Definition Language - Oracle Database: Introduction to SQL

• Using Data Definition Language

Managing Views - Oracle Database: Introduction to SQL

• Managing Views

Managing Data in Different Time Zones - Oracle Database: Introduction to SQL

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types

Retrieving Data using the SQL SELECT Statement - Oracle Database: Introduction to SQL

• Using Column aliases
• Using The DESCRIBE command
• Using The SQL SELECT statement
• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Using Arithmetic expressions and NULL values in the SELECT statement

Using Single-Row Functions to Customize Output - Oracle Database: Introduction to SQL

• Manipulating strings with character functions in SQL SELECT and WHERE clauses
• Performing arithmetic with date data
• Manipulating numbers with the ROUND, TRUNC and MOD functions
• Manipulating dates with the date function

Reporting Aggregated Data Using Group Functions - Oracle Database: Introduction to SQL

• Restricting Group Results
• Creating Groups of Data
• Using Group Functions

Using Subqueries to Solve Queries - Oracle Database: Introduction to SQL

• Using Single Row Subqueries
• Using Multiple Row Subqueries

Managing Tables using DML statements - Oracle Database: Introduction to SQL

• Managing Database Transactions
• Using Data Manipulation Language
• Controlling transactions

Managing Sequences, Synonyms, Indexes - Oracle Database: Introduction to SQL

• Managing Indexes
• Managing Synonyms
• Managing Sequences

Managing Schema Objects - Oracle Database: Introduction to SQL

• Creating and using temporary tables
• Managing constraints

Experience is to do the exam in about 2 weeks, about 2 hours a day, look for more common errors and understand more about Oracle Database.
Before exam start, you can message me to exchange some tips for the exam :D -Fb: https://www.facebook.com/beatcomputer.01/
Good luck.