±³À°¸í | ÃÊ±Þ Oracle Database 12c: Administration Workshop (¿À¶óŬ 12c DB °ü¸®ÀÚ ±âº») 5Â÷ |
---|---|
±³À°±â°£ | 2018-01-08 ~ 2018-01-12 |
±³À°½Ã°£ | 30 ½Ã°£ |
±³À°Àå | ¿µ¿ì±Û·Î¹ú·¯´× Áöµµº¸±â |
°»ç | ¿À¶óŬ°øÀΰ»ç |
Á¤¿ø | 20¸í |
±³À°ºñ | 1,805,000 ¿ø |
¡à Benefits To You
¿À¶óŬ DatabaseÀνºÅϽº ¹× µ¥ÀÌÅͺ£À̽º ¾ÆÅ°ÅØÃ³ÀÇ ¾ÆÅ°ÅØÃ³¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸¸¦ ¾òÀ» ¼ö ÀÖÀ¸¹Ç·Î
µ¥ÀÌÅͺ£À̽º ¸®¼Ò½º¸¦ È¿°úÀûÀ¸·Î °ü¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º¿¡¼ Áö¿øÇÏ´Â ºñÁî´Ï½º ¾ÖÇø®ÄÉÀ̼ǿ¡ ÀûÇÕÇÑ µ¥ÀÌÅͺ£À̽º ½ºÅ丮Áö ±¸Á¶¸¦ »ý¼ºÇÏ´Â ¹æ¹ý ¹×
»ç¿ëÀÚÀÇ ºñÁî´Ï½º ¿ä±¸ »çÇ×À» ÃæÁ·Çϱâ À§ÇØ »ç¿ëÀÚ¸¦ »ý¼ºÇÏ°í µ¥ÀÌÅͺ£À̽º º¸¾ÈÀ» °ü¸®ÇÏ´Â ¹æ¹ýÀ» ¹è¿ï ¼ö ÀÖ½À´Ï´Ù.
¹é¾÷ ¹× º¹±¸ ±â¼ú¿¡ ´ëÇÑ ±âº» Á¤º¸°¡ ÀÌ °úÁ¤¿¡¼ Á¦½ÃµË´Ï´Ù.
¡à Course Topics
¡Û Getting Started
- Course Objectives
¡Û Exploring Oracle Database Architecture
- Introducing Oracle Database
- Relation Database Models
- Oracle SQL and PL/SQL
- Oracle Database Server Architecture
- Connecting to Oracle Databases
- Oracle Database Tools
- Oracle-Supplied User Accounts
- Querying the Oracle Data Dictionary
¡Û Managing Database Instances
- Initialization Parameter Files
- Starting Up Oracle Databases
- Shutting Down Oracle Databases
- Opening and Closing PDBs
- Working with the Automatic Diagnostic Repository (ADR)
- Querying Dynamic Performance Views
¡Û Creating PDBs
- Methods and Tools to Create PDBs
- Creating PDBs from Seed with SQL*Plus
- Cloning PDBs with SQL*Plus
- Unplugging and Pluggin In PDBs with SQL*Plus
- Dropping PDBs with SQL*Plus
¡Û Configuring the Oracle Network Environment
- Oracle Net Services
- How Listeners Work
- Configuring Listeners for Dynamic Service Registration
- Configuring Listeners for Static Service Registration
- Configuring Local Naming for Connections
- Testing Oracle Net Connectivity with tnsping
- Configuring Communidation Between Databases
- Dedicated Versus Shared Server Configurations
¡Û Administering User Security
- Creating Users
- Granting Privileges
- Creating and Granting Roles
- Revoking Privileges and Roles
- Creating and Assigning Profiles
- Authenticating Users
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
¡Û Creating and Managing Tablespaces
- How Table Data is Stored
- Creating Tablespaces in SQL*Plus
- Altering and Dropping Tablespaces in SQL*Plus
- Viewing Tablespace Information in SQL*Plus
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files in SQL*Plus
¡Û Managing Storage Space
- Oracle Database Space Management Features
- Block Space Management
- Row Chaining and Migration
- Free Space Management Within Segments
- Types of Segments
- Allocating Extents
- Understanding Deferred Segment Creation
- Space-Saving Features
¡Û Managing UNDO Data
- Undo Data: Overview
- Transactions and Undo Data
- Storing Undo Information
- Comparing Undo Data and Redo Data
- Managing Undo
- Local Undo Mode Versus Shared Undo Mode
- Configuring Undo Retension
- Categories of Undo
¡Û Moving Data
- Moving Data: General Architecture
- Oracle Data Pump: Overview
- Oracle Data Pump: Benefits
- Data Pump Export and Import Clients
- Data Pump Utility: Interfaces and Modes
- Data Pump Import: Transformations
- SQL*Loader Overview
- Loading Methods
¡Û Backup and Recovery Concepts
- DBA Responsibilities
- Categories of Failure
- Understanding Instance Recovery
- Understanding Types of Backups
- Comparing Complete and Incomplete Recovery
- Oracle Data Protection Solutions
- Flashback Technology
¡Û Monitoring and Tuning Database Performance
- Managing Performance Activities
- Performance Planning Considerations
- Database Maintenance
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor
- Performance Monitoring
- Performance Tuning Methodology
- Database Server Statistics and Metrics
¡Û SQL Tuning
- SQL Tuning Process
- Oracle Optimizer
- Optimizer Statistics
- SQL Plan Directives
- Adaptive Execution Plans
- SQL Tuning Advisor
- SQL Access Advisor
- SQL Performance Analyzer
¡Û Oracle Database Resource Manager
- Oracle Database Resource Manager: Overview
- Resource Manager Elements
- Using Resource Manager to Allocate Resources
- Creating a Simple Resource Plan
- Creating a Complex Resource Plan
- Using the Active Session Pool Feature
- Limiting CPU Utilization at the Database Level
- Limiting CPU Utilization at the Server Level
¡Û Enterprise Manager Cloud Control
- Controlling the Enterprise Manager Cloud Control Framework
- Starting the Enterprise Manager Cloud Control Framework
- Stopping the Enterprise Manager Cloud Control Framework
¡Û Introduction to Oracle Database Cloud Service
- Oracle Cloud: Overview
- Database Cloud Service Offerings
- DBCS Architecture
- Features and Tooling
- Additional Database Configuration Options
¡Û Creating DBCS Database Deployments
- Automated Database Provisioning
- Creating a Database Deployment
- How SSH Key Pairs are Used
- Creating an SSH Key Pair
- Storage Used for Database Files
¡Û Managing DBCS Database Deployments
- Cloud Tooling
- Accessing Tools and Features from the DBCS Console
- Managing the Compute Node Associated With a Database Deployment
- Managing Network Access to DBCS
- Enabling Access to a Compute Node Port
- Scaling a Database Deployment
¡Û Backing Up and Restoring DBCS Database Deployments
- Backing Up and Recovering Databases on DBCS
- Backup Destination Choices
- Backup Configuration
- Creating an On-Demand Backup
- Customizing the Backup Configuration
- Performing Recovery by Using the Console
- Performing Recovery by Using the dbaascli Utility
¡Û Patching DBCS Database Deployments
- Patching DBCS
- Using the DBCS Console to Manage Patches
- Using the dbaascli Utility to Manage Patches
¡Û Creating Master Encryption Keys for PDBs
- CDB and PDB Master Encryption Keys
- Determining Whether You Need to Create and Activate and Encryption Key for a PDB
- Creating and Activating an Encryption Key
¡Û Tablespace Encryption by Default
- Tablespace Encryption by Default in DBCS
- Transparent Data Encryption (TDE) Overview
- Components of TDE
- Using TDE
- Defining the Keystore Location
- Controlling Tablespace Encryption by Default
- Managing the Software Keystore and Master Encryption Key
- Managing the Keystore in CDBs and PDBs
ÇпøÀÇ ¼³¸³¤ý¿î¿µ ¹× °ú¿Ü±³½À¿¡ °üÇÑ ¹ý·ü ½ÃÇà·É¿¡ µû¶ó ´ÙÀ½°ú °°ÀÌ ¼ö°·á¸¦ ȯºÒÇØµå¸³´Ï´Ù.