Access/Databases/SQL

[Tooj 17]

Just wondering as now I'm going to be dealing with a lot more Database style work as opposed to the usual Excel jazz that I come up against. I was wondering if anybody knew of any decent sites or tutorials as such to familiarise myself a bit more with Databases and all of the above. I know the basics etc but wouldn't mind getting to know a bit more of the ins and outs. Basically because I am sad enough as well to do these things at home to better myself.

[NJS 4386]

Just wondering as now I'm going to be dealing with a lot more Database style work as opposed to the usual Excel jazz that I come up against. I was wondering if anybody knew of any decent sites or tutorials as such to familiarise myself a bit more with Databases and all of the above. I know the basics etc but wouldn't mind getting to know a bit more of the ins and outs. Basically because I am sad enough as well to do these things at home to better myself.

 

Sorry I don't know any sites but my advice would be forget Access - you can get desktop SQL servers from MS which would be infinitely better for you to learn in the long run.

[Tooj 17]

Just wondering as now I'm going to be dealing with a lot more Database style work as opposed to the usual Excel jazz that I come up against. I was wondering if anybody knew of any decent sites or tutorials as such to familiarise myself a bit more with Databases and all of the above. I know the basics etc but wouldn't mind getting to know a bit more of the ins and outs. Basically because I am sad enough as well to do these things at home to better myself.

 

Sorry I don't know any sites but my advice would be forget Access - you can get desktop SQL servers from MS which would be infinitely better for you to learn in the long run.

Thanks very much.

[peasepud 59]

Just wondering as now I'm going to be dealing with a lot more Database style work as opposed to the usual Excel jazz that I come up against. I was wondering if anybody knew of any decent sites or tutorials as such to familiarise myself a bit more with Databases and all of the above. I know the basics etc but wouldn't mind getting to know a bit more of the ins and outs. Basically because I am sad enough as well to do these things at home to better myself.

 

Sorry I don't know any sites but my advice would be forget Access - you can get desktop SQL servers from MS which would be infinitely better for you to learn in the long run.

Thanks very much.

 

Im not sure Id agree with that statement, yes learning those would be better long term however learning access and being aware of the differences between that and "normal" SQL can be useful.

 

The wonder of access is it has a handy Query builder where you can drag and drop then put in criteria etc in an easy to understand way. Once the query works then look at the SQL view to see how its actually constructed in code. SQL itself can be a bit daunting especially the likes of Inner and Outer Joins and nested tables so Access helps the newbie visualise that.

[NJS 4386]

The wonder of access is it has a handy Query builder where you can drag and drop then put in criteria etc in an easy to understand way. Once the query works then look at the SQL view to see how its actually constructed in code. SQL itself can be a bit daunting especially the likes of Inner and Outer Joins and nested tables so Access helps the newbie visualise that.

 

I'd agree as a teaching tool for a newbie but I wouldn't want anyone who was serious to consider Access as a "professional" choice in terms of career.

 

Even then SQL tools create the basic queries when you open a table or create views which have that drag and drop functionality you mentioned.