WIXLIB

We Empower People Around The World To SucceedThrough LearningCourse Outline: Oracle Database 12c R2: AdministrationWorkshop Ed 3Duration: 5 DaysWhat you will learnThe Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provideyou with a firm foundation in administration of an Oracle Database. In this course you willgain a conceptual understanding of Oracle Database architecture and learn how to managean Oracle Database in an effective and efficient manner.Learn To: Manage an Oracle Database instance.Configure the Oracle Network environment.Create and manage storage structures.Manage and move data.Create and manage users.Monitor the database and manage performance.Create and manage Database as a Cloud Service database deployments.Benefits To YouYou will benefit from this course as you learn detailed information on the architecture ofan Oracle Database instance and database, enabling you to effectively manage yourdatabase resources. You learn how to create database storage structures appropriate for thebusiness applications supported by your database. In addition you learn how to create usersand administer database security to meet your business requirements. Basic information onbackup and recovery techniques is presented in this course.To provide an acceptable response time to users and manage resources effectively, youlearn how to monitor your database and manage performance.New Horizons - Stepnex ServicesPage 1 of 9Course outlines

We Empower People Around The World To SucceedThrough LearningAudience Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical AdministratorCourse Objectives Back up, restore, and patch DBCS database deploymentsDescribe the DBaaS and on-premises Oracle Database architecturesManage database instancesManage UNDO dataMove data between databasesImplement basic backup and recovery proceduresMonitor and tune database performanceTune SQL to improve performanceManage resources with Oracle Database Resource ManagerCreate pluggable databases (PDBs)Configure the Oracle network environmentAdminister user security and implement auditingCreate and manage tablespacesManage storage spaceCreate and manage Database as a Cloud Service (DBCS) database deploymentsRegister databases and manage performance with Enterprise Manager CloudControlCourse TopicsNew Horizons - Stepnex ServicesPage 2 of 9Course outlines

We Empower People Around The World To SucceedThrough LearningGetting Started Course ObjectivesExploring Oracle Database Architecture Introducing Oracle DatabaseRelation Database ModelsOracle SQL and PL/SQLOracle Database Server ArchitectureConnecting to Oracle DatabasesOracle Database ToolsOracle-Supplied User AccountsQuerying the Oracle Data DictionaryManaging Database Instances Initialization Parameter FilesStarting Up Oracle DatabasesShutting Down Oracle DatabasesOpening and Closing PDBsWorking with the Automatic Diagnostic Repository (ADR)Querying Dynamic Performance ViewsCreating PDBs Methods and Tools to Create PDBsCreating PDBs from Seed with SQL*PlusCloning PDBs with SQL*PlusUnplugging and Pluggin In PDBs with SQL*PlusDropping PDBs with SQL*PlusConfiguring the Oracle Network Environment Oracle Net ServicesNew Horizons - Stepnex ServicesPage 3 of 9Course outlines

We Empower People Around The World To SucceedThrough Learning How Listeners WorkConfiguring Listeners for Dynamic Service RegistrationConfiguring Listeners for Static Service RegistrationConfiguring Local Naming for ConnectionsTesting Oracle Net Connectivity with tnspingConfiguring Communidation Between DatabasesDedicated Versus Shared Server ConfigurationsAdministering User Security Creating UsersGranting PrivilegesCreating and Granting RolesRevoking Privileges and RolesCreating and Assigning ProfilesAuthenticating UsersAssigning Quotas to UsersApplying the Principal of Least PrivilegeCreating and Managing Tablespaces How Table Data is StoredCreating Tablespaces in SQL*PlusAltering and Dropping Tablespaces in SQL*PlusViewing Tablespace Information in SQL*PlusImplementing Oracle Managed FilesMoving and Renaming Online Data Files in SQL*PlusManaging Storage Space Oracle Database Space Management FeaturesBlock Space ManagementRow Chaining and MigrationFree Space Management Within SegmentsTypes of SegmentsNew Horizons - Stepnex ServicesPage 4 of 9Course outlines

We Empower People Around The World To SucceedThrough Learning Allocating ExtentsUnderstanding Deferred Segment CreationSpace-Saving FeaturesManaging UNDO Data Undo Data: OverviewTransactions and Undo DataStoring Undo InformationComparing Undo Data and Redo DataManaging UndoLocal Undo Mode Versus Shared Undo ModeConfiguring Undo RetensionCategories of UndoMoving Data Moving Data: General ArchitectureOracle Data Pump: OverviewOracle Data Pump: BenefitsData Pump Export and Import ClientsData Pump Utility: Interfaces and ModesData Pump Import: TransformationsSQL*Loader OverviewLoading MethodsBackup and Recovery Concepts DBA ResponsibilitiesCategories of FailureUnderstanding Instance RecoveryUnderstanding Types of BackupsComparing Complete and Incomplete RecoveryOracle Data Protection SolutionsFlashback TechnologyNew Horizons - Stepnex ServicesPage 5 of 9Course outlines

We Empower People Around The World To SucceedThrough LearningMonitoring and Tuning Database Performance Managing Performance ActivitiesPerformance Planning ConsiderationsDatabase MaintenanceAutomatic Workload Repository (AWR)Automatic Database Diagnostic MonitorPerformance MonitoringPerformance Tuning MethodologyDatabase Server Statistics and MetricsSQL Tuning SQL Tuning ProcessOracle OptimizerOptimizer StatisticsSQL Plan DirectivesAdaptive Execution PlansSQL Tuning AdvisorSQL Access AdvisorSQL Performance AnalyzerOracle Database Resource Manager Oracle Database Resource Manager: OverviewResource Manager ElementsUsing Resource Manager to Allocate ResourcesCreating a Simple Resource PlanCreating a Complex Resource PlanUsing the Active Session Pool FeatureLimiting CPU Utilization at the Database LevelLimiting CPU Utilization at the Server LevelNew Horizons - Stepnex ServicesPage 6 of 9Course outlines

We Empower People Around The World To SucceedThrough LearningEnterprise Manager Cloud Control Controlling the Enterprise Manager Cloud Control FrameworkStarting the Enterprise Manager Cloud Control FrameworkStopping the Enterprise Manager Cloud Control FrameworkNew Horizons - Stepnex ServicesPage 7 of 9Course outlines

We Empower People Around The World To SucceedThrough LearningIntroduction to Oracle Database Cloud Service Oracle Cloud: OverviewDatabase Cloud Service OfferingsDBCS ArchitectureFeatures and ToolingAdditional Database Configuration OptionsCreating DBCS Database Deployments Automated Database ProvisioningCreating a Database DeploymentHow SSH Key Pairs are UsedCreating an SSH Key PairStorage Used for Database FilesManaging DBCS Database Deployments Cloud ToolingAccessing Tools and Features from the DBCS ConsoleManaging the Compute Node Associated With a Database DeploymentManaging Network Access to DBCSEnabling Access to a Compute Node PortScaling a Database DeploymentBacking Up and Restoring DBCS Database Deployments Backing Up and Recovering Databases on DBCSBackup Destination ChoicesBackup ConfigurationCreating an On-Demand BackupCustomizing the Backup ConfigurationPerforming Recovery by Using the ConsoleNew Horizons - Stepnex ServicesPage 8 of 9Course outlines

We Empower People Around The World To SucceedThrough Learning Performing Recovery by Using the dbaascli UtilityPatching DBCS Database Deployments Patching DBCSUsing the DBCS Console to Manage PatchesUsing the dbaascli Utility to Manage PatchesCreating Master Encryption Keys for PDBs CDB and PDB Master Encryption KeysDetermining Whether You Need to Create and Activate and Encryption Key for aPDBCreating and Activating an Encryption KeyTablespace Encryption by Default Tablespace Encryption by Default in DBCSTransparent Data Encryption (TDE) OverviewComponents of TDEUsing TDEDefining the Keystore LocationControlling Tablespace Encryption by DefaultManaging the Software Keystore and Master Encryption KeyManaging the Keystore in CDBs and PDBsNew Horizons - Stepnex ServicesPage 9 of 9Course outlines

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Learn To: Manage an Oracle Database instance. Configure the .