We Need a DBA Boot Camp

  • Comments posted to this topic are about the item We Need a DBA Boot Camp

  • 1. Yes U.S. Army 1955 - during what was called the Korean Police Action, and received a 2nd Lts salary.

    2. I believe it would be an excellent idea for wanna be DBAs. The problems with it would be:

    a. Who pays the instructors?

    b. Who pays those attending?

    c. Those flunking have to repeat the training.

    Considering item 2, it might be possible to convert a SQL Saturday or include a track in each SQL Saturday and have it extend over 2 days (Saturday and Sunday).. not long enough but a start.

    Would Microsoft follow the example set back long, long ago by Hewlett Packard Co., where if your company desired to purchase a HP-1000 computer, you had to have one qualified, full time employee attend a week long training session. If the employee did not pass the final examination, the sales contract for the hardware would be declared null and void, and the cost of the weeks training deducted from the purchaser's down payment, which of course had to be included with the initial purchase order. But in these days I think that HP policy could/would not be adopted. Think of Microsoft refusing to sell the software for SQL Server under those conditions. Never happen.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Unfortunately, I did not get to attend any boot-camp trainings as I made my forray into the database world.

    That being said, I am a strong advocate in favour of boot-camp trainings ranging anywhere from 4 - 12 weeks (depending upon the complexity of the job at hand - a basic developer/administrator would not need more than 4 weeks to become productive, whereas a full-scale production DBA should need a higher period in the camp).

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • ad 1)

    Yes and no: yes, I made it through a military bootcamp in 1965, but no, it was not one for DBAs. There were no DBAs back then. 🙂

    ad 2)

    No, I do not think that a DBA bootcamp would be useful. The problem is that the database world is changing faster than the military world, and I doubt that any program pre-planned and sufficiently marketed program would produce graduates that have the skills required by the time when they hit the market.

    I mean, who feels qualified to design, in this July 2011, a bootcamp that would produce graduates with skills in demand in May 2012?

    Yes, there are the "eternal truths," such as "Back up the database before you tweak it," but you do not need a bootcamp to teach those.

  • 1) Nope, although growing up on a dairy farm sometimes felt like one 😛

    2) Yes.

    I think there are enough core concepts that you could make one:

    The ANSI Standard of SQL

    Schema Design fundamentals

    Backup regiments

    General maintenance concepts (such as data archiving)

    Basic performance tuning (the use of indexes)

    Data Warehousing

    Others that escape me for the moment...

    The only thing up for debate would be the time frame involved to list a person as competent.

    Advanced Specialities:

    The engine (MSSQL, Oracle, DB2, blah...) as they each have their own ways of doing some things (dates, OLAP Cubes, so on).

    Advanced performance tuning (traces and the like)

    ETL

    *insert endless list of stuff here*

    Although the technology speeds along like a freight train, there are enough slow moving items that you could do something formal.

  • 1. Kinda - Cadets for 2 years and they did cover most of the basic training.

    2. Absolutely. But it shouldn't cover any particular flavour of database, including SQL.

    I know that's taken as a Universal Standard these days, but I would rather they learn about 2 phase commit, what a log file is REALLY for, how to normalise a database (and when not to), what we mean by Data Security, and why no application developer should ever be allowed access to the raw database tables (ok - maybe that one is stretching!).

    There are hundreds of websites out there that will tell you the duties and responsibilities of a DBA, and they all have a different view. But there are a core set which should be covered.

    What I would hate to see is for it to get hijacked by vendor X with specifics about "we do this like this". That's not the point!

  • Hi

    I'm not sure which format you envisage this having but the idea is a brilliant one. I've spent 6 months searching for a site that would give me the knowledge I wanted and a sense of other people being out there and experiencing the same situations. So now I found it hallelujah! 🙂

    I think if you could break a 'bootcamp' into a series of 101 seminars, whether they be recorded webinars or just articles with maybe some follow-up exercises, this would be seriously helpful to those of us starting off or even to someone who has done it for some time but isn't sure if they've covered all bases.

    Anyway way to go! Please do this ... if you want help proof-reading or running through exercises I can do.

  • 1. No boot camp for me, but I always thought the challenge of it sounded interesting even if military service never did.

    2. I don't think the boot camp model works for DBA's. The reason is that boot camp is also known as Basic Training. They take in a crowd of people and train them on the basics they need to know. You're not going to get an expert out of basic training, and a DBA should be an expert (IMHO).

    A DBA boot camp would put out entry level database workers, not DBA's. Most employers (maybe all?) aren't going to be to keen on sending their entry level database workers out on 12 weeks training.

    As a tool to make sure experienced DBA's know everything they should, it might have some merit, but I would imagine by that point most DBA's would be sitting through a lot of classes covering stuff they already know in order to learn a few things they didn't.

    With that in mind I think having individuals seek out the training that they need is probably the better route.

  • 1) Yes, 1994.

    2) The idea sounds appealing. The point would be to say that anyone who graduates the training program has the same set of definable skills and knowledge. It's a standardization process. The downside to this idea is twofold: one, who sets the standards; and two, who manages the program, including changes and updates to the training process.

    I think the advantage would be to the employers, because they know what they are getting.

  • I think DBA boot camp would be beneficial, but who has 6 to 8 weeks. Only really large companies that already have a bunch of DBA's could afford this. I would say only a few mid-size companies and probably no small companies could live with an employee being gone for that long.

    So my suggestion, here is your money making idea, Why not an on-line program? Perhaps with pod casts, to help instruct through difficult subjects. Then the soon to be DBA would be able to take the course at their leisure. It would make sense to have some quizzes and tests to ensure the student was tracking.

    Ben

  • 1. Yes, 1960

    2. Might work. In 1969, I started working for Farrington Electronics, in Springfield, VA. They had started manufacturing OCR systems. After a break-in period, I was sent to the new 16 week school for Field Engineers for the OCR Page Reader System. Included Varian Associates 620i 16 bit computer, 9-track tape deck, Teletype with paper tape punch and reader, the Page Reader, and the logic rack to turn mechanically scanned OCR-B images into ASCII or ECBDIC characters.

    Total immersion. We learned machine language and then Assembly language programming (2 weeks), the computer logic (2 weeks), the rest on the mechanics and electronics of the system components.

    The final exam was a practical exam. The instructors sabatoged the system, and each individual was given one work day to get it running again. Nothing was off limits.

    Very good training, but 16 weeks of salary for each student, plus instructors, plus overhead costs...

    Rich

  • 1) That's affirmative - 1971 during the latter part of the Vietnam war. ('Platoon' was a pretty accurate depiction of life in the US Army during those days).

    2) No, I don't think you can "make" DBA's like you can "make" Marines or Army soldiers. The best DBA's get that way because they have years of experience including software development and really understand relational database and multi-tier architectures.

    Taking the military analogy to its logical conclusion: good DBA's are like Generals and Generals don't pop out of boot camp in 8 weeks. (You might get a promotion from private to private First Class though;-))

    That's my $.02

    The probability of survival is inversely proportional to the angle of arrival.

  • I like Ben's idea to have this online. We'd each be responsible to prepare our own boot camp infrastructure and doing that would be part of the training itself. I think two aspects are important: 1. Prepare to take certification exams. 2. Boot camp should be scenario based - emphasis on lab work and problem solving. Why not multiple boot camps for different technologies? (SQL Server, Oracle, open source). Training materials could be developed by volunteers... so, an open source training program.

    One approach is to have targeted boot camps. For example one for each of the major topics of the SQL cert exam 70-432:

    1. Installing and Configuring SQL Server 2008

    2. Maintaining Instances

    3. Managing Security

    4. Maintaining a SQL Server Database

    5. Performing Data Management Tasks

    6. Monitoring and Troubleshooting

    7. Optimizing Performance

    8. Implementing High Availability

    Not everyone is interested in certification but the objectives offer an established syllabus. And yet for those who want to certify, you'll be better prepared.

  • 1) Yes... 1984 US Army, C Company, 2nd Platoon, Tank Hill, Ft. Jackson SC.

    2) Yes... Actually been to three of these. Two of them at the Dallas, TX M$ Canal campus in the 90's.

    1. Data Storage Systems Summer Camp 1982. This thing should have been fun for the young Geek. Unfortunately it was two weeks of siting in a hot room filled with ti Trash 80's fixing the mistakes in someone Senior Project.

    2. NT 4.0 SysAdmin Boot Camp. Learned scripting and how to install SQL Server 6.5.

    3. Front Page 98 Admin boot camp. Was not called a boot camp but felt like one. Three days of trainning with members of the MS Front Page hosting support team. We needed to do hosting for a Reports Web site using Front Page ( This was pre SharePoint )

    All of this training I paid for out of my own pocket. It has all payed for itself several times.

  • U.S. Navy boot camp in 1975. It was nine weeks of the same things drilled over-and-over. We learned, but, we learned very little; just the basics. I had to attend a six month specialized school after boot camp. Even then, I was barely ready for the fleet.

    I doubt this would work for technical knowledge. How much would be retained? The real learning comes with experience. Sure maybe you could lay down a base set of knowledge like who E.F. Codd was and the normal forms; keys, backups, etc. But to call someone a DBA with no experience is a bad idea.

    Then there is the cost and time. I doubt there would be many who would have enough of both.

Viewing 15 posts - 1 through 15 (of 41 total)

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