Omschrijving
Dit Bootcamp geeft hands-on ervaringen met de Oracle Database 11g. Er wordt daarnaast inzicht gegeven in het dagelijkse DBA werk, de database(machine) strategie van Oracle, de positionering in de totale technologie stack. Verder worden verschillende features en functies van de Oracle Database gedemonstreerd. Ook wordt duidelijk ingegaan op de verschillen tussen Oracle 11g en alle voorafgaande (7.3+) versies.
Doelgroep
Beginnende Oracle database beheerders
Doel
Relevante hands-on kennis van de (nieuwe) mogelijkheden die de Oracle Database biedt en het evalueren van de mogelijke toepassing in uw eigen situatie.
Voorkennis
Dit is waarschijnlijk je eerste kennismaking met de Oracle 11g Database, naast basis IT kennis is enige kennis van SQL gewenst.
Inhoud
Introduction
* About Oracle Database
* Common Oracle DBA Tasks
* Tools for Administering the Database
Installing Oracle Database and Creating a Database
* Overview of Installing Oracle Database Software and Creating a Database
* Installing Oracle Database Software
* Creating and Managing a Database with DBCA
* Configuring Automatic Storage Management Using DBCA
* Installation: Oracle By Example Series
Getting Started with Database Administration
* Managing Your Database: A Roadmap
* Introduction to Oracle Enterprise Manager Database Control
* Starting and Stopping the Database Control Console Process
* Accessing the Database Home Page
* Granting Access to Database Control for Nonadministrative Users
* Creating Database Control Administrative Users
* Setting Database Control Preferences
* About SQL and SQL-Based Management Tools
* Getting Started with Oracle Enterprise Manager
Configuring the Network Environment
* Understanding Network Configuration
* Viewing Listener Configuration
* Starting and Stopping the Listener
* Connecting to an Oracle Database from a Client Computer
* Networking
Managing the Oracle Instance
* Overview of the Oracle Instance and Instance Management
* Shutting Down and Starting Up the Oracle Instance
* Viewing and Modifying Initialization Parameters
* Managing Memory
* Instances
Managing Database Storage Structures
* About Database Storage Structures
* Viewing Database Storage Structure Information
* Performing Common Database Storage Tasks
* Managing the Redo Log
* Managing Undo Data
* Storage
| Administering User Accounts and Security
* About User Accounts
* About User Privileges and Roles
* About Administrative Accounts and Privileges
* Administering Roles
* Administering Database
User Accounts
* Setting the Database Password Policy
* Users: Oracle By Example Series
Managing Schema Objects
* About Schema Objects
* About Schema Object Management Privileges
* Managing Tables
* Managing Indexes
* Managing Views
* Managing Program Code Stored in the Database
* Working with Other Schema Objects
* Schemas: Oracle By Example Series
Performing Backup and Recovery
* Overview of Database Backup and Recovery
* Database Backup and Recovery Concepts
* Configuring Your Database for Basic Backup and Recovery
* Backing Up Your Database
* Displaying Backup Reports
* Managing Backups
* Performing Oracle Advised Recovery
* Performing User-Directed Recovery
* Backup and Recovery
Monitoring and Tuning the Database
* Proactive Database Monitoring
* Diagnosing Performance Problems Using ADDM
* Using Advisors to Optimize Database Performance
* Monitoring and Tuning
Investigating, Reporting, and Resolving Problems
* About Database Problems and Incidents
* Investigating, Reporting, and Resolving a Problem
* Viewing Problems Using the Enterprise Manager Support Workbench
Managing Oracle Database Software
* About Software Management and Patch Releases
* Patching the Oracle Software
* Viewing Critical Patch Advisories
* Upgrading a Database
* Managing Oracle Software
Administering Automatic Storage Management |
Kosten, duur en locatie
De workshop duurt 5 dagen en vindt plaats op onze locatie in Amersfoort, op loopafstand van het NS-station. De kosten zijn € 599,00 (excl. BTW) per persoon per dag, inclusief lunch en cursusmaterialen. Cursisten werken met een eigen cursusomgeving en krijgen deze ook mee naar huis.
