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
Jonathan Grieve
Treehouse Moderator 91,252 PointsCreating an SQL Database
The Treehouse Playground environment is great for these courses but to really test my skills in SQL I'd really like to be getting into an environment where I can create my own data, tables and run queries on then,
On the old Database Foundations course there was SQL Workbench (at least for Windows) for doing this and I believe I still I have this on my desktop but I just thought I'd take the opportunity to ask if there's anything else out there that might be good for running SQL and/or making practical use of it in the real world :)
7 Answers
Joel Bardsley
31,246 PointsI've recently changed my local dev environment from MAMP to Vagrant with Virtualbox and I must say I'll never look back.
With those two programs downloaded and installed, all I need to do is download this github repository that will configure/setup a virtual Linux machine that I can connect my SQL program to, and I'm ready to go. I use Sequel Pro (Mac only, unfortunately) however I don't imagine there being any problems using it with SQL Workbench or something like HeidiSQL
Tre .
1,574 PointsAh, OK thanks. I just found the 'Database Foundations' course. Looks like they require students to install the server and workbench I'm starting with that course instead. Thanks for the info!
hiiuhi hiuhiuhiuh
430 Pointsjonanthan, best thing would be to buy a hosting account on Godaddy or elsewhere which offers you database. Then you can use their bench to fill in the data manually or use a programming language to automate the process.
Sounds good.?
Cindy Lea
Courses Plus Student 6,497 PointsI used Apache server when I was learning SQL.
Jonathan Grieve
Treehouse Moderator 91,252 PointsSo it's as close to home as firing up XAMPP and using a service there, phpMyAdmin? :-)
Obayanju Damilare
3,383 PointsHi, I wanted to ask if I need this topic to learn WordPress Theme Development. Thanks for your answer in advance:)
Jonathan Grieve
Treehouse Moderator 91,252 PointsIt can't hurt to have an idea on the basics but I don't think you'll be working with SQL too much in WordPress Development apart from migrating WordPress websites to domains or from local host.
Otherwise WordPress takes care of most of the interaction with SQL for you.
Obayanju Damilare
3,383 PointsThanks Jonathan
Tre .
1,574 PointsI'm really interested in this course. Doesn't sound like playground is ideal for practicing. Is the workbench from mysql more than sufficient?
Jonathan Grieve
Treehouse Moderator 91,252 PointsIt's great for practicing if all you want to do is work with the given data.
Workbench shoiuld work for you otherwise if you want to practice building a database with a sql file.
Jonathan Grieve
Treehouse Moderator 91,252 PointsJonathan Grieve
Treehouse Moderator 91,252 PointsThanks for all your responses. :)
I'll keep these links as bookmarks but for now I've gone back to SQL Workbench to create and query databases till I learn more about how to use them practically.