I'm looking for a webpage or some other resource that provides a very basic introduction to SQL queries. I'm teaching a class on Geographic Information Systems and I'd like to go into a bit more depth on SQL than the textbook does, but I still want a written resource that I can point the students to. Most of the class are not computer geeks, so I need something that's fairly basic and isn't going to scare them off or confuse them too much.
+2
A:
Understanding set based concept is very fundamental. Check this post on a visual explanation.
Alex
2008-09-16 00:03:33
+5
A:
SQL Zoo is a very gentle interactive introduction. If you (or the intended student) have the prerequisites and aptitude for learning SQL at all, you just can't help picking up the basics.
I use it with new hires for a tech support team who need to learn some fundamentals and it's been working like a charm.
chryss
2008-09-16 00:09:37
Wow, never saw that site before but after checking it out it looks perfect as an interactive introduction. I see why you've been using it!
Yadyn
2008-09-16 00:35:52
+2
A:
W3Schools has a good website intro to sql. If anyone wants a book, the first several chapters of this book are an excellent intro. Much better than the text book from my database class.
If anyone wants to explore relational database concepts, 15Seconds seems to have a good intro. This book is also very good on that subject.
Sean
2008-09-16 00:25:50
A:
I've used the SQL Queries for Mere Mortals to teach an introduction to SQL querying for IT Admins. It is a great resource and covers most everything you need for a basic introduction to getting data out of a SQL Server. It includes some hands on exercises, but I haven't used them.
Steven Murawski
2008-09-16 01:08:42