SQL Server Project

Question

SQL Server Project

sqlizer

SSCrazy

Points: 2120
More actions
May 2, 2008 at 2:04 pm

#190153

Can anyone pls suggest a project or two for the practice? Like building whole database from the scratch, with tables, views, stored procedures, triggers?
Really want to get hands on experience before entering the SQL Server market. Any reply with the detail information would be much appreciated.
Tried to find it on google but ended up with nothing.
Thanks all.

Viewing 11 posts - 1 through 10 (of 10 total)

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

There is a multi-part column at database journal called SQL Credit that walks you through the whole process from design to re-factoring.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 2

There are an unlimited number of ways to answer this. Now, when I started out years ago I created a Chess database with all of the procedures to play a game, hold the possible moves for pieces, etc... It may sound simple at first, but it is a good exercise.

So you could do something like that, or create a database for a video store. All the while, try to think off all of the things that would need to be kept track of. Movies, Customers, employee hours .....

Hope this gives you some ideas.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

sqlizer SSCrazy Points: 2120 More actions · Answer 3

sqlizer

SSCrazy

Points: 2120

May 2, 2008 at 3:41 pm

#810359

Thank You much Jason.

sqlizer SSCrazy Points: 2120 More actions · Answer 4

Thanks Jack. Looks like info you provided give me good insight.

Thanks again.

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 5

You want projects to practice on? Why go anywhere else... stay on this forum and start answering questions. You won't find a better or more diverse set of problems to practice on anywhere in the world. 😉

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

sqlizer SSCrazy Points: 2120 More actions · Answer 6

True. I have been answering the questions for quite some time.;)

Jeff Moden SSC Guru Points: 1004405 More actions · Answer 7

Not with 60 points in 79 visits, you haven't 😉

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

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 8

Volunteer to build a database for the local church, community group, Boy/Girl Scout troop, soup kitchen, community farm... Whatever. They can't pay you, but you can use actual user requirements to identify data, create normalized designs, procedures, reports... All with user feedback. That's a great way to learn and it helps someone.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ChiragNS One Orange Chip Points: 26137 More actions · Answer 9

Hi

If you have friends working on databases ask them if they can provide some general details regarding the projects they are working on. They could provide general details without divulging any specific information like name of the client etc...

This way you can practice on a "real" project. The work needs to be small enough for you to be able to do with limited resources.

"Keep Trying"

GSquared SSC Guru Points: 260824 More actions · Answer 10

MSDN.com has tutorials with walk-throughs for this kind of thing.

Volunteering to help a church or other charity is a good idea.

Another is to find something in your own life that could benefit from a database. Even if you don't need one, it can be a way to practice. Common examples are a database of the books, movies, CDs, MP3s you own. Simple to start, but can expand to an almost unlimited extent when you really start playing with it.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon