Interest in databases

[JohnD]

I know some basic access, but I am interesting in working with databases. Where I should I begin?


thanks

[PEB]

Hi,

Welcome in the world of databases ;)

So first it will be good If you can create a table the main object of the databases... They stock your information...

The trick here is how to create your tables, so that they gat minimum place phisically and are the most possible informative...

And remember there is a 3 operations with data:

APPEND, UPDATE AND DELETE

So be carefull what heppans with your data when the user uses one of this Actions...

There is databses in which users can only add records without possibility to delete and update... And there is the full history of the events without loss...

There is a lot of concepts in the databases :)

:)

Cheers

:)

[MMcCarthy]

Try to find a good course on RDBMS (Relational Database Management Systems). This can be in any language but a sql based language like oracle is always best. Here you will learn how to structure a database.

As PEB said every database is based on the structure of the tables. Once you understand how this works you can pick the rest up as you go along.