Course (3-1) Oracle 11g

zoom

pre 1 of 1 next

Location: New York - Map

Date posted: June 21, 2013

Price: Please contact

Ad ID: 91753

Views: 15

Reply by email

  • 1.A Pragmatic Introduction to Oracle
    • 1.1. Introducing a New Kind of Database Management
    • 1.2. Pooling Resources with Grid Computing
    • 1.3. Anticipating Technology and Development Trends
    • 1.4. Meeting Oracle in the Real World
    • 1.5. Making the Oracle Decision
  • 2. Understanding Oracle Database Architecture
    • 2.1. Defining Databases and Instances
    • 2.2. Deconstructing the Oracle Architecture
    • 2.3. Walking Down Oracle Memory Structures
    • 2.4. Trotting around the System Global Area
      • 2.4.1. Shared pool
      • 2.4.2. Database buffer cache
      • 2.4.3. Redo log buffer
      • 2.4.4. Large pool
      • 2.4.5. Java pool
    • 2.5. Program Global Area
    • 2.6. Managing Memory
      • 2.6.1 Managing memory automatically
    • 2.7. Following the Oracle Processes
      • 2.7.1. Background processes
      • 2.7.2. User and server processes
    • 2.8. Getting into Physical Structures
    • 2.9. Getting Physical with Files
      • 2.9.1. Data files: Where the data meets the disk
      • 2.9.2. Control files
      • 2.9.3. Redo log files
      • 2.9.4. Moving to the archives
      • 2.9.5. Server and initialization parameter fi les
    • 2.10. Applying Some Logical Structures
      • 2.10.1. Tablespaces
      • 2.10.2. Segments
      • 2.10.3. Extents
      • 2.10.4. Oracle blocks
  • 3. Preparing to Implement Oracle in the Real World
    • 3.1. Understanding Oracle Database Deployment Methodology
      • 3.1.1. Client-server applications
      • 3.1.2. Muli-tier applications
      • 3.1.3. Component confi gurations
    • 3.2. Checking on the Requirements
      • 3.2.1. User and directory requirements
      • 3.2.2. Hardware requirements
      • 3.2.3. Software requirements
      • 3.2.4. Storage requirements
      • 3.2.5. Other requirements
  • 4. Creating an Oracle Database
    • 4.1. Feeling at Home in Your Environment
      • 4.1.1. Finding the Oracle software owner
      • 4.1.2. Oracle versions
      • 4.1.3. Getting to home base
      • 4.1.4. ORACLE_BASE
      • 4.1.5. ORACLE_HOME
      • 4.1.6. ORACLE_SID
      • 4.1.7. PATH
    • 4.2. Sticking with the Oracle Universal Installer and oraenv
    • 4.3. Confi guring an Instance
      • 4.3.1. Using PFILE and SPFILES
      • 4.3.2. Setting parameters in the pfi le and spfi le
    • 4.4. Creating Your Oracle Database
    • 4.5. Bossing the Database Confi guration Assistant (DBCA)
      • 4.5.1. Taking database control
      • 4.5.2. Taking the DBCA steps
      • 4.5.3. Sharing (a) memory
    • 4.6. Feeling the Post-Confi guration Glow
  • 5. Connecting to and Using an Oracle Database
    • 5.1. Starting and Stopping the Database
      • 5.1.1. Environmental requirements
      • 5.1.2. Starting the database
      • 5.1.3. Stopping the database
    • 5.2. Connecting to the Database Instance
      • 5.2.1. Local versus remote connections
      • 5.2.2. Communication fl ow
      • 5.2.3. Setting up tnsnames.ora
      • 5.2.4. Confi guring the database listener with listener.ora
      • 5.2.5. Starting and stopping the database listener
      • 5.2.6. Testing the connection
      • 5.2.7. Oracle Net Confi guration Assistant
    • 5.3. Sidestepping Connection Gotchas
  • 6. Speaking the SQL Language
    • 6.1. Using SQL in Oracle
    • 6.2. Sharpening the SQL*Plus Tool
    • 6.3. Using SQL Connection Commands
    • 6.4. SQL*Plus Profi le Scripts glogin.sql and login.sql
      • 6.4.1. SQL*Plus buffer and commands
      • 6.4.2. SQL*Plus commands
    • 6.5. Getting Help from SQL*Plus
      • 6.5.1. SQL language elements
      • 6.5.2. Using the Oracle Data Dictionary
    • 6.6. Getting a PL/SQL Overview
      • 6.6.1. Blocking PL/SQL
  • 7. Populating the Database
    • 7.1. Creating Tablespaces
    • 7.2. Creating Users and Schemas
    • 7.3. Creating Database Objects
      • 7.3.1. Object types
      • 7.3.2. Object creation methods
  • 8. Protecting Your Oracle Database
    • 8.1. Assessing Database Threats
      • 8.1.1. Instance failure
      • 8.1.2. Oracle code tree
      • 8.1.3. Dropped objects
      • 8.1.4. Media failure
      • 8.1.5. Corruption
      • 8.1.6. User error
    • 8.2. Getting Your Oracle Recovery Manager
      • 8.2.1. Starting RMAN
      • 8.2.2. Configuring RMAN
      • 8.2.3. RMAN catalog
    • 8.3. Putting It in the Archives
      • 8.3.1. Turning archiving on and off
      • 8.3.2. Archive logs
      • 8.3.3. Enabling archiving
      • 8.3.4. Enabling the Flash Recovery Area
    • 8.4. Backup File Types with RMAN
      • 8.4.1. Backing up with backup sets
      • 8.4.2. Making copies
    • 8.5. Maintaining the Archives
    • 8.6. Viewing Backup Information
    • 8.7. Recovering Your Oracle Database
      • 8.7.1. Verifying the problem
      • 8.7.2. Complete recovery
      • 8.7.3. Incomplete recovery
      • 8.7.4. Recovering your database with copies
  • 9. Protecting Your Oracle Data
    • 9.1. Authentication
      • 9.1.1. User authentication
      • 9.1.2. Password authentication
      • 9.1.3. Operating system authentication
    • 9.2. Granting the Privileged Few
      • 9.2.1. System privileges
      • 9.2.2. Object privileges
    • 9.3. Role Playing
      • 9.3.1. Oracle-supplied roles
      • 9.3.2. The SYSDBA role
    • 9.4. Virtual Private Database Concept
    • 9.5. Auditing Oracle’s Big Brother
      • 9.5.1. Getting ready to audit
      • 9.5.2. Enabling and disabling audits
      • 9.5.3. Auditing system privileges
      • 9.5.4. Auditing objects
      • 9.5.5. Verifying an audit
      • 9.5.6. Viewing audit information
      • 9.5.7. Turning off audits
    • 9.6. Encrypting a Database
  • 10. Keeping the Database Running
    • 10.1. Doing Your Chores
      • 10.1.1. Making way, checking space
      • 10.1.2. Monitoring space in your segments
      • 10.1.3. Growing and shrinking: Tricky tables
      • 10.1.4. Checking users
      • 10.1.5. Audit records
      • 10.1.6. System logs
    • 10.2. Automating Jobs with the Oracle Scheduler
      • 10.2.1. Scheduler objects
      • 10.2.2. Creating your fi rst scheduler job
    • 10.3. Using Oracle Data Pump
      • 10.3.1. Data Pump Export
      • 10.3.2. Data Pump Import
    • 10.4. Creating Oracle Directories
    • 10.5. Using Data Pump with a Parameter File
  • 11. Tuning an Oracle Database
    • 11.1. Evaluating Tuning Problems
    • 11.2. Tuning Your Database
    • 11.3. Gathering Performance Information with Automatic Workload Repository
      • 11.3.1. SQL*Plus method
      • 11.3.2. Database Control method
    • 11.4. Using the Automatic Database Diagnostic Monitor (ADDM)
    • 11.5. Improving Queries with SQL Tuning
      • 11.5.1. Explain plan
      • 11.5.2. Active Session History (ASH)
      • 11.5.3. SQL Access Advisor
      • 11.5.4. SQL Tuning Advisor
      • 11.5.5. SQL Profi ling and Plan Management
      • 11.5.6. 10046 trace event
  • 12. Troubleshooting an Oracle Database
    • 12.1. Troubleshooting with System Methodology
      • 12.1.1. Identifying the real problem
      • 12.1.2. Performing basic system checks
      • 12.1.3. Performing basic database checks
      • 12.1.4. Analyzing error messages
      • 12.1.5. Developing and applying a solution
    • 12.2. Troubleshooting Using Oracle Database Logs
      • 12.2.1. Database log infrastructure
      • 12.2.2. Database alert log
      • 12.2.3. Trace and dump fi les
      • 12.2.4. Listener log
    • 12.3. Benefi ting from Other Diagnostic Utilities
      • 12.3.1. Oracle Enterprise Manager
      • 12.3.2. Remote Diagnostic Agent
      • 12.3.3. Diagnostic database scripts
  • 13. Monitoring and Managing with Enterprise Manager
    • 13.1. Tasting Oracle Enterprise Manager Flavors
      • 13.1.1. OEM Java Console
      • 13.1.2. OEM Database Control
      • 13.1.3. OEM Grid Control
    • 13.2. Confi guring Enterprise Manager with the DBCA
    • 13.3. Creating and Managing Database Control Users
    • 13.4. Working with Metrics and Policies
    • 13.5. Setting Up Notifi cations
    • 13.6. Setting Up User Notifi cations
    • 13.7. Navigating Database Control’s Main Page
      • 13.7.1. Inspecting the Database Control main page
      • 13.7.2. Accessing other targets
  • 14. Flashing Back and Replaying: Advanced Features
    • 14.1. Rolling Back with Flashback Database
      • 14.1.1. Confi guring and enabling a fl ash back
      • 14.1.2. Using restore points
      • 14.1.3. Flashing back your database
    • 14.2. Using Flashback Data Archive
      • 14.2.1. Using database replay
      • 14.2.2. Replaying the workload
  • 15. Using High-Availability Options
    • 15.1. Gathering Real Application Clusters
    • 15.2. Exploring RAC Architecture
      • 15.2.1. Hardware considerations for RAC
      • 15.2.2. Software considerations for RAC
    • 15.3. Preparing for a RAC Install
      • 15.3.1. Tools for managing a RAC installation
      • 15.3.2. Oracle RAC application for high availability
    • 15.4. Defending Oracle Data Guard
      • 15.4.1. Data Guard architecture
      • 15.4.2. Physical standby database
      • 15.4.3. Logical standby database
      • 15.4.4. Performing switchover and failover operations
  • 16. Top Ten Oracle Installation Do’s
    • 16.1. Read the Documentation
    • 16.2. Observe the Optimal Flexible Architecture
    • 16.3. Configure Your Profi le
    • 16.4. Running the Wrong Bit
    • 16.5. Set umask
    • 16.6. Become Oracle
    • 16.7. Stage It
    • 16.8. Patch It
    • 16.9. Mind the User and Group IDs
    • 16.10. Back It Up
  • 17. Top Ten Database Design Do’s
    • 17.1. Using Oracle’s Built-In Constraints
    • 17.2. Spreading Out Your IO
    • 17.3. Knowing Data Normalization
    • 17.4. Using Naming Conventions
    • 17.5. Setting Up Roles and Privileges Properly
    • 17.6. Keeping Ad-Hoc Queries to a Minimum
    • 17.7. Enforcing Password Security
    • 17.8. Limiting the Number of DBAs
    • 17.9. Storing Code in the Database
    • 17.10. Testing Your Recovery Strategy

Online LIVE Training Programming Course offered by INCAPROG ONLINE - www.incaprog.com - contacto@incaprog.com - Phone : (954) 727-3141

  • Share this ad: pictute pictute pictute pictute
  • Print: pictute
  • Add to favorites: pictute
  • Report: pictute