課程名稱：OCA: Database 12c Administrator Certified Associate 認證課程
- 簡稱：OCA Database 12c Training Course |
1Z0-071 Oracle Database SQL (15 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 12c (Windows)
2.2 Computer (Virtual Machines) Requirement
2.3 Database Installation using Oracle Universal Installer on Windows Server
2.4 Database Installation using Oracle Universal Installer on Oracle Enterprise Linux Server
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-062 Oracle Database 12c: Installation and Administration (27 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 Configuring EM Express for new instance
3.3 Managing the Oracle Listener
3.4 Database Startup and Shutdown
3.5 Set Database Initialization Parameters
3.6 Use the Alert Log and Trace Files
3.7 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 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 About Database Schema
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 Traditional Database Auditing
8. Unified Auditing
8.1 Introduction to Oracle Database 12c Unified Auditing
8.2 Implementing Mixed Auditing Mode
8.3 Implementing Unified Auditing
8.4 Creating Unified Audit Policy for Datapump example
8.5 Auditing RMAN
8.6 Cleaning up Audit Data
9. Real-Time Database Operation Monitoring
9.1 Monitoring in 11g vs 12c
9.2 Definition of Database Operation
9.3 Control_Management_Pack_Access
9.4 Using Database Operation Monitoring
9.5 Emergency Monitoring and Real-Time ADDM
9.6 End-To-End Application Tracing
10. Managing Undo Data
10.1 Purpose of Undo Data
10.2 Compatibility of Undo Data
10.3 Understanding How Transactions Generate Undo
10.4 Work with Transactions and Flashback query
10.5 Managing Undo
10.6 Computing the Minimum Undo Tablespace Size Using the Undo Advisor
11. Backup and Recovery Concepts
11.1 Introduction
11.2 Understanding and Configuring Recovery Components
11.3 Understanding Checkpoints
11.4 Redo Log Files
11.5 The Fast Recovery Area
11.6 Database Backup and Recovery Plan
11.7 Recovery Manager
12. Performing Database Backup and Disaster Recovery
12.1 Configuring RMAN for backup
12.2 Performing Disaster Recovery using Data Recover Advisor
12.3 Scheduling Oracle Suggested Backup plan
12.4 Performing Point-in-time recovery of database
13. Multitenant Database Architecture
13.1 Introduction to Multitenant Database Architecture
13.2 More about Multitenant Container Database
13.3 The Root Container, Seed Container and Pluggable Container
13.4 Instance and Storage Organization of Containers
13.5 Types of Containers during CDB and PDB initialization
14. Configuring and Managing Multitenant Databases
14.1 Creating a Container Database (CDB)
14.2 Creating and Configuration a PDB
14.3 Status and Open Mode of a Pluggable Database
14.4 Unplugging and Plugging a Pluggable Databases
14.5 Cloning a Pluggable Database from another Pluggable Database
14.6 Plugging a Normal 12c Non-CDB into a CDB
15. RMAN Backup and Recovery for Multitenant Architecture
15.1 Backup and Recover PDBs and CDB
15.2 Restoring a Tablespace in a Pluggable Database
15.3 Recovering Temporary Tablespace on CDB or PDBs
15.4 Recovering SYSAUX tablespace of the Root Container
15.5 Instance Recovery of lost Control Files
15.6 More about Point In Time Recovery (PITR) of PDB tablespaces
16. Managing Users, Roles and Privileges for Multitenant Architecture
16.1 Local Users and Common Users
16.2 Local Roles and Common Roles
16.3 Creating Local User in a PDB
16.4 Creating Common Users
16.5 Managing Privileges in a Multitenant Architecture
16.6 Managing Roles in a Multitenant Architecture
|
繳付學費，過程簡便！
