Results 1 to 10 of 10
  1. #1
    Join Date
    Jan 2005
    Posts
    5

    Question how could i change my role to a DBdeveloper?

    now i'm a Oracle DBA,what should i do or how could i do ,if i wanna to be a DB developer?
    i mean where could be my beginning of entering to the DB developement area?
    Any replies are appreciate.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i would start by developing an application against one of the databases you're currently adminning (if that's a word)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    rudy is right. You have to learn how to design a database to the needs of an application. You should learn about defining the scope of a problem with management, defining entities, work with analysts on creating ERDs, Normalization, Denormalization, you must also learn how to model for the environment your in. For example if your in a OO environment the techniques differ from traditional modeling.

  4. #4
    Join Date
    Jan 2005
    Posts
    5
    thanks for ur advices first.i know u mean that practical experience is critical to a developer,however i also wanna know that what knowledge should i prepare for developement.'coz i think there is a gap betweeen admine and develope, am i right?if yes,what knowledge&methods i should grasp before i do a practical case.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    first thing you should learn is entity-relationship modelling, followed by normalization

    personally, i think those subject areas are MUCH more interesting than raid stripes and cluster packs

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Jan 2005
    Posts
    5
    thanks! r937! And how about the PL/SQL? it's the general language for DBdeveloping?
    do u think it's difficult to study by myself? i just bought a PL/SQL book.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    as an oracle dba, you should already know pl/sql, but a good book can only help you

    yes, pl/sql is the language to learn for oracle -- it's actually a "superset" of oracle sql

    i would be very surprised, though, if your book spends a lot of time on entity-relationship modelling, which is what you should know to become a developer
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Do you intend to write code or to design a good database?

    If you want to write code you should know how to take a logical database design and denormalize it for performance into a physical database. Then you can write optimal code.

    If you want to design a good database you have to be able to create a logical database design. Then you can create optimal physical models.

    Either way you have to follow what rudy states. You have to understand data models to use them. PL/SQL is just another procedural language primarily developed to enable sequential processing of database rows.

  9. #9
    Join Date
    Jan 2005
    Posts
    5
    well, thanks both! certus,i think my choice is to design a good DB and i know i should begin with E-R. Actually presently,i just a newbie,my current role is just a junior DBA,i like my work.However i'm also interested in DB developing,so decied the direction where i'll go further is important to me.
    do u think it's possible that i could be a DBA and DBdeveloper? 1 person takes 2 roles.

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by alex1dream
    do u think it's possible that i could be a DBA and DBdeveloper? 1 person takes 2 roles.
    of course it's possible

    you could also do business needs analysis and project management

    i know several people who do all 4 roles, as they are the only "computer person" in their particular company
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •