SISINDOTEK

I.T Solution | I.T Training | I.T Integration System

Syllabus / silabus Oracle – SISINDOTEK Bandung

SISINDOTEK SYLLABUS / SILABUS ORACLE
Oracle 11g PL/SQL and DBA Fundamental
Durasi : 7 jam x 4 Hari (28 Jam)

Deskripsi : Database Oracle adalah Database relasional yang terdiri dari kumpulan data dalam suatu sistem manajemen Database RDBMS. Perusahaan Software Oracle memasarkan jenis Database ini untuk bermacam-macam aplikasi yang bisa berjalan pada banyak jenis dan merk perangkat keras komputer (platform).

Database Oracle ini pertama kali dikembangkan oleh Larry Ellison, Bob Miner dan Ed Oates lewat perusahaan konsultasinya bernama Software Development Laboratories (SDL) pada tahun 1977. Pada tahun 1983, perusahaan ini berubah nama menjadi Oracle Corporation sampai sekarang. Release yang cukup banyak digunakan saat ini adalah 11g

Tujuan Training : Peserta memahami konsep database , instalasi , perintah perintah dasar PL/SQL dan juga aktifitas Database Administration.

Target Peserta : – Staff IT
– Database Developer
– Database Administrator
– System Analyst
– Application Programmer

Prasyarat : – Familiar dengan database
– Sangat disarankan telah / pernah membuat aplikasi database sederhana.

Materi Training : Topic 1 : Oracle Database Concept Overview

Topic 2 : Oracle PL/SQL

Retrieving Data Using the SQL SELECT Statement

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Reporting Aggreagted Data Using the Group Functions

Displaying Data from Multiple Tables

Using Subqueries to Solve Queries

Using the Set Operators

Manipulating Data

Using DDL Statements to create and Manage Tables

Creating Other Schema Objects

Managing Objects with Data Dictionary Views

Controlling User Access

Manage Schema Objects

Manipulating Large Data sets

Generating Reports by Grouping Related Data

Managing Data in Different Time Zones

Retrieving Data using Subqueries

Hierarchical Retrieval

Regular Expression Support

Topic 3 : Oracle DBA Fundamental

Installing the Oracle Database Software

Creating an Oracle Database

Managing the Oracle Instance

Managing Database Storage Structures

Administering User Security

Managing Schema Objects

Managing Data and Concurrency

Managing Undo Data

Implementing Oracle Database Security

Configuring the Oracle Network Environment

Proactive maintenance

Performance Management

Backup and Recovery Concepts

Performing database Backups

Performing Database Recovery

Performing Flashback

Training Lanjutan yang Disarankan : Oracle 11g Performance Tuning ( On Progress)

Single Post Navigation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: