SQL Server DBA 101 Presentations

Question

SQL Server DBA 101 Presentations

Adam Bean

One Orange Chip

Points: 26631
More actions
June 2, 2015 at 6:41 am

#301080

Hi all,
Preparing to do an intro to the life of a SQL Server DBA for a very junior level audience. I've done training prior, but more so geared towards developers or skill-sets that are more advanced. I have a group of interns that have no prior technical background that I'm having a hard time scaling back on the content delivered.
Anyway, before I re-invent the wheel here, was curious to if any of you may already have something that I could leverage to start from or have any online recommendations. The more I hunt, the more I'm finding sites that want to charge for the content.
If you have anything you could share, it would be most helpful.
Thanks!

Viewing 4 posts - 1 through 3 (of 3 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

This might probably won't help if you want something free, but the manga guide to databases explains databases in a great way for non-technical people and you could get ideas from there. The book is not expensive so you might want to try it.

Other than that, you have plenty of resources on this site, such as Stairways, books and videos. I'm not sure what would you want to cover on this training.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

You could see if Brent Ozar has anything that is licensed for general use. (I don't mean rip off his stuff, but he shares a lot of really good resources so it would be worth a look.)

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 3

My favorite "prop" for a true introductory class is a yellow pages telephone book. It even has a kind of B-Tree index in it.

--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)