Rekan-rekan Komunitas Oracle Surabaya & sekitarnya, Oracle Indonesia dan STIKOM - Surabaya mengadakan workshop :
Judul Workshop : ORACLE Database 10g : 2 Days DBA Instruktur Workshop : Yulius Wibowo Tanggal : 6-7 Juli 2007 Jam : 09:00 s/d 17:00 Tempat Workshop : Laboratorium Komputer STIKOM Kampus I STIKOM Jl. Raya Kedung Baruk 98, Surabaya Biaya : Rp 700.000,- Rp 600.000,- untuk 10 pendaftar pertama dan pendaftaran kolektif (minimal 2 peserta) Kapasitas : Dibatasi hanya 36 peserta Untuk informasi pendaftaran dan informasi hubungi Sdri Ceny : Phone: 031-8721731, email : ceny @ stikom.edu hermawan @ stikom.edu Fasilitas : 1 orang 1 komputer Student Kit resmi Oracle University Certificate from Oracle University Lunch, Snack and Drink Oracle Database 10*g*: 2 Day DBA What you will learn: The goal of this course is to teach Database Adminstrators how to install the Oracle Database software and perform the tasks required to manage an Oracle database. Enterprise Manager is used exclusively throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 10g. This course is targeted towards Database Administrators of small to medium sized businesses. *Learn To:* - Install the Database - Monitor and Tune the Database - Navigate in the EM - Manage the Oracle Instance - Perform Backup and Recovery - Administer Users and Security Audience: * *Database Administrators Sales Consultants SAP Administrator Course Objectives: Installing the Oracle Database software and creating a database Using Enterprise Manager Database Control to manage the database Configuring and managing the Oracle Network environment Managing database storage structures Administering users and security Managing schema objects Backing up and recovering the Oracle database Monitoring the database and using the Advisors Updating Oracle software with patch releases Tuning the database ------------------------------ Course Topics: * Overview of Oracle Database Administration * Overview of the Oracle Instance and Database Tasks of an Oracle Database Administrator Tools Used to Administer an Oracle Database * Installing Oracle Software and Creating the Database * Using the Oracle Universal Installer (OUI) Installation Pre-requisites Installing the Oracle Software Using the Database Configuration Assistant (DBCA) to Create a Database Using DBCA to Manage Templates Using DBCA to Add Options to Your Database * Using Oracle Enterprise Manager Database Control and SQL*Plus * Overview of Administering the Database Using Enterprise Manager (EM) Starting the EM Database Console Enterprise Manager Navigation Granting EM Administrative Privileges Using SQL*Plus and iSQL*Plus to Access Your Database * Configuring the Oracle Network Environment * Network Configuration Overview Oracle Net Listener Configuration and Management Oracle Net Naming Methods Tools for Configuring and Managing the Oracle Network * Managing the Oracle Instance * Oracle Instance and Instance Management Accessing the Oracle Database Initialization Parameters and Password File Starting Up and Shutting Down the Instance Viewing the Alert Log and Trace Files * Managing Database Storage Structures * Oracle Database Structures Creating a New Tablespace Managing Undo and Using the Undo Advisor Multiplexing the Redo Log File * Administering Users and Security * Overview of Users and Security Creating and Administering Users Locking and Unlocking Accounts Setting Passwords Administering Privileges and Roles * Managing Schema Objects * Creating Schema Objects Creating and Modifying Tables Understanding Data Integrity and Defining Constraints Viewing the Attributes and Contents of a Table Creating Indexes and Views Loading Data * Performing Backup and Recovery * Backup, Restore and Recovery Concepts Configuring the Database for Backup and Recovery Configuring Backup Settings Backing Up the Database Using EM Whole Database Backups Oracle-Suggested Backup Strategy Restoring and Recovering the Whole Database * Monitoring and Tuning the Database * Monitoring the Oracle Database Self-Monitoring Architecture Monitoring and Tuning Usage Model Using the Advisors * Managing Oracle Software * Working with Oracle Support Search MetaLink Logging TARs Applying a Patch Release
