Learning DB Management

If you forgot everything you know and had to learn it all again, how would you go about it?

I'm managing SolarWinds for my network team and have only the basic level knowledge about database management (I can understand what a SQL Query is going to do but I can't write one). I am starting from scratch so what resources, topics, languages, etc. would you utilize in my situation?

Parents
  • Caveat: I'm not a DBA, nor do I pretend to be a DBA, I only play a DBA on TV.

    I guess it comes down to one real question: what's your responsibility level when it comes to databases? Which spurs other questions.

    • Are you only responsible for the database that backs the SolarWinds Solutions, or are you going to be responsible for other databases as well?
    • Are you looking for a possible career change to be a data professional?
    • Because you are the de facto "monitoring person" is database responsibility going to fall into your lap?

    I had the advantage of taking a few T-SQL classes in university and some prior experience with MS Access (don't @ me).

    I, of course, would recommend all the DB things on THWACK, but were I speaking to me from the past...

    • Start with LinkedIn Learning. It's free or cheap (depending on your level of need).
    • Edit: I totally forgot about edX - which is also amazing for online learning.
    • Find a few people or blogs to follow.  My friend   is one such person. He's forgotten more about Database Management Systems (DBMS) that I have ever learned after 20+ years in IT.  Look for things like our #BackToBasics series on databases and follow influential writers in blogs (like Data Driven Blog ) who are authorities in the field. If they have their own blogs or social accounts, follow them there as well.
    • Learn enough to be dangerous. What I mean by that is to learn enough to understand what things could impact performance.  Depending on your need, you may not need to know every best practice, but having enough background to make logical guesses can get you far (in all tech things).
    • Consume everything you can but realize some things will go over your head - and that's ok. The best phrase you can learn in IT is "I don't know, but I can find out."
    • Acknowledge when enough is enough. You probably aren't looking to change careers, so realize that there will be a tipping point where your knowledge about databases is "good enough" to get you by. (Goes back to the "Learn enough to be dangerous" point.

    If anyone else has ideas, chime in.  Like I said at the start, I'm not a DBA, I only play one on TV.

Reply
  • Caveat: I'm not a DBA, nor do I pretend to be a DBA, I only play a DBA on TV.

    I guess it comes down to one real question: what's your responsibility level when it comes to databases? Which spurs other questions.

    • Are you only responsible for the database that backs the SolarWinds Solutions, or are you going to be responsible for other databases as well?
    • Are you looking for a possible career change to be a data professional?
    • Because you are the de facto "monitoring person" is database responsibility going to fall into your lap?

    I had the advantage of taking a few T-SQL classes in university and some prior experience with MS Access (don't @ me).

    I, of course, would recommend all the DB things on THWACK, but were I speaking to me from the past...

    • Start with LinkedIn Learning. It's free or cheap (depending on your level of need).
    • Edit: I totally forgot about edX - which is also amazing for online learning.
    • Find a few people or blogs to follow.  My friend   is one such person. He's forgotten more about Database Management Systems (DBMS) that I have ever learned after 20+ years in IT.  Look for things like our #BackToBasics series on databases and follow influential writers in blogs (like Data Driven Blog ) who are authorities in the field. If they have their own blogs or social accounts, follow them there as well.
    • Learn enough to be dangerous. What I mean by that is to learn enough to understand what things could impact performance.  Depending on your need, you may not need to know every best practice, but having enough background to make logical guesses can get you far (in all tech things).
    • Consume everything you can but realize some things will go over your head - and that's ok. The best phrase you can learn in IT is "I don't know, but I can find out."
    • Acknowledge when enough is enough. You probably aren't looking to change careers, so realize that there will be a tipping point where your knowledge about databases is "good enough" to get you by. (Goes back to the "Learn enough to be dangerous" point.

    If anyone else has ideas, chime in.  Like I said at the start, I'm not a DBA, I only play one on TV.

Children
  • Currently I am only responsible for the SolarWinds database but I see plenty of areas where we would benefit from having a database to improve our current tracking methods. I'm not necessarily looking for a career change, but I am looking to create my "niche" where I can benefit the organization in a way no one else can. There is a different office that manages our SQL servers and operate as DBAs but we work hand-in-hand enough that it would only benefit me to broaden my knowledge base in that way.

    Thank you for this!

  • Just to let everyone know,  is a unicorn.  That mythical creative who wants to be a responsible application owner.

    All joking aside, that's the "correct" answer. Any application owner should know enough about the database backing their system to be sufficiently knowledgeable to be authoritative.

    Regarding the databases behind the SolarWinds Self-Hosted Platforms, there are (*calculating...*) six that come to mind off the top of my head:

    Each of the above databases serves a different purpose and have been designed with that in mind.  If you have specific questions about any one of these, I'd highly recommend proposing questions in their respective forums (the groups are linked above) to ask anything directly associated.