Oracle Database 19C OCP認證* | |
課程長度: | 12天周末班/10天脫產班 |
培訓班型: | 公開課 |
培訓講師: | 博學高級講師 |
培訓地點: | 杭州市文三路252號偉星大廈7樓A1 博學國際教育培訓中心 |
環境要求: | 人手一臺電腦、投影儀、接線板 |
培訓形式: | 實例講授,現場演、練、及時溝通 |
培訓資料: | 電子教材 |
課程內容 | |
課程一 Oracle Database 19C: Fundamentals for Devs and SysAdmins(0.5)
課程二 Oracle Database 19C: SQL Workshop(1.5)
課程三 Oracle Database 19C: Administration Workshop(5天)
課程四 Oracle Database 19C: Backup and Recovery(5天)
Oracle Database 19C: Fundamentals for Devs and SysAdmins
1. Introduction
Introduction
Course Practice Environment: Security Credentials
2. Introducing the Oracle Database
Introducing the Oracle Database
3. Insalling Oracle Database and Creating a Database
Installing Oracle Database and Creating a Database
Practice 3-1: Installing the Oracle Database Software and Creating a Database
4. Using Enterprise Manager Database Express and SQL-based Management Tools
Using Enterprise Manager Database Express and SQL-based Management Tools
Practice 4-1: Using Enterprise Manager Database Express
Practice 4-2: Using SQL*Plus and SQL Developer
5. Configuring the Oracle Network Environment
Configuring the Oracle Network Environment
Practice 5-1: Using the Listener Control Utility
6. Managing the Database Instance
Managing the Database Instance
Practice 6-1: Using SQL Developer to Shut Down and Restart a Database
Practice 6-2: Viewing Initialization Parameters
7. Managing the Database Storage Structures
Managing the Database Storage Structures
Practice 7-1: Managing the Database Storage Structures
8. Administering Users and Security
Administering Users and Security
Practice 8-1: Creating the Flower Shop Owner User
Practice 8-2: Creating the Flower Shop Clerk Role and User
9. Managing Schema Objects
Managing Schema Objects
Practice 9-1: Creating Application Tables
Practice 9-2: Loading Data into the Tables
10. Performing Backup and Recovery
Performing Backup and Recovery
Practice 10-1: Configuring the Database for Backup and Recovery
Practice 10-2: Performing Backup Operations
Practice 10-3: Using the Database Flashback Features
11. Monitoring the Database and Using Advisors
Monitoring the Database and Using Advisors
Practice 11-1: Monitoring Database Performance
12. Managing the Software
Managing the Software
13. Oracle Database Cloud Service: Overview
Oracle Database Cloud Service: Overview
Oracle Database 19C: SQL Workshop
1. Introduction
Introduction
Entity Relationship Model
Practice 1-1: Introduction
2. Retrieving Data Using the SQL SELECt Statement
Retrieving Data Using the SQL SELECt Statement
Practice 2-1: Retrieving Data Using the SQL SELECT Statement
3. Restricting and Sorting Data
Restricting and Sorting Data
Practice 3-1: Restricting and Sorting Data
4. Using Single-Row Functions to Customize Output
Using Single-Row Functions to Customize Output
Number Functions
Practice 4-1: Using Single-Row Functions to Customize Output
5. Using Conversion Functions and Conditional expressions
Using Conversion Functions and Conditional expressions
General Functions
Practice 5-1: Using Conversion Functions and Conditional expressions
6. Reporting Aggregated Data Using the Group Functions
Reporting Aggregated Data Using the Group Functions
Practice 6-1: Reporting Aggregated Data by Using Group Functions
7. Displaying Data from Multiple Tables Using Joins
Displaying Data from Multiple Tables Using Joins
Practice 7-1: Displaying Data from Multiple Tables by Using Joins
8. Using Subqueries to Solve Queries
Using Subqueries to Solve Queries
Practice 8-1: Using Subqueries to Solve Queries
9. Using Set Operators
Using Set Operators
Practice 9-1: Using Set Operators
10. Managing Tables Using DML Statements in Oracle
Managing Tables Using DML Statements in Oracle
State of Data
Practice 10-1: Managing Tables by Using DML Statements
Practice 10-1: Managing Tables by Using DML Statemens....Cntd
11. Introduction to Data Definition Language in Oracle
Introduction to Data Definition Language in Oracle
FOREIGN KEY Constraint
Practice 11-1:1 Introduction to Data Definition Language
12. Introduction to Data Dictionary Views
Introduction to Data Dictionary Views
Before you Begin Practice 12: Using SQL Developer
Practice 12-1: Introduction to Data Dictionary Views
13. Creating Sequences, Synonyms, and Indexes
Creating Sequences, Synonyms, and Indexes
Sequence Information
Practice 13-1: Creating Sequences, Synonyms, and Indexes
14. Creating Views
Creating Views
Practice 14-1: Creating Views
15. Managing Schema Objects
Managing Schema Objects
DROp TABLE
Practice 15-1: Managing Schema Objects
Practice 15-1: Managing Schema Objects...Cntd
16. Retrieving Data by Using Subqueries
Retrieving Data by Using Subqueries
Practice 16-1: Retrieving Data by Using Subqueries
17. Manipulating Data by Using Subqueries
Manipulating Data by Using Subqueries
Practice 17-1: Manipulating Data by Using Subqueries
18. Controlling User Access
Controlling User Access
Practice 18-1: Controlling User Access
19. Manipulating Data Using Advanced Queries
Manipulating Data Using Advanced Queries
MERGE Statement
Practice 19-1: Manipulating Data
Practice 19-1: Manipulating Data...Cntd
20. Managing Data in Different Time Zones
Managing Data in Different Time Zones
Practice 20-1: Managing Data in Different Time Zones
21. Conclusion
Conclusion
Q&A Sessions
Oracle Database 19c: Administration Workshop
1. Introduction to Oracle Database
Database Server Architecture 8m
Course Practice Environment: Security Credentials 2m
2. Accessing an Oracle Database
Accessing an Oracle Database 18m
Demonstration: Usage of general DBCA Tools to Interact with Database 11m
3. Creating an Oracle Database by Using DBCA
Creating a Database Using DBCA 19m
Practice 3-1: Creating a New CDB (Part 01) 11m
Practice 3-1: Creating a New CDB (Part 02) 5m
4. Creating an Oracle Database by Using a SQL Command
Creating Database using SQL Command 9m
Practice 4-1: Creating a New CDB (Part 01) 8m
Practice 4-1: Creating a New CDB (Part 02) 14m
Practice 4-1: Creating a New CDB (Part 03) 6m
5. Starting Up and Shutting Down a Database Instance
Starting Up and Shutting Down a Database Instance 15m
Opening and Closing PDBs 12m
Practice 5-1: Shutting Down and Starting Up the Oracle Database 17m
6. Managing Database Instances
Managing the Database 24m
Practice 6-1: Investigating Initialization Parameter Files 11m
Practice 6-2: Viewing Initialization Parameters by Using SQL*Plus (Part 01) 13m
Practice 6-2: Viewing Initialization Parameters by Using SQL*Plus (Part 02) 20m
Practice 6-3: Modifying Initialization Parameters by Using SQL*Plus 22m
Practice 6-4: Viewing Diagnostic Information 15m
7. Oracle Net Service: Overview
Configuring and Administering Oracle Net Service 19m
Course Practice Environment: Security Credentials 3m
8. Configuring Naming Methods
Oracle Net Components 20m
Naming Method 19m
Practice 2-1: Configuring the Oracle Network to Access a Database (Part 01) 6m
Practice 2-1: Configuring the Oracle Network to Access a Database (Part 02) 9m
Practice 2-2: Creating a Net Service Name for a PDB 9m
9. Configuring and Administering the Listener
Configuring and Administering the Listener 18m
Practice 3-1: Exploring the Default Listener 17m
Practice 3-2: Creating a Second Listener 17m
Practice 3-3: Connecting to a Database Service Using the New Listener 3m
10. Configuring a Shared Server Architecture
Configuring a Shared Server Architecture 15m
Practice 4-1: Configuring Shared Server Mode 6m
Practice 4-2: Configuring Clients to Use a Shared Server 8m
11. Configuring Oracle Connection Manager for Multiplexing and Access Control
Connection Manager 15m
Practice 5-1: Installing Oracle Instant Client 10m
Practice 5-2: Configuring the cman.ora File 9m
Practice 5-3: Configuring the Database for Oracle Connection Manager 4m
Practice 5-4: Configuring Clients for Oracle Connection Manager 4m
Practice 5-5: Configuring the Oracle Database Server for Session Multiplexing 11m
12. Creating PDBs from Seed
Creating PDBs from Seed 17m
Provisioning New Pluggable Databases-(Continued) 19m
Practice 1-1: Creating a New PDB from the PDB Seed 12m
13. Using Other Techniques to Create PDBs
Using Other Techniques to Create PDBs 19m
Method of Creating and Migrating PDBs 9m
Practice 2-1: Cloning Remote PDBs in Hot Mode (Part 01) 6m
Practice 2-1 Cloning Remote PDBs in Hot Mode (Part 02) 22m
Practice 2-2: Relocating PDBs 26m
14. Managing PDBs
Managing PDBs 16m
Practice 3-1: Renaming a PDB 8m
Practice 3-2: Setting Parameter Values for PDBs 13m
15. Database Storage Overview
Database Storage Overview 20m
Purpose of the Default Tablespaces 20m
Storage of Data in Blocks 22m
Advantage of Deferred Segment Creation 12m
Course Practice Environment: Security Credentials 2m
16. Creating and Managing Tablespaces
Creating and Managing Tablespaces 18m
Viewing Tablespace Information 14m
Practice 2-1: Viewing Tablespace Information 20m
Practice 2-2: Creating a Tablespace (Part 01) 4m
Practice 2-2: Creating a Tablespace (Part 02) 9m
Practice 2-3: Managing Temporary and Permanent Tablespaces 24m
17. Improving Space Usage
Space Management Features 22m
Creating Global Temporary Tables 15m
Practice 3-1: Managing Space in Tablespaces (Part01) 16m
Practice 3-1: Managing Space in Tablespaces (Part02) 4m
Practice 3-1: Managing Space in Tablespaces (Part03) 8m
Practice 3-2: Using Compression 11m
Practice 3-3: Enabling the Resumable Space Allocation Feature (Part 01) 10m
Practice 3-3: Enabling the Resumable Space Allocation Feature (Part 02) 7m
18. Managing Undo Data
Managing the Undo 20m
Enabling Temporary Undo 15m
Practice 4-1: Managing Undo Tablespaces in a PDB 5m
19. Creating and Managing User Accounts
Creating and Managing User Accounts 17m
Creating Common Users in the CDB and PDBs 17m
Assigning Quotas 8m
Practice 1-1: Creating Common and Local Users 23m
Practice 1-2: Creating a Local User for an Application 5m
Practice 1-3: Exploring OS and Password File Authentication 9m
20. Configuring Privilege and Roles Authorization
Configuring Privilege and Roles Authorization 20m
Practice 2-1: Granting a Local Role (DBA) to PDBADMIN 8m
Practice 2-2: Using SQL *Developer to Create Local Roles 17m
21. Configuring User Resource Limits
Configuring User Resource Limits 16m
Practice 3-1: Using SQL*Developer to Create a Local Profile 13m
Practice 3-2: Using SQL*Developer to Create Local Users (Part 01) 22m
Practice 3-2: Using SQL*Developer to Create Local Users (Part 02) 1m
Practice 3-3: Configuring a Default Role for a User 6m
22. Implementing Oracle Database Auditing
Implementing Oracle Database Auditing 17m
Configuring Auditing 16m
Viewing Audit Policy Information 14m
Practice 4-1: Enabling Unified Auditing 7m
Practice 4-2: Creating Audit Users 4m
Practice 4-3: Creating an Audit Policy 12m
23. Introduction Loading and Transporting Data
Introduction Loading and Transporting Data 10m
Course Practice Environment: Security Credentials 2m
24. Loading Data
Loading Data 14m
Practice 2-1: Loading Data into a PDB from an External File 25m
25. Transporting Data
Transporting Data 18m
Using the RMAN Convert Command 22m
Practice 3-1: Moving Data from One PDB to Another PDB (Part 01) 18m
Practice 3-1: Moving Data from One PDB to Another PDB (Part 02) 11m
Practice 3-2: Transporting a Tablespace 16m
26. Using External Tables to Load and Transport Data
Using External Tables to load Transport Data 14m
External Table Demo 14m
Practice 4-1: Querying External Tables 27m
Practice 4-2: Unloading External Tables 9m
27. Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Overview 16m
Automated Maintenance Tasks: Components 12m
Course Practice Environment: Security Credentials 2m
28. Automated Maintenance Tasks: Managing Tasks and Windows
Configuring Automated Maintenance Tasks 18m
Practice 2-1: Enabling and Disabling Automated Maintenance Tasks 7m
Practice 2-2: Modifying the Duration of a Maintenance Window 7m
29. Database Monitoring and Performance Tuning Overview
Database Monitoring and Performance Tuning Overview 16m
30. Monitoring Database Performance
Understanding What Database Performance is Monitored 17m
31. Tuning Database Performance
Tuning Database Performance 14m
Demo: Navigating around Cloud Control, Using and Accessing information 22m
Demo: Navigating around Performance area in your Database 11m
32. Analyzing SQL and Optimizing Access Paths
Analyzing SQL and Optimizing Access Paths 19m
Adaptive Execution Plans 17m
Oracle Database 19c: Backup and Recovery
1. Backup and Recovery: Overview
Backup and Recovery: Overview 18m
Understanding Instance Recovery 20m
2. Backup and Recovery Configuration
Backup and Recovery Configuration 14m
Configuring Demo 2m
Control File Demo 5m
Adding a Redo file to Redo Group – Demo 6m
Enabling ARCHIVELOG mode in a Database – Demo 2m
Practice 2-1: Verifying that the Control File is Multiplexed 12m
Practice 2-2: Configuring the Size of the Fast Recovery Area 3m
Practice 2-3: Verifying that the Redo Log File is Multiplexed 15m
Practice 2-4: Configuring ARCHIVELOG Mode 3m
3. Using Recovery Manager (RMAN)
Using Recovery Manager 12m
Connection the RMAN and a Target Database Demo 3m
Using the sequel and RMAN Demo 1m
Managing the Setting RMAN Demo 3m
Practice 3-1: Configuring the Default Backup Destination 3m
Practice 3-2: Setting the Date and Time Format for RMAN 4m
Practice 3-3: Configuring RMAN Settings 4m
4. Backup Strategies
Backup Strategies 21m
5. Creating Database Backups
Creating Database Backups 13m
Fast Incremental Backup 9m
Syntex and Clause in RMAN Use for Backups Demo 4m
Creating Image Copies for Backups Demo 4m
Creating a Whole Backups Container or Noncontainer Database system Demo 2m
Creating a Partial PDP Backups Demo 4m
Maintaining the Block Change Tracking File Demo 3m
Backing up to Control Files to Trace File Demo 5m
Practice 2-1: Backing Up the Control File 12m
Practice 2-2: Verifying Automatic Backups of the Control File and SPFILE 3m
Practice 2-3: Creating a Whole Database Backup 13m
Practice 2-4: Creating Partial Database Backups 6m
Practice 2-5: Configuring Block Change Tracking 4m
Practice 2-6: Using Incremental Backups 14m
Practice 2-7: Backing Up Additional Database Files 4m
6. Using Optional Backup Features
Using Optional Backup Features 15m
Compres Backup Demo 4m
Creating Duplex Backups Set by Backups Copies Demo 3m
Creating Backups of Backups Set Demo 2m
Creating archival Backups with RMAN Demo 4m
Backing ups Recovery File Demo 2m
Practice 3-1: Creating an Archival Backup 6m
7. Tuning RMAN Backup Performance
Tuning RMAN Backup Performance 10
Asynchronous I/O Bottlenecks 9
Practice 4-1: Monitoring an RMAN Backup Job 5
8. Recovery Catalog: Overview
Recovery Catalog: Overview 5m
9. Creating a Recovery Catalog
Creating a Recovery Catalog 5m
Configure a Recovery Catalog Database Demo 2m
Creating a Recovery Catalog Owner Demo 1m
Creating a Recovery Catalog Demo 2m
Practice 2-1: Creating a Recovery Catalog Owner 7m
Practice 2-2: Creating the Recovery Catalog 2m
10. Managing Target Database Records
Managing Target Database Records 6m
Register a Database in Recovery Catalog Demo 2m
Manually Resynchronizing Recovery Catalog – Demo 2m
Practice 3-1: Registering a Database in the Recovery Catalog 3m
Practice 3-2: Configuring the Recovery Catalog for Recovery 8m
11. Using Stored scripts
Using Stored scripts 5m
Practice 4-1: Creating a Stored script 4m
Practice 4-2: Executing a Stored script 3m
12. Creating and Using Virtual Private Catalogs
Creating and Using Virtual Private Catalogs 5m
Practice 5-1: Enabling the Virtual Private Database (VPD) Functionality 4m
Practice 5-2: Creating a Virtual Private C atalog 4m
Practice 5-3: Backing Upa PDB 3m
13. Restore and Recovery Concepts
Restore and Recovery Concepts 10m
Instance Failure 18m
14. Diagnosing Failure
Diagnosing Failure 10m
Data Recovery Advisor 16m
Diagnosing Failure Using Oracle Database Recovery Advisor Demo 8m
Practice 2-1: Diagnosing and Repairing Database Failure. 9m
15. Performing Complete Recovery
Performing Complete Recovery 20m
Performing Complete Recovery Using RMAN Demo 7m
Practice 3-1: Recovering from the Loss of a System-Crtical Data File 18m
Practice 3-2: Recovering from the Loss of an Application Data File 18m
16. Performing Point-in-Time Recovery
Performing Point-in-Time Recovery 7m
Architecture Tablespace Point-in-Time Recovery 19m
Performing Incomplete Recovery Using Data Recovery Advisor RMAN Demo 16m
Practice 4-1: Recovering from Media Failure: Incomplete Recovery 26m
Practice 4-2: Recovering a Table from a Backup 17m
17. Performing Block Media Recovery
Performing Block Media Recovery 9m
Performing a Recovery Block Media Corruption Demo 4m
Practice 5-1: Repairing Block Corruption 6m
18. Performing Additional Recovery Operations
Performing Additional Recovery Operations 19m
Practice 6-1: Recovering from the Loss of a Parameter File 7m
Practice 6-2: Restoring the Control File 7m
Practice 6-3: Recovering from the Loss of All Control Files 11m
Practice 6- 4: Restoring the Password File 7m
19. Oracle Flashback Technology: Overview
Oracle Flashback Technology: Overview 9m
20. Using Logical Flashback Features
Using Logical Flashback Features 13m
Flashback Drop and the Recycle Bin 16m
Prepare to Using Flashback Technology Demo 16m
Practice 2-1: Preparing to Use Flashback Technologies 9m
Practice 2-2: Restoring a Dropped Table 7m
Practice 2-3: Using Flashback Table 7m
21. Using Flashback Database
Using Flashback Database 17m
Enabling Oracle Flashback Database Demo 18m
Practice 3-1: Enabling Flashback Logging 7m
Practice 3-2: Performing Flashback Database 11m
22. Using PDB Snapshot
Using PDB Snapshot 6m
23. Database Duplication Overview
Database Duplication Overview 12m
Demo (Part 01) 22m
24. Creating a Backup-based Duplicate Database
Creating a Backup-based for Duplicate Database 12m
Allocating Auxiliary Channels 16m
Demo (Part 02) 9m
Practice 2-1: Duplicating a Database (Part I) 24m
Practice 2-1: Duplicating a Database (Part II) 2m
Practice 2-2: Duplicating a PDB into an Existing CDB 9m
