s******5
发帖数: 141 | 1 Want to be an oracle DBA in the future. Appreciate it if anyone can offer
some advices or a book list. Now I only know how to write simple SQL query.
Figure probably need to start from the developer side and learn how to write
PL/SQL.....Any good books?
pls, anyone know how to find some data for practice?
Thanks! | y****w
发帖数: 3747 | 2 begin with a database developer if you still don't have a job database
related now.
try this one:
http://www.amazon.com/Oracle-PL-SQL-Programming-Versions/dp/0596514468/ref=sr_1_1?ie=UTF8&qid=1289081604&sr=8-1
.
write
【在 s******5 的大作中提到】
: Want to be an oracle DBA in the future. Appreciate it if anyone can offer
: some advices or a book list. Now I only know how to write simple SQL query.
: Figure probably need to start from the developer side and learn how to write
: PL/SQL.....Any good books?
: pls, anyone know how to find some data for practice?
: Thanks!
| B*****g
发帖数: 34098 | 3 if you only know simple sql and if you are not to bad in programming, my
advice to you is learn java.
offer
query.
write
【在 s******5 的大作中提到】
: Want to be an oracle DBA in the future. Appreciate it if anyone can offer
: some advices or a book list. Now I only know how to write simple SQL query.
: Figure probably need to start from the developer side and learn how to write
: PL/SQL.....Any good books?
: pls, anyone know how to find some data for practice?
: Thanks!
| s******5
发帖数: 141 | 4 I just finished reading the book "Oracle PL/SQL Programming". I guess I need
to do some exercise now. Can anyone suggest some exercise material for
PLSQL? Many thanks! | B*****g
发帖数: 34098 | 5 kick, I haven't finished yet.
need
【在 s******5 的大作中提到】
: I just finished reading the book "Oracle PL/SQL Programming". I guess I need
: to do some exercise now. Can anyone suggest some exercise material for
: PLSQL? Many thanks!
| b*****r
发帖数: 239 | 6 As I know, DBA not need to know PL/SQL, but do need to write better SQL
query.
One part of DBA job is performance tuning. If you want o be a DBA, you can
spend some time on SQL Tuning, like understanding CBO optimizer, execution
plan, index usage, join, hint... etc.
.
write
【在 s******5 的大作中提到】
: Want to be an oracle DBA in the future. Appreciate it if anyone can offer
: some advices or a book list. Now I only know how to write simple SQL query.
: Figure probably need to start from the developer side and learn how to write
: PL/SQL.....Any good books?
: pls, anyone know how to find some data for practice?
: Thanks!
| y****9
发帖数: 144 | 7
If your goal is to become Oracle DBA, then you don't need to start from PL/
SQL, instead, you need to focus on Oracle core DBA skills. Check the online
documentation:http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm, for various DBA tasks. For exampls: Install and configure Oracle software, patching, upgrade; backup and recovery; manage users and prvilleges, create database and monitor database; performance tunning; move data; etc. Come to learn PL/SQL whenever needed to complete a DBA task.
Check the advice from Mr Huang Young is very relevant:http://yong321.freeshell.org/oranotes/OracleStudy.txt. Reading and practice are the keys. Check those Oracle video from www.boobooke.com to see how others practise a DBA topic in their test environment.
The book I recommended is: Tom kyte's Expert Oracle Database Architecture.
you can get e-book from http://www.boobooke.com/bbs/thread-75236-1-1.html
It is a great book for DBA and developer. Need to login to download. many
other oracle e-book in that site too. Buy a paper version is better: Amazon:
http://www.amazon.com/dp/1430229462?tag=asktom03-20&camp=14573&
Trying to get a Metalink account (now called My Oracle support) is also
helpful. Check this if you don't have one from your current job : http://www.bluegecko.net/oracle/how-i-got-access-to-my-oracle-support-mos-for-us2-67/
To land on the first Oracle DBA job in US, that's another story!. Bottom
line, you have to be very creative in marketing yourself. Remember the
purpose of resume is to get you interviews, it is how you perform at
interviews that will get you the job. Be very confident about yourself. Talk
, think, act and behave like a senior Oralce DBA with 5+ year experience.
How can you get experience (Jin Yan) without any job experience(Jin Li)?
Reading and practice! Learn from other people's experience by reading,
obtaining direct experience by practising. Prepare and remember various
Oracle DBA troubshooting stories as if they had happend in your working
environment and you had solved it. In short, fake it until make it.
After you gaining some confidence about DBA tasks by reading and practice
extensively, (depending on your background, could be anywhere between 1-6
months). Create a false name like: Tom, Mark, Jessica whatever, and
fabricate a resume ( to what extent really depends) with at least 5-years
experience (Jin Li). Submit your resume to some site like Dice, and get any
chance to be interviewed to demonstrate your knowlege and skills. You could
use the false resume to get a contract job through ICC at first. ICC does
not care your experience in your resume, they care if you can be sold to
their clients. Just be creative...
BTW, improving your English skill is also important. I have interviewed more
than 10 Oracle DBAs from ICC for my company's contract position last year,
it is really hard to find good Oracle DBAs though all of them claim 5+ year
experience. I only encountered one Chinese guy with absolute real resume (he
put his phd in mechnical engineering in the resume which I think is not
relevent, but based on that I believed he told the truth), and I have not
tested his technical skills as he worked more years as DBA than me and I
believed him. I sent him to the second round though I knew his English is a
shortcoming. My team leader immediatly gave him a call in the evening. But
my Chinese friend's spoken English is too bad, my team leader has to call me
in to do a 3-way conversation to understand what he says. Another reason he
failed was he just off a job and have not spend any time to prepare for a
techinical interview. You know who cares about those baisc interview
questions if you have been performing your day to day DBA routine for many
years?
Good luck to my fellow Chinese who are interested in Oracle DBA career! Hope
my advice helps.
【在 s******5 的大作中提到】
: Want to be an oracle DBA in the future. Appreciate it if anyone can offer
: some advices or a book list. Now I only know how to write simple SQL query.
: Figure probably need to start from the developer side and learn how to write
: PL/SQL.....Any good books?
: pls, anyone know how to find some data for practice?
: Thanks!
| y***t
发帖数: 644 | |
|
