| View previous topic :: View next topic |
| Author |
Message |
Puggle
Tufted Titmouse
Joined: Dec 21, 2008
Posts: 34
|
 Posted: Sat Jul 04, 2009 6:58 am Post subject: Learning about databases - where to start? |
 |
|
I'd like to make a program or something that can store information in a way that can link things to other things, and can be searched.
It's a kind of vague concept, and I don't know how to explain it properly.
If I used my work as a practice example, I'd like something where I can store details about products and information about customers and be able to search for combinations of things (eg, how many of product X did we sell in January, how much have we bought from supplier Y). At my work, all that sort of info is stored on paper, so it's difficult to get any statistics without a lot of digging through invoices.
I wouldn't be confident enough to develop a program for actual business use, but I just want to know how to do it. I tend to store information about things, but it's no good hoarding info if you can't actually find what you need when you need it.
I know a little HTML but it's been ages since I've done any other coding. I'm happy to learn new programming languages but I don't know where to start. Any suggestions? |
|
| Back to top |
|
DarrylZero
One Cool Gumshoe
Joined: Jun 05, 2009
Posts: 1708
Location: Undercover...don't tell anyone! Shhhh
|
| Posted: Sat Jul 04, 2009 1:08 pm Post subject: |
|
|
Do you have MS Access? That's the database program I use at work. It's pretty easy to use. There are wizards that can guide you in setting it up. I've learned a lot just using the Help function with certain areas. I'm much more comfortable with Excel so I usually set up an Excel workbook to import data from Access for analyzing data. If you want to get more advanced and do some cool things you can learn VBA code and program the database to do specific things.
If you don't have Access there is a suite of programs called Open Office (I think that's what it's called). It's basically a free version of MS Office and is supposed to operate, function, and be compatible with MS Office. I haven't used it but I know they have a database program based on Access. |
|
| Back to top |
|
jmr
Tufted Titmouse
Joined: Jun 26, 2009
Age: 29
Posts: 35
|
| Posted: Sun Jul 05, 2009 8:34 am Post subject: Re: Learning about databases - where to start? |
|
|
| Puggle wrote: | | I'd like to make a program or something that can store information in a way that can link things to other things, and can be searched. |
Isn't it fortunate that some forward thinking individuals have already done this for you!
| Puggle also wrote: | | I'm happy to learn new programming languages but I don't know where to start. Any suggestions? |
lol SQL. Here is about 50 books on the subject for free. |
|
| Back to top |
|
ruveyn
Phoenix
Joined: Sep 22, 2008
Age: 73
Posts: 4794
Location: New Jersey
|
| Posted: Sun Jul 05, 2009 11:22 am Post subject: Re: Learning about databases - where to start? |
|
|
| Puggle wrote: | I'd like to make a program or something that can store information in a way that can link things to other things, and can be searched.
It's a kind of vague concept, and I don't know how to explain it properly.
|
In relational databases the operation that links data in different files is called the Join operation. Pick up any standard textbook on relational databases. Learn the SQL language to operate with relational databases.
See: http://en.wikipedia.org/wiki/Relational_database
ruveyn |
|
| Back to top |
|
pakled
"Bless his Heart"
Joined: Nov 13, 2007
Age: 52
Posts: 6727
|
| Posted: Sun Jul 05, 2009 1:28 pm Post subject: |
|
|
Another Access user here (what is it with AS and organizing things?...
I started out with something called Rapidfile - ancient orphanware, was the 'low end' offering for Ashton-Tate's Dbase III... Runs under DOS, does just simple listing. It's actually still out there, and free..
From what I'm seeing on the job sites, they're looking more towards SQL than Access, but there are still calls for it. If you want some free Access training, Goodwill (of all places) has a computer training site that will get you started in Access 2003 or 2007 (depending on your budget).
www.getlearnfree.com
there's other stuff there...it's on a really basic level. Won't get you hired anywhere (well, maybe.. but if you want to enhance yourself, it's a good place to start. |
|
| Back to top |
|
Aoi
Phoenix
Joined: Jul 17, 2009
Posts: 606
|
| Posted: Fri Jul 17, 2009 11:42 pm Post subject: |
|
|
MS Access is a good choice for this project idea of yours. I don't do databases, except when necessary, but built several for clients years back , and maintain a few of my own for various purposes.
Don't forget about your local library. Mine has dozens of books on SQL and Access, as well as books on Open Office. Tutorials abound online, as well as podcasts and vcasts free from the iTunes store or other sources of podcasts. |
|
| Back to top |
|
Puggle
Tufted Titmouse
Joined: Dec 21, 2008
Posts: 34
|
| Posted: Sat Jul 18, 2009 3:37 am Post subject: |
|
|
Thanks guys. I've had a bit of a play with Access and that should be good for now. If it's a long term interest (not just the latest sparkly thing to catch my attention) then I'll look into SQL. 
_________________
"We know that when you're careless, it's not because you don't care." |
|
| Back to top |
|
showman616
Snowy Owl
Joined: Feb 09, 2009
Posts: 161
|
| Posted: Thu Sep 03, 2009 11:23 pm Post subject: |
|
|
every apple computer built in the last almost 20 years has had a built in data base program- usually as a word processing option.
I would assume that PC do as well- if not there must be windows programs that you can buy to install.
Im a party disk jockey. And have used the built in programs of the last three generations of apple home computers to created fabolous data bases for the music in my some thousand CD collection.
I can call up music by song title, artist, category of music, what CD the song is on, etc. |
|
| Back to top |
|
peterd
Velociraptor
Joined: Dec 26, 2006
Age: 57
Posts: 440
|
| Posted: Fri Sep 04, 2009 4:12 am Post subject: |
|
|
My current hobby horse is an XML database called eXist
It's a sweet little thing. The information you want to store goes in as an XML document - that's right, a plain text document. To get stuff out of it you write an XQuery. That's right, another plain text document, and you treat it the same way as the information.
That's it. You type the path to the XQuery in the browser, or write a link to it in your menu, and the job's done.
All W3C standard, all open source. Pearls beyond price. If you mix it with a little Javascript library called JQuery it will stand on its head and dance. |
|
| Back to top |
|
LordoftheMonkeys
Hummingbird
Joined: Aug 16, 2009
Age: 20
Posts: 23
Location: Inside my own head
|
| Posted: Fri Sep 04, 2009 2:32 pm Post subject: Re: Databases |
|
|
| SQL is pretty easy to learn. The only hard part about it is there is a different version of it for every database management system, though they all have the same basic syntax. You should get MySQL. It's easy to use and you can download it for free here. The only hard part is installing, which I can't tell you how to do because I don't know what kind of operating system you're running. I did it by transferring all the binaries to /usr/local/bin, but I have a Mac and I don't know a lot about using Windows. |
|
| Back to top |
|
|
