Oracle PL/SQL Developer-Training

India, Uttar Pradesh, Ghaziabad
Published 1 year ago
ID #2209
QR CODE
1 photo
Check with seller
Oracle PL/SQL Developer-Training
India, Uttar Pradesh, Ghaziabad,
Published 1 year ago

Description

This hands-on course will teach you to effectively plan, install, configure, administer, query, troubleshoot and manage Oracle Databases. All books and materials are included.
The course will prepare students for the Oracle exams, as well as deliver a foundation in the real world application of their database skills.
Learn how to:
• Install, configure, and administer Oracle Database systems
• Manage and maintain an Oracle Database
• Plan, design and create tables
• Create and update reports from Oracle Databases
• Query Oracle databases using SQL and iSQL*Plus to retrieve critical business data
• Backup and recovery of database systems
• Tune and optimize a Oracle Database for most efficient use of computer resources
Audience and Prerequisites
This course is designed for individuals with generic database knowledge.
Course Content
Oracle11g™ OCA

Describing the Oracle Architecture
• Oracle Server
• SGA
• Datafiles
• Background Processes
Creating an Oracle Database
• Database Configuration Assistance
• Database Templates
Managing an Oracle Instance
• Oracle Enterprise Manager
Database Storage Structures
• Tablespaces
• Datafiles
• Tempfiles
Database Security
• System Accounts
• Application Accounts
• Database Roles
Schema Objects
• Tables
• Indexes
• Views
• Synonyms
Data Manipulation Language
• Insert
• Update
• Delete
• Database Packages
• Database Procedures
Undo Data
• Flashback Query
Database Maintenance
• Automatic Workload Repository
• Automatic Database Diagnostic Monitor
Database Performance
• Memory Advisors
Database Backup
• RMAN
• Open database Backup
• Closed database Backup
Database Recovery
• Open Database Recovery
• Closed Database Recovery
Moving Data
• Data Pump
• SQL*Loader

 

Contact seller

    Seller's picture
    Kumar Amit
    Unregistered user

    Comments

    Question? Need more information? Want to ask question? Add new comment...
    Ask questions related to this listing only.
    Comments are moderated.
    Add new comment
    Check with seller
    Contact seller No phone nuxxxx

    Seller's info

    Seller's picture
    Kumar Amit
    Unregistered user

    Listing location

    India, Uttar Pradesh, Ghaziabad
    ACLM Institute Of Professional Studies Plot No. – 662 | Sector - V | Vaishali | Ghaziabad - 201010