needing made up info for databases

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

hi
i can't remember whether it was on this site but i remember seeing someone somewhere posting a web address that would give you made up information so that you can practise using databases and SQL code etc.

anyone know of this address please?

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Google you can't go wrong.

 

Google for "sample databases".

I don't know which RDBMS you plan on using, but MySQL has 3 on their site and I'm pretty sure Postgres has pretty much the same ones. SQL server comes with the Northwind DB and one other one that I can't recall off the top of my head.

 

wibblewibblewibblewibblewibblewibblewibblewibble....iggyiggyiggyiggyiggyiggyiggy !!!

that do ya ?

SQL Server 2000 Northwind & Pubs DB

SQL Server 2005 Adventure Sample DB

Knocking up your own database and data really isn't that hard either, or most dev books have some sort of example DB included.

 

thanks for your help. i tried googling but couldn't find anythign.

i've got SQL server 2003 from work and want to practice my SQL at home so i require a quite substantial database which link together so i can do corrolated subqueries etc.

making one up muyself would take years

 

aaah. i don't thin it was this site where someone posted the web address.
i posted the same question on another site i visit and they gave me these addresses

http://www.fakenamegenerator.com/


http://www.benjaminkeen.com/software/data_generator/

 

Well I guess if you're too lazy to type CREATE TABLE and INSERT INTO yada yada yada a couple times...

Automating this with a scripting language also wouldn't be that hard, thats all thoose sites have done. It depends what you want the data for, unless you are doing volume, bulk, performance testing etc its not likely that you need that.

For learning queries you just need a few rows.

 

naaa. a few rows isn't enough for me

 

Hmmmm.... You must have quite a close relationship with MS to have gotten your hands on that version of SQL Server. You're the only person I've ever seen that has it....

 

it's a deveklopers version according to my boss. i don't know what different types of versions there are to be honest but there you go

 

Well, I was referring to the fact that since the late 90's MS has only released 3 versions of SQL Server: SQL Server 7, SQL Server 2000, and SQL Server 2005. There was no SQL Server 2003....

Yes, I know it was a typo, but it was a pretty funny one, at least to my sense of humor....

 

ooooooh. i've written it down on my CD as 2003

 

LOL. Been there and done that too....

 

So I guess we're not talking about a genuine SQL Server 200x CD.

 

Sure it is. It's a genuine copy of a genuine disk....

 

as a developer the license gives me the right to use SQL server. it's not like buying multiple licenses for a product depending on how many computers your going to install it on.
you buy one license and that's it.

 

For the record, unless you have some sort of subscription from Microsoft, you don't get free use of SQL Server just because you're a developer...

 

Ummm..... I believe the developers edition of SQL Server is free. If I remember correctly in the 2005 edition it's called Express something or other.....

 

There's certainly SQL Server 2005 Express Edition, which can be downloaded for free... but it's not full-blown SQL Server 2005. Better than nothin', I guess. And you can't beat the price!

All that said... you don't have to be a developer to use it for free... it's freely available to anyone, and no license is required. Thus, my confusion regarding his comment.

 

I could be wrong about what the developer's edition is called in 2005, but in 2000 it was given away for free. You could do just about anything with it, you just couldn't use it in a production system. At least that's my memory of things. I haven't even looked at SQL Server for more than a year, so my memory could be wrong.