question

mikeofei avatar image
mikeofei asked

looking for sample project senarios

I have learnt alot about SQL 2008. Now I want a practical senario to help me practice as if I am in a DBA role and I am to provide a solution from scratch. Can some one help me with where to find one?
administration
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
What sort of thing do you want to practice on, this is a vast subject.
5 Likes 5 ·
mikeofei avatar image mikeofei commented ·
Thanks guys I get what you mean, its a vast area. Ok here is what i want to do. I want something like a company calls you as a consultant and tells you how they operate. Now they need a database to run the company. So you are to design and implement the database according to their business rules. Thats what i am looking for. I could guess or create one myself but I keep changing the challenge to make it easier for me so i was thinking i could get a script or senario from some where and work to satisfy them. example create the database, tables, logins, views etc just like creating the adventure works from scratch
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered
You work for the AdventureWorks company. * Someone has just deleted all the sales data because they forgot a WHERE clause. How do you sort it out? * They are opening up a new office in Kuala Lumpur - how do they handle DR? * They need information on what a reasonable setup would be in terms of disks & storage for a future expansion - what information do you provide them? Another one to go through would be the SpeedPhreak competitions on this site. They will give you a good start in performance tuning. But really, like @Mrs_Fatherjack says, it's a vast subject, and I'm doing the equivalent of using a fridge magnet to find a steel drinks can in the pacific ocean.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
I'm with @Matt Whitfield on this - it's a vast subject area. However, one thing to consider is monitoring the health of the SQL Server environment - it's always required, but yet so many DBAs have differing ideas about what's important.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack avatar image
Mrs_Fatherjack answered
I would suggest that you use something you know about, for example if you are into Films, you create a database to review them or something similar, then you can design your database around that. Before you start you need the requirements and a specification documenting what the database needs to do, then you should produce a functional specification to show the actual table structures including indexes etc, once this is all complete then you can start creating it. This isn't something really, that someone here can do for you, I am sure if someone disagrees they will shout. But that's how I'd handle it.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
Look around. There are thousands of companies all over the place. Design a database to support Amazon, Apress, OfficeMax, Red Gate, Microsoft, Plantronics, Logitech, Apple, Yomega (and yes, I'm glancing around at stuff on my desk). If all you need is a set of business requirements, they're everywhere. Yes, it won't be the same as the pulling teeth operation that getting requirements really is, but it'll give you some practice in that regard. The other thing I always suggest, find a local non-profit, a church, Scout unit, soup kitchen, that needs a database. Build that for them based on their requirements. That will also get you to set up backups and maintenance, if you want, monitoring.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
This answer is a variation on a theme in others but just to say if you do it based on something you know - your DVD collection, your family and contact detail etc - then you will have some interest in the data and will learn how to correlate the database to the actual data subjects. If its DVDs then you will see that a clustered index by title relates to the DVD order on the shelf by title and that having them like that makes you scan the whole shelf for the films by a certain director or actor or genre. Seeing this physically can make your understanding deeper and easier to take on board. To match your additional comment on your question, you simply assume that the local DVD rental shop has asked you to do it. This now allows you to incorporate multiple copies of the DVDs, a rental/booking process, borrowers details, purchasing etc etc
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
Please note that's not me!!
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
DVDs in order on a shelf? Freak...
0 Likes 0 ·
Mrs_Fatherjack avatar image Mrs_Fatherjack commented ·
You jest!!!
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I've got mine alphabetized. I used to have my books split out by the dewey decimal system and alphabetized. We moved 12 years ago and I still haven't rebuilt the system.
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
they are until #1 'borrows' some and then it all goes to pot!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.