Exercise to practise SQL

Question

Post reply

Exercise to practise SQL

Viewing 15 posts - 16 through 30 (of 43 total)

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

vp-796294 SSC Journeyman Points: 76 More actions · Answer 1

Can you please list the name and ISBN of that book so that we can buy it. Thanks

vp-796294 SSC Journeyman Points: 76 More actions · Answer 2

Can you please give us the name , author, ISBN of the book so that we can buy it.

Thanks

VP

Jim Russell-390299 SSCrazy Eights Points: 9333 More actions · Answer 3

Here is the Amazon link:

http://www.amazon.com/Puzzles-Answers-Kaufmann-Management-Systems/dp/1558604537/ref=tag_stp_st_edpp_ttl

I didn't find the ISBN.

akshay.khatavkar SSC Rookie Points: 41 More actions · Answer 4

would be grateful if anybody could give me some url's where I can get good SQL exercise to practise sql queries and pl sql

Thanks in advance

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 5

You might do well checking out the T-SQL forums here, reading the first post and then trying to come up with an answer.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 6

I agree... you want practice? THIS is the place to get it. Lot's of books have the same ol' stuff and while they may be good for rank beginners, they don't teach you about real life. The questions people ask on these forums, regarless of how far fetched some of them may be, are real life.

It's also your chance to contribute to the betterment of fellow newbies across 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)

J-440512 SSCertifiable Points: 6285 More actions · Answer 7

This is getting ridiculous.

An author proposes one of his books and someone expects to have it for free ?

Why on earth would anyone bother with writing books if the author cannot justly be rewarded for his work ?

When I see a good book, I PAY for it. This is the only way I can be sure there will be more good books.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

J (11/3/2008)
This is getting ridiculous.
An author proposes one of his books and someone expects to have it for free ?

And expects it to be sent to him at the author's expense.

Scary thing it, it's not an unusual request to see....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

J-440512 SSCertifiable Points: 6285 More actions · Answer 9

Gila,

I posted this because I thought that seriously, the gimme types would have probably missed Dan's point.

SQLBill SSC Guru Points: 51440 More actions · Answer 10

It looks like the OP is looking for exercises for ORACLE not SQL Server.

Quote:

where I can get good SQL exercise to practise sql queries and pl sql

Bolding is mine for emphasis. Interesting how many people ask for Oracle stuff on a site dedicated to SQL Server.

-SQLBill

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 11

SQLBill (11/4/2008)
It looks like the OP is looking for exercises for ORACLE not SQL Server.
Quote:
where I can get good SQL exercise to practise sql queries and pl sql
Bolding is mine for emphasis. Interesting how many people ask for Oracle stuff on a site dedicated to SQL Server.
-SQLBill

Thanks, Bill... I totally missed that.

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

rishabh_186_batra Valued Member Points: 73 More actions · Answer 12

rishabh_186_batra

Valued Member

Points: 73

November 24, 2008 at 10:14 pm

#902887

http://www.a******.com

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 13

Yep... that's a totally useful post and link. Glad you were on 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)

GeorgeCopeland SSCertifiable Points: 6997 More actions · Answer 14

hi Joe I would like ur book too but don't email it to me I would like you to skywrite it plz. I live in Dallas.

Rajib Bahar Ten Centuries Points: 1067 More actions · Answer 15

The sqlzoo site contains web based simulator for sql query.

See http://www.sqlzoo.net

Good luck!

Rajib Bahar
http://www.rajib-bahar.com
http://www.twitter.com/rajib2k5
http://www.youtube.com/icsql