課程名稱：OCA: Database 11g Administrator Certified Associate 認證課程
- 簡稱：OCA Training Course |
1Z0-051 Oracle Database 11g: SQL Fundamentals I (18 hours)
1. Oracle Server Technologies and Relational Paradigm
1.1 Prerequisite knowledge to Oracle Servers
1.2 The Oracle Server Architecture
1.3 The Oracle Application Server (無須強記，理解便可)
1.4 The Oracle Enterprise Manager
2. Deploying Oracle Database Server
2.1 Requirements for Oracle Database 11g (Windows)
2.2 Computer (Virtual Machines) Requirement
2.3 Database Installation using Oracle Universal Installer on Windows
2.4 Database Installation using Oracle Universal Installer on Linux
3. Oracle Database Management Consoles
3.1 Tools available to manage an Oracle Database Server
3.2 SQL*Plus
3.3 SQL Developer
3.4 Enterprise Manager: Database Control
4. Relational Data
4.1 Normalization
5. Demonstration Schema
5.1 Addressing the Demonstration Schema
5.2 Definition of a Database Schema
5.3 The HR and OE Schema
5.4 Enabling the HR and OE user
6. Data Retrieval Using the SQL SELECT Statement
6.1 The DESCRIBE table command
6.2 Describing the HR schema
6.3 Capabilities of SELECT Statement
6.4 Executing the SELECT Statement
7. Restricting and Sorting Data
7.1 Introduction
7.2 Limit the Rows Retrieved by a Query
7.3 Sort the Rows Retrieved by a Query
7.4 Ampersand Situation
8. Single Row Functions
8.1 Introduction to Single Row Functions
8.2 Describing Various Types of Functions Available in SQL
8.3 Types of Functions
8.4 Working with Dates
9. Using Conversion Functions and Conditional Expressions
9.1 Introduction
9.2 Describing Various Types of Conversion Functions Available in SQL
9.3 Using TO_CHAR, TO_NUMBER and TO_DATE
9.4 Apply Conditional Expressions in a SELECT Statement
10. Reporting Aggregated Data Using Group Functions
10.1 Introduction
10.2 Describe the Group Functions
10.3 Identify the Available Group Functions
10.4 Restrictions of using Nested Group Functions
10.5 Group Data Using the GROUP BY Clause
10.6 Include or Exclude Grouped Rows Using the HAVING Clause
11. Displaying Data From Multiple Tables
11.1 Introduction
11.2 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
11.3 Types of Joins
11.4 Natural Joins (自然連接)
11.5 Oracle Join Syntax
11.6 Joining Tables Using SQL:1999 Syntax
11.7 Qualifying Ambiguous Column Names (Optional Knowledge)
11.8 N-Way Joins and Additional Join Conditions
11.9 Nonequijoins (Optional Knowledge)
11.10 Join a Table to Itself Using a Self-Join (Optional Knowledge)
11.11 View Data That Does Not Meet a Join Condition by Using Outer Joins
11.12 Left Outer Join
11.12 Right Outer Join
11.13 Full Outer Join
11.14 Cross Join
12. Using Sub Queries to Solve Problems
12.1 Introduction
12.2 Define Subqueries
12.3 Describe the Types of Problem that Subqueries Can Solve
12.4 List the Types of Subqueries
12.5 Write Single-Row and Multiple-Row Subqueries
13. Using the Set Operator
13.1 Introduction
13.2 Describe the Set Operators
13.3 Set and Venn Diagram (Optional Knowledge)
13.4 Trying the Set Operators
13.5 Use a Set Operator to Combine Multiple Queries into a Single Query
13.6 General Principals of using Set Operators (Optional Knowledge)
13.7 More Complex Examples
14. Creating Schema Objects
14.1 Introduction
14.2 Create Simple and Complex Views
14.3 Reasons of using views
14.4 Simple and Complex Views
14.5 CREATE VIEW
14.6 Private and Public Synonyms
14.7 Sequences
1Z0-052 Oracle Database 11g: Administration I (18 hours)
1. Exploring the Oracle Database Architecture
1.1 Introduction
1.2 Description of a Single-Instance Architecture
1.3 Description of a Distributed System Architectures (Optional Knowledge)
1.4 Description of Memory Structures
1.5 Investigating the Memory Structures of the Instance
1.6 Description of Oracle Background Process Structures
1.7 Investigating the Processes Running in your instance
1.8 Summarize the Storage Structures
1.9 Logical Database Structures
1.10 Investigating the Storage Structures in your database
2. Creating an Oracle Database
2.1 Various tasks about Creating an Oracle Database
2.2 Using the Database Configuration Assistant (DBCA) to Create a Database
2.3 Scripts and Other Files Created by the DBCA
3. Managing the Oracle Instance
3.1 Introduction
3.2 Stopping and Starting Database Control
3.2 Connecting to Database Control
3.4 Managing the Oracle Listener
3.5 Starting SQL*Plus
3.6 Database Startup and Shutdown
3.7 Set Database Initialization Parameters
3.9 Use the Alert Log and Trace Files
3.10 Using Data Dictionary and Dynamic Performance Views
4. Configuring the Oracle Network Environment
4.1 Introduction
4.2 Oracle Net and Communication Protocols
4.3 Creating a Listener
4.4 Techniques for Name Resolution
4.5 Database Registration
4.6 Reconfiguring Enterprise Manager: Database Control
4.7 Database Link
5. Managing Database Storage Structures
5.1 Introduction
5.2 Identifying Oracle Storage Structures
5.3 Managing Tablespaces
5.4 The Oracle Data Block format
5.5 Managing Datafiles
6. Administering User Security
6.1 Database User Account
6.2 Choosing Authentication Methods
6.3 Choosing a Default Tablespace
6.4 Choosing a Temporary Tablespace
6.5 Choosing a Profile for a User
6.6 Creating a database user
6.7 Creating a database user
6.8 Granting and Revoking Privileges
6.9 Roles
6.10 Controlling Access to Applications by Secured Application Role
6.11 Quotas
6.12 Data Dictionary Views (Optional Knowledge)
7. Implementing Oracle Database Security
7.1 Introduction
7.2 Database Security and Principle of Least Privilege
7.3 PUBLIC privileges
7.4 Security-Critical Instance Parameters
7.5 Working with Database Auditing
8. Managing Undo Data
8.1 Purpose of Undo Data
8.2 Compatibility of Undo Data
8.3 Understanding How Transactions Generate Undo
8.4 Work with Transactions and Flashback query
8.5 Managing Undo
8.6 Computing the Minimum Undo Tablespace Size Using the Undo Advisor
9. Backup and Recovery Concepts
9.1 Introduction
9.2 Understanding and Configuring Recovery Components
9.3 Understanding Checkpoints
9.4 Redo Log Files
9.5 The Flash Recovery Area
9.6 Database Backup and Recovery Plan
9.7 Recovery Manager
10. Performing Database Backup and Disaster Recovery
10.1 Configuring RMAN for backup
10.2 Performing Disaster Recovery using Data Recover Advisor
10.3 Scheduling Oracle Suggested Backup plan
10.4 Performing Point-in-time recovery of database
|
