7 Replies - 1220 Views - Last Post: 11 January 2008 - 05:45 AM Rate Topic: -----

#1 Sormeki  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 12-December 07

New To Databases

Posted 13 December 2007 - 12:07 AM

I'm new to databases and looking to learn all I can. Does anyone know where I could find some good tutorials or have an useful tips for a beginner? I have two goals for this. First and foremost is to learn how to do this. Second, I would like to make a image board site similar to how 4chan.org use to be. Any help would be greatly appreciated.
Is This A Good Question/Topic? 0
  • +

Replies To: New To Databases

#2 yaronalon  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 12-December 07

Re: New To Databases

Posted 13 December 2007 - 04:10 AM

Hoi,
welcome to the BD world ,
where to learn it is obvious near your home town :D
the question is what to learn
I think from what I understand, and how I'm Analise your needs
take a look on MySQL, I think it will do the work for you.

If you have chosen "MySQL" DB you can start learn it from here


http://www.mysql.com...CFSDcEAodTnjfoA

This post has been edited by yaronalon: 13 December 2007 - 04:14 AM

Was This Post Helpful? 0
  • +
  • -

#3 dataferret  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 13-December 07

Re: New To Databases

Posted 13 December 2007 - 11:00 AM

I think it is important for you to distinguish between the database and the database language. They are not one and the same. A database is simply a collection of information (data) which can be in a variety of formats (word, text, excel, CSV etc), whilst the database language (platform) can be different depending on your needs. For example, if you are using a Windows PC or Windows server, the database can be created in Excel, imported into Access and made available online using ASP web pages. Or you may use MySQL if you want to put it online and communicate with a programming language such as PHP. Practically all database platforms understand Structured Query Language (SQL) so starting with Mysql is good advice.

So focus on what it is you need to understand and learn - break them down into elements which will help you grasp quickly what you need to know.

Overview of a Database
The Data Itself and Its Uses
Data Normalisation
Database Platforms

Hopefully this should put you on the right track :)
Was This Post Helpful? 0
  • +
  • -

#4 Sormeki  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 12-December 07

Re: New To Databases

Posted 13 December 2007 - 11:39 PM

View Postdataferret, on 13 Dec, 2007 - 11:00 AM, said:

Or you may use MySQL if you want to put it online and communicate with a programming language such as PHP.

That is exactly what I intend to do.
Was This Post Helpful? 0
  • +
  • -

#5 capty99  Icon User is offline

  • i am colt mccoy
  • member icon

Reputation: 98
  • View blog
  • Posts: 10,081
  • Joined: 26-April 01

Re: New To Databases

Posted 14 December 2007 - 12:19 AM

if you know php, good. if you don't go to php.net...

simple mysql is easy to pick up and can be learned at the link posted above.

i suggest you install something similar to WAMP server
http://www.wampserver.com/en/

to allow you to set up a virtual database on your computer and test your mysql/php on it.
Was This Post Helpful? 0
  • +
  • -

#6 Sormeki  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 12-December 07

Re: New To Databases

Posted 14 December 2007 - 07:27 PM

I already have the php I need for this. I not sure, as I'm still rather new to this, but, if I understand it right, I need to make a database that images and such are uploaded to and then retrieved from and displayed on the imageboard. If that makes sense. I'm really new at this so, I'm not sure if I'm making any sense or if I'm more confused than I think I am. lol
Was This Post Helpful? 0
  • +
  • -

#7 maker103  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 21-December 07

Re: New To Databases

Posted 21 December 2007 - 06:54 PM

Ok, yea I hope I get an answer to this.

New to this site btw.

I have Mysql and are running somethings, that are very important. Only now, that I need to let someone else access and modify my database.

There is only one question I have about MYsql atm.(hoping nothing else is needed to be learned by myself)

The question is, How can I let another person access ,my DB or Database, I am confuesed I established my connecton and so on, and then it says mysql ( iam using sqlyog btw) and once mysql is clicked on on the items to choose from it says DB, I am confused on how to actually let someone else access my database, though I know it can all be configured through that page.

If anyone can give me some information about this it would be greatly appreciated.
Or if anyone can give me an example of some sort.

If you do respond to what you may all call a stupid question thankyou, (for responding).

This post has been edited by maker103: 21 December 2007 - 06:56 PM

Was This Post Helpful? 0
  • +
  • -

#8 Footsie  Icon User is offline

  • D.I.C Regular
  • member icon

Reputation: 24
  • View blog
  • Posts: 370
  • Joined: 20-September 07

Re: New To Databases

Posted 11 January 2008 - 05:45 AM

maker103 -
I don't know the answer to your question but I think you should post this in your own thread, with your own title etc.
(Otherwise maybe one of the mods can move it out...)

You're more likely to get it answered that way. :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1