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 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.
