مفاهیم پایه مدیریت پایگاه داده اوراکل(work shop I)
Oracle Workshop I
Oracle Database Administrator Fundamental
Managing Data and Concurrency
( ) Monitor and resolve locking confilicts
Managing Undo Data
( ) Overview of Undo
( ) Transactions and undo data
( ) Managing undo
Implementing Oracle Database Security
( ) Database Security and Principle of Least
Privilege
( ) Work with Standard Database Auditing
Database Maintenance
( ) Use and manage optimizer statistics
( ) Use and manage Automatic Workload Repository(AWR)
( ) Use advisory framework
( ) Manage Alerts and Thresholds
Performance Management
( ) Use Automatic Memory Management
( ) Use Memory Advisors
( ) Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements
( ) Use the Enterprise Manager Support
Workbench
( ) Managing Patches
Exploring the Oracle Database Architecture
( ) Explain the Memory Structures
( ) Describe the Process Structures
Overview Of Storage Structures ( )
Preparing the Database Environment
( ) Identify the tools For Administering an Oracle Database
( ) Plan an Oracle Database installation
( ) Install the Oracle software by using Oracle Universal Installer(OUI)
Creating an Oracle Database
( ) Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance
( ) Setting database initialization parameters
( ) Describe the stages of database startup and shutdown
( ) Using alert log and trace files
( ) Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment
( ) Configure and Manage the Oracle Network
( ) Using the Oracle Shared Server architecture
Managing Database Storage Structures
( ) Overview Of tablespace and datafiles
( ) Create and manage tablespace
( ) Space management in tablespace
Administering User Security
( ) Create and manage Database user accounts
( ) Grant and revoke privileges
( ) Create and manage roles
( ) Create and manage profiles
PL/SQL Fundamentals
Introduction to PL/SQL
PL/SQL Overview
Benefits of PL/SQL Subprograms
Overview of the Types of PL/SQL blocks
Creating and Executing a Simple Anonymous Block
Generating Output from a PL/SQL Block
Declaring PL/SQL Identifiers
Different Types of Identifiers in a PL/SQL subprogram
Using the Declarative Section to Define Identifiers
Storing Data in Variables
Scalar Data Types
% TYPE Attribute
Bind Variables
Using Sequences in PL/SQL Expression
Writing Executable Statements
Describing Basic PL/SQL Block Syntax Guidelines
Commenting Code
SQL Functions in PL/SQL
Data Type Conversion
Nested Blocks
Operators in PL/SQL
Interacting with the Oracle Server
Including SELECT Statements in PL/SQL to Retrieve Data
Manipulating Data in the Server Using PL/SQL
The SQL Cursor concept
Using SQL Cursor Attributes to Obtain Feedback on DML
Saving and Discarding Transactions
Writing Control Structures
Conditional processing Using IF Statements
Conditional processing Using CASE Statements
Simple Loop Statement
While Loop Statement
For Loop Statement
The Continue Statement
Working with Composite Data Types
Using PL/SQL Records
Using the %ROWTYPE Attribute
Inserting and Updating with PL/SQL Records
INDEX BY Tables
INDEX BY Tables Methods
INDEX BY Tables of Records
Using Explicit Cursors
Understanding Explicit Cursors
Declaring the Cursor
Opening the Cursor
Fetching data from the Cursor
Closing the Cursor
Cursor FOR loop
Cursor Attributes Explicit
FOR UPDATE Clause and WHERE CURRENT Clause
Handling Exceptions
Understanding Exceptions
Handling Exceptions with PL/SQL
Trapping Predefined Oracle Server Errors
Trapping Non-Predefined Oracle Server Errors
Trapping User-Defined Exceptions
Propagate Exceptions
RAISE_APPLICATION_ERROR Procedure
Creating Stored Procedures and Functions
Understanding Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Create a Simple Procedure
Create a Simple Procedure with IN parameter
Create a Simple Function
Execute a Simple Procedure
Execute a Simple Function