Oracle Training

Hey,

It looks like I'm going to have bit of time off over the next few months so I'm considering doing a couple of Oracle training courses that my local university is running. Because it's a uni funded course I'd get them pretty cheaply. The two courses are Oracle Programming in PL/SQL and Oracle Database Design and SQL. I've done a bit of oracle work before when I was doing my MSc but most of that has trickled out by now since I haven't used it in 4 or so years. What I'm really looking for is if anyone has done these and did they find them useful? Particularly coming from an admin standpoint more than as a database developer.

I'm mainly a server admin but I do a bit of database admin and I have seen a few roles come up that require database administration along with server admin skills.

My current certs are to the left and should finish up my CCNA in a couple of weeks. Will it be worth my while doing these?

Thanks for any input .

Comments

  • UnixGuyUnixGuy Mod Posts: 4,564 Mod
    I haven't done any of these courses, but as a server admin, Oracle DBA and administration courses should be more useful to you.

    The second course you mentioned "DB desing and SQL" sounds useful for administrators too. But I don't have experience in this.


    tenrou wrote: »
    Hey,

    It looks like I'm going to have bit of time off over the next few months so I'm considering doing a couple of Oracle training courses that my local university is running. Because it's a uni funded course I'd get them pretty cheaply. The two courses are Oracle Programming in PL/SQL and Oracle Database Design and SQL. I've done a bit of oracle work before when I was doing my MSc but most of that has trickled out by now since I haven't used it in 4 or so years. What I'm really looking for is if anyone has done these and did they find them useful? Particularly coming from an admin standpoint more than as a database developer.

    I'm mainly a server admin but I do a bit of database admin and I have seen a few roles come up that require database administration along with server admin skills.

    My current certs are to the left and should finish up my CCNA in a couple of weeks. Will it be worth my while doing these?

    Thanks for any input .
    Certs: GSTRT, GPEN, GCFA, CISM, CRISC, RHCE

    Check out my YouTube channel: https://youtu.be/DRJic8vCodE 


  • tenroutenrou Member Posts: 108
    I know what you mean about the administration part, but what I'm quite interested in is knowing how everything is done via sql coding.

    Take sql 2005 as an example, I do a bit of admin work on it but I use the gui, where as our proper dba does everything via t-sql and it seems the far more optomised way to do things. For example any sql agent jobs you setup have to be done in t-sql.

    From what I can see, even to do administration tasks you really need to know your t-sql/sql.
  • aaronchristensonaaronchristenson Member Posts: 261 ■■■■□□□□□□
    Have you found anyother resources for Oracle information. Other than the Oracle.com forums there are not many other forums out there that have info on 11G exams. I am currently working on the 11G OCA and so far I can say that the Oracle Press books are not very good at getting you ready for the exams. I am getting the Sybex book this week, hopefully it is a better read for the 2 exams in the 11G OCA.
    Aaron
    MCSE Cloud Platform and Infrastructure, MCSA Windows Server 2012, MCSA SQL Server 2012/2014, MCSA Windows 10, MCITP Server Admin, Security+, Virtualization with Windows Server Hyper-V and System Center Specialist
  • sambuca69sambuca69 Member Posts: 262
    tenrou wrote: »
    I know what you mean about the administration part, but what I'm quite interested in is knowing how everything is done via sql coding.

    Take sql 2005 as an example, I do a bit of admin work on it but I use the gui, where as our proper dba does everything via t-sql and it seems the far more optomised way to do things. For example any sql agent jobs you setup have to be done in t-sql.

    From what I can see, even to do administration tasks you really need to know your t-sql/sql.

    It's like what vbscript is to Windows. Yeah, you can do a lot via the Windows GUI, but the real power lies in being able to script out those tasks.
  • Kasey1Kasey1 Member Posts: 3 ■□□□□□□□□□
    thanks for sharing.it is useful and great for me
    clear.gif
Sign In or Register to comment.