1

(I tried posting to programmers.se but was told this might be a better place) My apologies if this isn't true

I've been a bit weary about approaching learning databases. I've dabbled into them before, and "DATA" in itself appeals to me a lot. Maintaining/searching/moving, everything about it in the abstract sense I love. (This isn't a career question, this is a learning question.)

But as RDBMS's begin to be easier to maintain, and with tools that "anyone" can use to manage data I feared for the database admin jobs. (Yet I see jobs for SQL everywhere!). I know "No-SQL" was a big deal but it kinda has its niche.

But that leaves me here... unsure of really "what" to study. What tools should I have in my tool belt?

I'm sure RDBMS's will be around in both use and maintaining legacy code. But what else? Obviously data will always be around, but is this a secure field or a dying one? And what should I be concentrating on?

1 Answers1

1

For development you should learn:

  1. SQL including optimizations
  2. DDL (table creations etc.)
  3. plpgsql, PL/SQL, T-SQL (native database language to write procedures and functions)
  4. good to know C, java, scripting languages
  5. jdbc how it works
  6. storage - how db store data and which solutions are faster then another
    ...

For administration
all above, scripting languages is a must
7. everything about operation system that you will work with
8. storage maintain
9. a lot of measure possibilities how server works (monitoring)
10. installations, upgrades - OS and db system
11. archive possibilities
12 high availability possiblities
13.....

and for both, a lot more things

About tools you have to know how to work with console very good in case that tools cannot connect at current time to db but you can connect to server itself. Other tools are usually database system specific.

sufleR
  • 678
  • 7
  • 18