Post reply

SQL Server to ORACLE training courses

  • February 10, 2005 at 2:53 am

    #163340

    I've been working as a SQL DBA for around 10 years and now need to learn ORACLE.

    Does anyone know of any formal training courses or publications that would help me with this?

    I have never even seen ORACLE before.

    LinkedIn Profile

  • February 10, 2005 at 3:52 am

    #541536

    I have collected some links that helped me getting started here:

    http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,47/

    As for training: well, almost each training provider who offers MS certifications also offers Oracle certification courses.

    At Oracle's homepage you can apply for your free copy of Oracle magazine.

    Which version will you use and do you have any size limitation on your inbox?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 10, 2005 at 4:24 am

    #541540

    Thanks Frank,

    If you notice your site traffic jump through the roof it will be my fault!

    Judging by the sheer volume of SPAM I get there isn't a limit to the size of my Inbox.

    It looks like I am going to be working with ORACLE 9i on a Solaris platform.

    The thing I notice with ORACLE is that it appears to be a vastly bigger product than SQL Server and this is reflected in the number of different courses that are available.

    LinkedIn Profile

  • February 10, 2005 at 4:45 am

    #541543

    I've dropped you a PM.

    Yes, everything in Oracle is bigger. Installation on 2 CD's and about 1.1 GB. Amount of RAM stolen and so on...

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • February 11, 2005 at 10:50 am

    #541849

    Be prepared for 'optimzer' culture shock (one of many 'shocks' you will receive from Oracle). SQL Server is a 'cost' based optimizer and Oracle by default is a 'rule' based optimzer'. However they are offering a choice in either 9i or 10g to use a 'cost' based optimzer (with added costs in a number of areas). SQL Server transaction logs vs. Oracle redo logs (or undo tablespace) is another big wake-up too. And finally SQL Server 'locking' vs. Oracle 'read consistancy' (although SQL 2005 is slated to have read consistancy).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • February 11, 2005 at 1:42 pm

    #541889

    Its false, Oracle is not "rule based" by default. It is more sophisticated than that...

    On 9i it is "cost based" by default if you have the proper stats. If your stats are staled or you don't have stats at all, the Optimizer will "jump" in "rule based" mode. To "limit the damage" for you.

    So for me, if you are a DBA that gather stats at apropriate intervals, Oracle is "cost based" by default.

    Not sure yet but I think that whith 10g "rule based" mode is no longer there. So if you don't have good habits... .

    Carl

     

  • February 11, 2005 at 1:48 pm

    #541890

    David,

    an interesting book to read is :

    Oracle8i and Microsoft SQL Server Integration by Stephen Chelack

    Regards,

    Carl

  • February 14, 2005 at 1:07 am

    #541995

    Dave,

    found this in my link library

    http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

    Though it's originally the other way round, it might turn out useful.

    And finally:

    http://www.handels.gu.se/epc/archive/00002948/01/Nr18_MIB.pdf

    A comparison of SQL Server, Oracle and DB2 with Codd's rules. FWIW

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply