July 15, 2011 at 8:21 pm
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 16, 2011 at 4:24 pm
Looking for a few kind folks to look over an article before I submit it. Please PM me your email address if you'd like to help out. The article is on the OVER clause enhancements in Denali CTP3.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
July 16, 2011 at 10:58 pm
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
Very, very cool. If you good folks will have me, count me in. I can certainly do presentations via some form of a web meeting... it's a bit tough for me to travel because I don't have a lot of time off available. With the right incentives, though, I could do a Saturday boot camp and, no... I'm not talking about an hour long presentation. I can easily come up with a 2 to 4 hour presentation of several 1 hour long presentations.
Let me know. I'm excited about this.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2011 at 2:40 am
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
... and if you ever consider to get global, I'd be happy to be your German representative!
July 17, 2011 at 11:16 am
GilaMonster (7/14/2011)
Steve Jones - SSC Editor (7/14/2011)
Probably is a lot more than 1kb. There's a lot of stuff that comes down from every single forum, along with a bunch of JS. I'd have to play around with some pages. Might not be 100kb, but I'm guessing it's dozens of kb.Maybe when you get back from the UK we can test it out for a couple days, see what the overhead is and how bad it is?
Yep, let's pick a day and turn it on
July 17, 2011 at 11:26 am
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
This is some of what Andy has done with SQLShare, with custom training classes, but they're more basic, not in depth.
If you wanted to write stuff here, I think it would be great to build the community content and then release it both as presentations that you could share with each other and give to user groups/SQL Saturdays, as well as potentially video stuff. We are always looking for people to shoot some online video stuff for SQL Share.
July 17, 2011 at 11:29 am
Jeff Moden (7/16/2011)
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
Very, very cool. If you good folks will have me, count me in. I can certainly do presentations via some form of a web meeting... it's a bit tough for me to travel because I don't have a lot of time off available. With the right incentives, though, I could do a Saturday boot camp and, no... I'm not talking about an hour long presentation. I can easily come up with a 2 to 4 hour presentation of several 1 hour long presentations.
Let me know. I'm excited about this.
I see two ways of approaching this. One would be a community effort, a free for usage web training structure that would be as holistic as possible from the ground level up. This would be aimed at individual people who want to train themselves.
The other is a company that trains accidental DBAs targetting the businesses, not the users, as their primary customers. Bear with me. A business wants a certain level of comfort that there is at least a baseline of knowledge in an employee. In particular, the accidental DBAs, the upgraded Access to SQL Developer, etc. What I had in mind here was a boot camp of probably two weeks with a full practical on the tail, honestly graded, and the company informed of the results of both the participant and the spread for that class, to prove the training was successful for enough of them, if not one particular person. Of course this will take some refinement in the beginning. That's why they're getting the opening day discounts.
I'm thinking two tracks, one which would be administrative in nature, another that's developer in nature. Of course there's some crossover, but honestly, not so much that you'd want to tackle both from the beginning in a boot camp. Two weeks, in my opinion, is about the minimum it would take to cover enough information. Some people might be able to one week it but I don't think that's enough time to let it soak, just to memorize. I can see this as easily expandable because the level of these courses aren't Grant Fritchey/Paul Randall level of depth, and a mid-II could easily be hired to follow the material, and answer the questions newbies will have.
Jim shot me over a rough syllabus and some ideas on what may already be out there, since he's done the research already. At least some of it. I'm still reviewing that material. Once I can get a better handle on some of the other material that's out there for self-training, I'll start up a thread dedicated to the idea, and post the link here. I'll share my findings and what my opinion is for a starting point, and we can work from there.
Steve, if we do a community project like this for free consumption, would SSC be interested in hosting it? It would probably fit nicely into the stairway series but instead of being single topic it would be a more organized training series. The business side of this endeavour I'll be over *there* working on, but it would appear that there's a lot of interest in the free series as well.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 17, 2011 at 11:43 am
Brandie Tarvin (7/15/2011)
The best training I've come across is offered by Four Deuce (http://www.fourdeuce.com/training/publicclasses.aspx).
Brandie, my apologies, I didn't mean to completely skip this, and somehow I did. I reviewed the site, and it would appear they have no upcoming scheduled classes. They may still be doing custom work but it would appear that primarily it is just a video series.
Though, it makes me wonder the value here, and if there's enough real demand.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 17, 2011 at 5:08 pm
The Dixie Flatline (7/15/2011)
If someone comes around [a] place of work with a baseball bat and says "Nice little database server you got here... be a shame if something should happen to it.... gimme some money."
But isn't this what all DBA's do during the interview process?? 😛
Steve.
July 17, 2011 at 8:20 pm
Fal (7/17/2011)
The Dixie Flatline (7/15/2011)
If someone comes around [a] place of work with a baseball bat and says "Nice little database server you got here... be a shame if something should happen to it.... gimme some money."
But isn't this what all DBA's do during the interview process?? 😛
Steve.
Nope... I take care of that little nuance BEFORE the interview. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2011 at 8:28 pm
Craig Farrell (7/17/2011)
Jeff Moden (7/16/2011)
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see much when I went browsing, though I saw a lot of high level type of classes. I have both a need to ship someone to one and my eyes are seeing dollar signs with opportunities.EDIT: I should mention, we're talking what the different joins are, what's a clustered vs. non-clustered index, how to read an execution plan, why you control data types, what's a deadlock... that kind of thing. REAL basic, intro to databasing kind of stuff.
I had exactly this opportunity handed to me a little while ago. I created a basic indexing presentation to train a small group, shared it a couple places and was asked by one company to start a regular brown-bag seminar series. At first I picked random topics that dealt with what I knew best or what they were confronting at the time, but recently cooked up a more logical sequence of classes and teach the first one next week. I love it, am way excited, and interested in collaboration if you guys will have me.
Thanks,
Chad
I'd like to get involved in this type of endeavour as well.
Maybe some of us could band together, help write out different lessons, and all can benefit from it? This would be something pretty good, and I'd like to be a part of this also.
How do you'll feel about this?
Very, very cool. If you good folks will have me, count me in. I can certainly do presentations via some form of a web meeting... it's a bit tough for me to travel because I don't have a lot of time off available. With the right incentives, though, I could do a Saturday boot camp and, no... I'm not talking about an hour long presentation. I can easily come up with a 2 to 4 hour presentation of several 1 hour long presentations.
Let me know. I'm excited about this.
I see two ways of approaching this. One would be a community effort, a free for usage web training structure that would be as holistic as possible from the ground level up. This would be aimed at individual people who want to train themselves.
The other is a company that trains accidental DBAs targetting the businesses, not the users, as their primary customers. Bear with me. A business wants a certain level of comfort that there is at least a baseline of knowledge in an employee. In particular, the accidental DBAs, the upgraded Access to SQL Developer, etc. What I had in mind here was a boot camp of probably two weeks with a full practical on the tail, honestly graded, and the company informed of the results of both the participant and the spread for that class, to prove the training was successful for enough of them, if not one particular person. Of course this will take some refinement in the beginning. That's why they're getting the opening day discounts.
I'm thinking two tracks, one which would be administrative in nature, another that's developer in nature. Of course there's some crossover, but honestly, not so much that you'd want to tackle both from the beginning in a boot camp. Two weeks, in my opinion, is about the minimum it would take to cover enough information. Some people might be able to one week it but I don't think that's enough time to let it soak, just to memorize. I can see this as easily expandable because the level of these courses aren't Grant Fritchey/Paul Randall level of depth, and a mid-II could easily be hired to follow the material, and answer the questions newbies will have.
Jim shot me over a rough syllabus and some ideas on what may already be out there, since he's done the research already. At least some of it. I'm still reviewing that material. Once I can get a better handle on some of the other material that's out there for self-training, I'll start up a thread dedicated to the idea, and post the link here. I'll share my findings and what my opinion is for a starting point, and we can work from there.
Steve, if we do a community project like this for free consumption, would SSC be interested in hosting it? It would probably fit nicely into the stairway series but instead of being single topic it would be a more organized training series. The business side of this endeavour I'll be over *there* working on, but it would appear that there's a lot of interest in the free series as well.
Ummm... isn't MCM only two weeks long? What's the difference between what is being proposed and a cert from Microsoft? I was thinking more along the lines of a one-day (long day) course to quickly get someone up and running... not a two week "death march" on the basics that no company would ever pay for especially since they don't get an MS cert out of it.
Don't get me wrong... I'm not pushing MS certs. 😉 That's been tried before and failed.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2011 at 8:48 pm
Jeff Moden (7/17/2011)
Don't get me wrong... I'm not pushing MS certs. 😉 That's been tried before and failed.
Jeff - what's been tried and failed:
A) 2 week death march on basics.
B) 1 day beginning course.
C) ms cert course.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
July 17, 2011 at 9:08 pm
Jeff Moden (7/17/2011)
Ummm... isn't MCM only two weeks long? What's the difference between what is being proposed and a cert from Microsoft? I was thinking more along the lines of a one-day (long day) course to quickly get someone up and running... not a two week "death march" on the basics that no company would ever pay for especially since they don't get an MS cert out of it.
Don't get me wrong... I'm not pushing MS certs. 😉 That's been tried before and failed.
MCM yes, but that's with the assumption you arrived with a tremendous amount of knowledge already.
Do you honestly think in 8 hours of training you can get a from scratch IT employee to a working (Junior) DBA? I'm thinking of the CS graduate who looks at a database as an overdeveloped CSV file here. Mind you, I mean not just to shove the information down their throats, but get them to understand it? If you can, I'll be there with bells on, because I just can't see how to do it.
The biggest problem with MS Certs is they're not practical labs, but simply regurgitation. Knowledge without functionality, at least until the MCM.
As to that, this is, at least to me, two different projects. One's the free one that the community seems to be interested in. I'm trying to get that organized at the moment for a more coherent discussion. The other is a business I'm debating on, and that's going to take a ton more research on demand, pricing, business law in regards to MS Products, a number of other things, and I wouldn't presume to use the community's offerings in something like that... well, not without discussion and payment.
I see a value to it, the question from a business perspective is do businesses? Different story. A coherent end-to-end training course online may null and void the need for it for those who can self-train. Do I know if I have a solution? No clue, ask me in 5 years. 🙂 (Well, alright, 2. This isn't an overnight thing.)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 17, 2011 at 9:49 pm
Jim Murphy (7/17/2011)
Jeff Moden (7/17/2011)
Don't get me wrong... I'm not pushing MS certs. 😉 That's been tried before and failed.Jeff - what's been tried and failed:
A) 2 week death march on basics.
B) 1 day beginning course.
C) ms cert course.
None of the above. I was referring to a special cert that some of the folks on this thread know about. It was valiant effort.
I certainly could be wrong but A) just seems impractical to me. There's no cert at the end of the tunnel (and it would take a while to earn a reputation of producing HQ DBA's) and most accidental DBA's can't get a company to give them 2 weeks paid training leave.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 17, 2011 at 9:54 pm
Craig Farrell (7/17/2011)
Do you honestly think in 8 hours of training you can get a from scratch IT employee to a working (Junior) DBA?
No... of course not. But I thought we were talking about "accidental DBA's" who at least knew what the difference between a Backup file and a Log file was. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 28,066 through 28,080 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply