Oracle Training

tenrou

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 .

UnixGuy

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 .

tenrou

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.

aaronchristenson

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.

sambuca69

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.

Kasey1

thanks for sharing.it is useful and great for me