Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Alex Life
16,114 PointsWhy SQL
and not Excel? I see nothing in SQL that I cant do easier in Excel, and while im here complaining, where is the visual basic class?
2 Answers
stjarnan
Front End Web Development Techdegree Graduate 56,488 PointsHi Alex!
I would like to agree with Jason Anders, I find his explanation good but would like to add one thing. Imagine yourself storing hundreds of thousands rows in your database/Excel spreadsheet, this is not an unusual amount of data in a database. In this case your Excel spreadsheet and actions on it will be slow, really slow. Let's just say there's a reason big companies are not using Excel as a database. I even think Excel has a limit of not too many rows, right?
Regarding Visual Basic, I don't think there are too many companies reqruiting for Visual Basic right now, and Treehouse tend to create courses based on demand. You could always send a suggestion to them, letting them know it is something you would like to see in the future: help@teamtreehouse.com
I hope that helps
Jonas
Jason Anders
Treehouse Moderator 145,860 PointsHey Alex,
To answer the first part of your post is quite simply Excel is a Spreadsheet not a Database, so a very different application than SQL. Excel will not and cannot do what SQL can and does. For example, would you be able to store a 2000-word blog article in an Excel cell and have that cell display on a web page formatted correctly to the style of the site when someone clicks a "read more..." link? Short answer: no. The complexity of a complete answer goes beyond the scope of the Community, but if you progress with more Database courses, you will definitely see the difference.
As for Visual Basics, there are no courses here on Treehouse. Visual Basic was first released in 1991. It's last stable version was released in 1998, and declared Legacy (old and outdated) in 2009. So, I personally don't foresee Treehouse creating courses for this.
Keep Coding! :)
Alex Life
16,114 PointsThe language for excel macros is Visual Basic. Also yes you can actually, merge cells, wrap text, hide gridlines, hyperlink to website. Not only that insert pictures as watermarks behind the text.. EXCEL WIZARDRY!
Alex Life
16,114 PointsAlex Life
16,114 PointsI like this explination more. Excel does have a limit, its a little over a million, and some of the stuff I have worked on has hit the mark. And I agree it is very very very very incredibly slow at that point, so it seems like SQL will be useful after all.