1z0-082: Oracle Database Administration I
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