Post reply

Need SQL Training Recommendations

  • April 6, 2017 at 8:13 am

    #1937052

    Hi James,

    Just to chime in with how I got started...

    I got hold of a SQL Server Developer edition (they're free now) and started playing and practicing stuff at home. Trying things that I either didn't have access to do, or the confidence to do, with real work data. It still helps me out now to get the proof of concept in Developer before I apply it to work.

    Make loads of mistakes and figure out how to fix them (but not with production data!) - The more mistakes I make, the better as long I'm learning.

    When I began I quickly realized that SQL Server is VAST, which I found compelling and terrifying in equal measure. I began trying to immerse myself, even thought I felt like I knew very little. Reading the SSC daily and Database Weekly enewsletters and went out of my way to go to some conferences in my own time. My idea was that while most of it was going to go over my head, some would sink in. (and it still is!) 
    I remember the first SQL In The City I went to, I thought I'd get busted as being an imposter!

    Definitely check out any online video tutorials by: Grant Fritchey, Itzik Ben-Gan, Brent Ozar and Kendra Little.

    Post questions here.

    Good luck!

    Lins

  • April 6, 2017 at 12:11 pm

    #1937105

    james.mobley - Monday, April 3, 2017 9:36 AM

    Yes, it is going to be very challenging. That's why I have been so thankful for all the suggestions that I have received here. It wasn't the companies fault that the DBA lost his clearance, he did something that all cleared individuals know not to do. As far as time to get a clearance, it's currently taking a little over a year. It's not the normal stuff that everyone and their brother has in the US. Luckily the DBA was doing a very good job; everything has backups, and all is in running smoothly. I knew the guy, he is a great guy. Just made a bad decision.  Again, thank you for all the recommendations, sounds like I'm going to need them.

    Man, that's a real shame.  As you know, good DBAs are hard to find.

    Good to know about the time it takes to complete an atypical elevated security clearance nowadays... it didn't use to take anywhere near that long.  You would think that with the advent of these new fangled things called "computers", it would take a whole lot less time to discover undeclared relationships for purposes of interview and the like.  On second thought, maybe that's the reason... tons more interviews because of such discoveries.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply