目標:介紹docker與Oracle安裝、架構、管理、P/L SQL、備份與還原。
用書:Oracle Database 11g Administrator Certificated Associate Study Guide, Oracle
大綱:
Part I. Oracle Database 11g: SQL Fundamentals I
- Ch1. Introduction SQL
- Ch2. Using Single-Row Functions
- Ch3. Using Group Functions
- Ch4. Using Joins and Subqueries
- Ch5. Manipulating Data
- Ch6. Creating Tables and Constraints
- Ch7. Creating Schema Objects
Part II. Oracle Database 11g: Administration I
- Ch8. Introducing Oracle Database 11g Components and Architecture
- Ch9. Creating an Oracle 11g Database
- Ch10. Allocating Database Storage and Creating Schema Objects
- Ch11. Understanding Network Architecture
- Ch12. Implementing Security and Auditing
- Ch13. Managing Data Undo
- Ch14. Maintaining the Database and Managing Performance
- Ch15. Implementing Database Backups
- Ch16. Recovering the Database
Oracle證照考試協助