Here's the SQL for a financial management report I run in the UAF relational database called Databrowser. I really wish I knew how to write or successfully alter these instructions. I'll be taking a course next week in how to write a "browser" but I'm sure it will be years, if at all, before I'm able to do something like this from scratch.At one time I was familiar with writing Excel macros which seems similar to SQL in that you create commands telling the sfotware what to do with what specific data.
2 comments:
I took an Excel course a couple of years ago and I had to write Macros too. I hadn't even made the connection, but you're right, it was similar. I guess for me, taking a web design class where I had to modify HTML/XHTML was what I was comparing the SQL to.
SQL really isn't all that difficult. Start by reading a book like "Sams Teach Yourself SQL in 10 Minutes" - it takes longer than 10 minutes to learn it but its an easy read. Also you can find lots of resources online that show you how to read and interpret, and create your own sql statements.
Post a Comment