Daimo B
Member
Registered: 20th Mar 00
User status: Offline
|
Mornings ladies and gentlemen. Need some help. Trying to learn SQL, but to do that I need a database of information. Poorly im using Access (don't think they will let me on our HR db  ) and just filling in a table of info.
As im learning the ropes here, the plan is to run a database, then design a web page, and use the search function on that web page to run SQL queries back to my database.
Easiest thing I could think of is films.
Can anyone list me any movie they know, i've only got 4 fields so fairly simple.
Movie Name:
Age Certificate:
Movie Type: (i.e action, horror, comedy etc).
Movie Length:
Can anyone help, anyone at home got a load of DVD's next to them? Fill me with info.
(PS, if anyones got any guides or notes on SQL from good training sites, pop them on too). If anyone wants a very good learning site im using to learn the basics, drop by...
http://www.w3schools.com/
|
Conway563
Member
Registered: 7th Jun 06
Location: Yate, Bristol
User status: Offline
|
Try IMDB.com for film info
|
Lawrah
Premium Member
Registered: 25th Dec 04
User status: Offline
|
and remeber to say when the 1st titties are shown in the film.. knocked up was funny.
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
Just google sample Access databases. You'll need a few different tables to learn the more advanced stuff......
|
Daimo B
Member
Registered: 20th Mar 00
User status: Offline
|
Yeah, relationships and such will come.
lawah?? eh??
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
I'd look into normalisation and a bit of database design too.
|
Daimo B
Member
Registered: 20th Mar 00
User status: Offline
|
Give me a chance, i've got SO much to take on as it is.
DB querying is first, but i need the DB to query from.
|
James
Member
Registered: 1st Jun 02
Location: Surrey
User status: Offline
|
I like SQL 
|
