So SQL is both Excel and the Excel workbook?
I found a really complete tutorial for SQL on W3Schools and it answered a lot of my questions. It explained the syntax and how it worked (pretty simple if you ask) but there's still a few things I don't know:
-Do I need to have a designated server for this? I have a generous friend that donated some of his server space to me since it's very impractical for me to maintain one. However I doubt he will allow me to reconfigure the whole thing!
-I still don't understand where and how the databases are stored!
Sorry I typed the above quicly...
Let me give it another try...
Check out this site for a answer to "what is SQL"
SQLCourse - Lesson 1: What is SQL?
SQL is not
Excel, I used the parable excel because it's easier to understand, so forget I mentioned it.
This is the structure of an SQLDB (relational DB)
In this I could ask the database questions, show me all the users with the name "adam", in SQL that would be
SELECT * FROM Database1 WHERE FirstName = 'adam'
this would show me a list of people who's first name is Adam...
I mentioned a "relational DB" because Database1 & 2 are related to each other, the AddressID is in both DB's this means
1. I can link them together
2. people can have the same address, but each address will only be in there once, this reduces the amount of data in the DB
There is more to SQL, if you want to learn more i suggest the internet, that is how I started...
to answer the other questions,
-You need a server for this, it doesn't need to be a dedicated server, unless you will have a lot of trafic/data
If your friend has build his own server it is very likely that he has a SQL DB or knows how to install it (its just as easy as installing Apache)
If he got the domain in a package with a hosting provider, chances are that an SQL server is already included...
-Sorry I cannot help you with this, all I know is SQL needs to be installed as a package on a server, I'm assuming there are a lot of files..
For B4PPC you can use SQLite this is a local file which works as a SQLserver...
Let me know if you have any more questions