Options

Choosing a DBMS to Learn

HofferHoffer Registered Users Posts: 5 ■□□□□□□□□□
in IT Jobs / Degrees
I would like to gather what DBMS you guys would suggest learning? Oracle, SLQ Server, etc. As a college student I am interested in perusing a career as a production DBA. I have had a class on databases and the topic comes up frequently in other classes/projects. In my database class we learned SQL and used Oracle, primarily working in SQL Plus and just wrote the SQL statements to create tables, run queries etc.

If you could point me in the direction of some good resources and books to learn the DBMS you suggest that would be great. Secondly, if you have any good books to recommend for me to sharpen my SQL skills that would be great. Within SQL I know the basics of making tables, basic queries, sub queries, and joins.
· Share on FacebookShare on Twitter

Comments

  • Options
    powerfoolpowerfool Member Posts: 1,666 ■■■■■■■■□□
    Oracle seems to pay the big bucks and SQL Server is pretty common. However, I would watch out for these new cloud databases; the model of their operation has flipped things on its head.
    2024 Renew: [ ] AZ-204 [ ] AZ-305 [ ] AZ-400 [ ] AZ-500 [ ] Vault Assoc.
    2024 New: [X] AWS SAP [ ] CKA [ ] Terraform Auth/Ops Pro
    · Share on FacebookShare on Twitter
  • Options
    RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    Hoffer wrote: »
    I would like to gather what DBMS you guys would suggest learning? Oracle, SLQ Server, etc. As a college student I am interested in perusing a career as a production DBA. I have had a class on databases and the topic comes up frequently in other classes/projects. In my database class we learned SQL and used Oracle, primarily working in SQL Plus and just wrote the SQL statements to create tables, run queries etc.

    If you could point me in the direction of some good resources and books to learn the DBMS you suggest that would be great. Secondly, if you have any good books to recommend for me to sharpen my SQL skills that would be great. Within SQL I know the basics of making tables, basic queries, sub queries, and joins.

    Please see the SQL Server forums for more information:
    http://www.techexams.net/forums/sql-server-exams/52826-mcitp-dba-2008-resources.html
    · Share on FacebookShare on Twitter
  • Options
    HofferHoffer Registered Users Posts: 5 ■□□□□□□□□□
    RobertKaucher wrote: »
    Please see the SQL Server forums for more information:
    http://www.techexams.net/forums/sql-server-exams/52826-mcitp-dba-2008-resources.html

    Would you suggest learning SQL Server over Oracle?
    · Share on FacebookShare on Twitter
  • Options
    RobertKaucherRobertKaucher Member Posts: 4,299 ■■■■■■■■■■
    Hoffer wrote: »
    Would you suggest learning SQL Server over Oracle?
    That's just what I work with. You could learn both pretty easily.I think SQL Server is a bit more common place, though, as it is used in most MS enterprise apps like SharePoint, etc. If you already have a good Windows background I would say go with SQL Server and grow into Oracle.
    · Share on FacebookShare on Twitter
  • Options
    SteveLordSteveLord Member Posts: 1,717
    MS SQL Server without a doubt.
    WGU B.S.IT - 9/1/2015 >>> ???
    · Share on FacebookShare on Twitter
  • Options
    N2ITN2IT Inactive Imported Users Posts: 7,483 ■■■■■■■■■■
    MS SQL Server or Oracle 11g or whatever the newest one is.

    Either of those two you are in good shape.
    · Share on FacebookShare on Twitter
  • Options
    jdancerjdancer Member Posts: 482 ■■■■□□□□□□
    If you are looking for a vendor-neutral database certificate, look at CIW Database Design Specialist

    I plan on taking the exam next month.
    · Share on FacebookShare on Twitter
  • Options
    petedudepetedude Member Posts: 1,510
    I'd say MS SQL is the best choice, but if you're tight for cash go after MySQL certs instead.

    Oracle's good, but the prep materials are pricey, the tests are expensive IIRC and there's a long path before you learn enough to really put good letters behind your name.
    Even if you're on the right track, you'll get run over if you just sit there.
    --Will Rogers
    · Share on FacebookShare on Twitter
  • Options
    phoeneousphoeneous Member Posts: 2,333 ■■■■■■■□□□
    SteveLord wrote: »
    MS SQL Server without a doubt.

    Agreed.
    · Share on FacebookShare on Twitter
  • Options
    erpadminerpadmin Member Posts: 4,165 ■■■■■■■■■■
    SQL Server is more common because the licensing for it isn't as ridiculous as Oracle's licensing. Not to mention that you don't need 20 applications (exageration) to manage SQL Server.

    It's not even the RDBMS you want to support but also the platform. Are you a UNIX fan? Then you'll want to deal with Oracle. Do you want to support Windows boxes? Then it's SQL Server. You also have other flavors like Sybase (yes boys and girls, it's still out there) and DB2 (IBM).


    The most important thing to do is just learn SQL. Syntax can come later.
    · Share on FacebookShare on Twitter
  • Options
    blargoeblargoe Member Posts: 4,174 ■■■■■■■■■□
    RobertKaucher wrote: »
    Please see the SQL Server forums for more information:
    http://www.techexams.net/forums/sql-server-exams/52826-mcitp-dba-2008-resources.html

    THIS. Robert has done a great job of putting together this list of resources. Follow it.
    IT guy since 12/00

    Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
    Working on: RHCE/Ansible
    Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands...
    · Share on FacebookShare on Twitter
Sign In or Register to comment.