February 7, 2014 at 11:17 am
Hi folks . . .
I'm working a still-relatively-new job (been here since late October) that uses a dual (or is it "duel"? 😉 ) database environment: SQL Server and Oracle; that is, it supports both databases.
I'm discovering just how much I have to learn about Oracle; a simple ad hoc query that I could write in five seconds in T-SQL can take me a couple of hours in PL/SQL, simply because I still haven't gotten used to the subtleties of Oracle syntax and the interface.
With that, can anyone recommend a decent reference for someone (namely, ME) who's had plenty of experience in SQL Server, but is just getting his feet wet in Oracle?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
February 7, 2014 at 3:33 pm
Perhaps it's not excactly what you are looking for, but I've seen a PPT from Gavin Payne. His last slide mentioned these references/reading materials:
Oracle 2-day DBA Guide (download)
Oracle – A Beginner’s Guide (Oracle Press)
Oracle for SQL Server DBAs (Oracle Press)
I myself liked the first one really well to get me on the way. Unfortunate (or happily ;-)) I have not worked with Oracle in a business environment, so I frgot a lot of what I've learned back then.
February 7, 2014 at 3:52 pm
Found the link to the presentation I mentioned in my previous post:
http://www.sqlbits.com/Sessions/Event7/oracle_for_sql_server_dbas
February 9, 2014 at 4:07 pm
Start with Oracle concepts. What is an instance, what are controlfiles, redologs, undotablespace, temptablespace, archivelogs.
You might consider Oracle Developer as free query tool
Basic troubleshooting tool for administration: sqlplus, couldn't get Enterprise Manager working most of the time.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply