I want to study database managament and programing as well. I know how to use access and make databases/form etc. but I want to go further and learn the right stuff (which there isn't). But if you were me which NDBMS would you use/study if you wanted to make a database for 100,000 clients and every client would have 50 fields on the form (search had to de made as well - query)? This had to be accessed on a network with 12 workstations. I know that for a start I needed the DB to be on a SQL server, but at the moment I only have NT4. What is the best way to start? I want to make a good program and also I will have some remote users to access the DB out of the LAN. I am totally new and lost because I don't know what to study and how to start. Here's how confused I am:
Is an SQL a server or a database application like access, foxpro, oracle etc...
I just don't know, I am certain that here there are lots of professional people here that will give me some instructions/websites and will remember their days of headaches/learning as well. Please help a future database engineer/programmer.