Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase 12345»»»

We Need a DBA Boot Camp Expand / Collapse
Posted Tuesday, July 5, 2011 9:05 PM


Group: Moderators
Last Login: Today @ 8:12 AM
Points: 6,919, Visits: 2,203
Comments posted to this topic are about the item We Need a DBA Boot Camp

SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1136979
Posted Tuesday, July 5, 2011 9:47 PM



Group: General Forum Members
Last Login: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
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.


Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1136985
Posted Tuesday, July 5, 2011 10:42 PM



Group: General Forum Members
Last Login: Tuesday, August 25, 2015 12:32 AM
Points: 1,547, Visits: 1,918
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.
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1137003
Posted Tuesday, July 5, 2011 11:29 PM

SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:18 PM
Points: 4,684, Visits: 3,900
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.
Post #1137016
Posted Tuesday, July 5, 2011 11:45 PM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, June 14, 2015 6:49 PM
Points: 526, Visits: 561
1) Nope, although growing up on a dairy farm sometimes felt like one :P

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)
*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.
Post #1137022
Posted Wednesday, July 6, 2011 1:04 AM


Group: General Forum Members
Last Login: 2 days ago @ 11:17 PM
Points: 434, Visits: 636
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!
Post #1137045
Posted Wednesday, July 6, 2011 2:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 22, 2011 5:16 AM
Points: 213, Visits: 98

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.
Post #1137082
Posted Wednesday, July 6, 2011 5:24 AM


Group: General Forum Members
Last Login: Thursday, October 13, 2011 9:15 AM
Points: 480, Visits: 95
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.
Post #1137139
Posted Wednesday, July 6, 2011 5:59 AM


Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 19, Visits: 808
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.
Post #1137158
Posted Wednesday, July 6, 2011 6:07 AM


Group: General Forum Members
Last Login: Monday, June 15, 2015 6:06 AM
Points: 2,102, Visits: 509
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.

Post #1137162
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse