Starting to learn Oracle

Posted on 2005-05-15
Last Modified: 2012-05-05
Hi All

I've some experience with databases (Access and SQL Server), but I'd like to get into Oracle. I've no experience with Oracle at all, but I'd like to start to learn it.
Can you recommend any very good self-study book?
Any web site?
How can I start?

Thank you

Question by:deepakee
    LVL 6

    Expert Comment

    LVL 5

    Expert Comment

    This link shows Oracle to SQL Server migration tips and details. Since you're going to learn Oracle, I think this might be a good start to show you the difference between Oracle and SQL Server.

    I recommend "OCA/OCP Introduction to Oracle 9i SQL Study Guide " by Chip Dawes and Biju Thomas, because this book shows you basic PL/SQL commands and also works as a reference.
    LVL 6

    Expert Comment

    LVL 6

    Expert Comment

    LVL 5

    Accepted Solution


    if you are starting a as a new one its better to start with any of the "sybex" or "oracle press" certification guides ill recomends u to start from oracle architecture then go on to sqlplsql and then to backupa nd tuning..

    after u get the idea go to oracle documentationa and read and practice it...

    then once u got confidence u can go for any books related to topic details say oracle backup and recovery by ramavelpuri will do for backup..

    general idea go experts one on one by tom kyte..

    Oracle Performance Tuning 101
    by Gaja Krishna Vaidyanatha, et al (Paperback)
    The Art and Science of Oracle Performance Tuning
    by Christopher Lawson
    networking of oreilly...

    u can also visit some sites like,  etc

    but ill recommend u to practice..practice..practice...


    all these will do better ur knowledge

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now