Your Cart Is Empty
Home > Technical Courses > Oracle Database > Oracle Database 12c: Administration I
This course introduces the many powerful capabilities of the Oracle database and references the applicable modules within the Oracle database administration series.
The Oracle Database 12c: Administration I course guides you in many of the day-to-day administration tasks required of an Oracle database administrator. You will prepare for certification as an Oracle Certified Associated (OCA) database administrator. You will also be introduced to many of the administration sub-specialties that one might next pursue. It is increasingly rare for a single database administrator to fulfill all the required responsibilities necessary for management of an enterprise-scale Oracle database installation. Therefore, one may eventually specialize into backup and recovery strategies, database performance tuning, security administration and the like. So this course introduces the many powerful capabilities of the Oracle database and references the applicable modules within the Oracle database administration series that one might next consult.The Oracle Database 12c: Administration I also course demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.CertificationThis course considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".
Category
ID
Duration
Level
Price
Oracle Database
13057
5 Day(s)
Foundation
$2,975.00
Objectives
Major tasks to be considered within this course are:• Software installation and the creation of new databases.• An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.• Management of database files.• Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.• Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.• Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.• Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.• Control over database support services, including the Database Control, Oracle Net and others.• A primer on backup and recovery structures and strategies.• Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Introduction: Managing The Database Instance• The Database Management Tools• EM Database Express• EM Cloud Control• SQL Developer• Database Administration DutiesIntroduction: Database Architecture Review• Database Instance Configurations• Memory Structures• Process Structures• Storage ArchitectureIntroduction: Starting & Stopping Database Services• Start & Stop The Database Listener• About Database Startup/Shutdown• SYSOPER• SYSDBA• Database State & Stages• Startup With EM Cloud Control• Startup With SQL*PLUS• Shutdown With EM Cloud Control• Shutdown With SQL*PLUS• Using MS Windows ServicesIntroduction: Oracle Network Environment• Oracle NET Services Architecture• Oracle NET Configuration Assistant• Oracle NET Manager• Using EM Cloud Control• Advanced Network Compression• Troubleshooting Network ProblemsIntroduction: Diagnostics & Oracle Support• About Database Diagnostics• Fault Diagnosability Infrastructure• Database Instance Health Snapshot• The Support Workbench• Proactive Database Health Checks• Package Diagnostic Data• Working With The Knowledge BaseStorage: Tablespace Management• Starter Tablespaces• Create Tablespace With EM CC• Create Tablespace With SQL• Manage Tablespaces With EM CC• Manage Tablespaces With EM DE• Manage Tablespaces With SQL• DROP Tablespace• ALTER TablespaceStorage: Advanced Tablespace Management• Managing Temporary Tablespaces• Temp Tablespace Groups With EM• Temp Tablespace Groups With SQL• Default Permanent Tablespaces• Bigfile Tablespaces• Managing The SYSAUX TablespaceStorage: Data Files & Temp Files Management• Manage Data Files With EM• Access Metadata With SQL• Manage Data Files With SQL• Manage Temp Files• Oracle-Managed Files (OMF)Storage: Undo Data & Undo Tablespaces• About Undo Space Management• Configure Undo Management• Guarantee Undo Retention• Monitor Undo Space With SQL• Use The EM Undo Advisor
Security & Schemas: Security Overview & Database Privileges• Database Security Principles• Database System Privileges• Database Object Privileges• Super Administrator Roles• Privilege AnalysisSecurity & Schemas: User Security• Create & Manage User Accounts• Manage Users With EM• Manage Users With SQL• CREATE User• ALTER User• DROP User• Grant & Revoke Privileges• Resource Limits Via Profiles• ALTER Profile• DROP Profile• Password Management Via Profiles• Role-Based Security Management• Alter User...Default Role• Set Role• Delegating Privilege Authorization• With Admin Option & System Privileges• With Grant Option & Object Privileges• Principle Of Least Privilege ChecklistSecurity & Schemas: Database Auditing• Auditing Database Activity• Traditional Auditing• Unified Auditing• Create Audit PolicySecurity & Schemas: SQL Loader• Loader Concepts• Loader From The Command Line• Control File Options• Load Methods• Loader Express Mode• Loader From EMSecurity & Schemas: Export & Import• Manage Directory Objects• The Data Pump Architecture• Data Pump Export• Data Pump Import• Data Pump Dictionary Views• Using The EM Cc InterfacePerformance & Availability: Managing Performance & SQL Tuning• Management Advisory Framework• Performance Monitoring & AWR• The SQL Tuning Advisor• Monitoring Exceptions With MetricsPerformance & Availability: Data Concurrency• About System & User Locks• Monitor & Manage User Locks• Monitor Locks With Data Dictionary• Manage Locks With EMPerformance & Availability: Backup & Recovery Concepts• Backup & Recovery Structures• Managing Redo Data• Configuring For Recoverability• Instance Recovery• Recoverability Checklist
Questions?
Oracle Database 12c Administrator Certified Associate (OCA)
These are recommended prerequisites for this course:Oracle Database 12c: SQL Fundamentals (Levels I & II)Oracle Database 12c: Install & Upgrade WorkshopOracle Database 12c: Architecture & Internals
Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.
Productivity Point Headquarters 1580 Sawgrass Corporate Parkway Suite 205 Sunrise, Florida 33323 United States
Contact T 1-844-238-8607 P 1-954-425-6141 F 1-954-928-9057 E info@productivitypointls.com