|
I work at a job where they've shown me how to run the database reports I need to run, but not much else. It's a temp job at a place that has been bought out by another company, so it's kind of a dead end. I've gotten to the point where I can do the reporting very quickly and am now bored most of the day. But I would like to learn more things and move up in the world. So I figure, this is a great place to explore some sql, since I've always learned better by doing. So, I would like to find out: What version of sql am I using? (I connect to AS/400 with Sequel Viewpoint, if that helps.) What are the names of all the tables, and the last time they were accessed? (There are something like 10,000 of them.) What are the names and descriptions of the fields in the tables I use? (I use maybe 20.) How are these tables linked (what fields do they have in common)? Basically, I would like to understand all the data available to me so that when someone asks me to give them something that's not in a report already, I can actually do it. Please pardon if any of these questions are too stupid or strange, I'm trying to get up to speed quickly.
|
# ¿ Jan 4, 2008 18:05 |
|
|
# ¿ May 4, 2024 05:31 |
|
I just installed MySQL Server 5.1 to learn on. What's the best free resource you know of for learning sql? It would be really nice if it had example data and a way for me to test myself as well, like sql code that I would first have to try to create and then could check by running the correct code, kind of like the answers at the back of the book.
|
# ¿ Dec 3, 2010 07:25 |