Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 12c: Administration Workshop
Oracle Training Overview

The overall objective of this course is threefold. First, this course instructs one in many of the day-to-day administration tasks required of an Oracle database administrator. Second, it is one of the course modules that assist in preparation for certification as an Oracle Certified Associated (OCA) database administrator. Finally, it introduces one 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 courses within the Oracle database administration series that one might next consult.

Whenever appropriate this 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.


Oracle Training Audience

The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals
Oracle Training Prerequisites

These are recommended prerequisites for this course:
  • Oracle Database 12c: SQL Fundamentals (Levels I & II)
  • Oracle Database 12c: Install & Upgrade Workshop Oracle Database 12c: Architecture & Internals `
Oracle Training Certification

This 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".


Course duration

5 Days

Oracle Training Course outline

INTRODUCTION: MANAGING THE DATABASE INSTANCE
  • THE DATABASE MANAGEMENT TOOLS
  • EM DATABASE EXPRESS
  • EM CLOUD CONTROL
  • SQL DEVELOPER
  • DATABASE ADMINISTRATION DUTIES
INTRODUCTION: DATABASE ARCHITECTURE REVIEW
  • DATABASE INSTANCE CONFIGURATIONS
  • MEMORY STRUCTURES
  • PROCESS STRUCTURES
  • STORAGE ARCHITECTURE
INTRODUCTION: 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 SERVICES
INTRODUCTION: ORACLE NETWORK ENVIRONMENT
  • ORACLE NET SERVICES ARCHITECTURE
  • ORACLE NET CONFIGURATION ASSISTANT
  • ORACLE NET MANAGER
  • USING EM CLOUD CONTROL
  • ADVANCED NETWORK COMPRESSION
  • TROUBLESHOOTING NETWORK PROBLEMS
INTRODUCTION: 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 BASE
STORAGE: 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 TABLESPACE
STORAGE: ADVANCED TABLESPACE MANAGEMENT
  • MANAGING TEMPORARY TABLESPACES
  • TEMP TABLESPACE GROUPS WITH EM
  • TEMP TABLESPACE GROUPS WITH SQL
  • DEFAULT PERMANENT TABLESPACES
  • BIGFILE TABLESPACES
  • MANAGING THE SYSAUX TABLESPACE
STORAGE: 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 ANALYSIS
SECURITY & 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 CHECKLIST
SECURITY & SCHEMAS: DATABASE AUDITING
  • AUDITING DATABASE ACTIVITY
  • TRADITIONAL AUDITING
  • UNIFIED AUDITING
  • CREATE AUDIT POLICY
  • LOADER CONCEPTS
  • LOADER FROM THE COMMAND LINE
  • CONTROL FILE OPTIONS
  • LOAD METHODS
  • LOADER EXPRESS MODE
  • LOADER FROM EM
SECURITY & SCHEMAS: EXPORT & IMPORT
  • MANAGE DIRECTORY OBJECTS
  • THE DATA PUMP ARCHITECTURE
  • DATA PUMP EXPORT
  • DATA PUMP IMPORT
  • DATA PUMP DICTIONARY VIEWS
  • USING THE EM CC INTERFACE
PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
  • MANAGEMENT ADVISORY FRAMEWORK
  • PERFORMANCE MONITORING & AWR
  • THE SQL TUNING ADVISOR
  • MONITORING EXCEPTIONS WITH METRICS
PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
  • ABOUT SYSTEM & USER LOCKS
  • MONITOR & MANAGE USER LOCKS
  • MONITOR LOCKS WITH DATA DICTIONARY
  • MANAGE LOCKS WITH EM
PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
  • BACKUP & RECOVERY STRUCTURES
  • MANAGING REDO DATA
  • CONFIGURING FOR RECOVERABILITY
  • INSTANCE RECOVERY
  • RECOVERABILITY CHECKLIST

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy