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
Alexandrino Nunes
Courses Plus Student 10,985 PointsCreate and Populate Databases?
Hi guys.
I'm about to finish SQL Basics Course! So far so good but in this course we learn how to ACESS the contents of the tables and the data inside them in several ways but NOT how to CREATE our DATABASE from ZERO and how to POPULATE it from zero as well. Am I missing something here?
HOW/WHERE can I learn how to create and populate them from zero? What are your recommendations on this?
Thanks.
3 Answers
Ahmed Mohey
7,704 PointsAlso If you are interested in having a sandbox or an example database you want to mess with I heard that someone ported the microsoft Adventure works database to Mysql you can download it from this link: https://sourceforge.net/projects/awmysql/
also there official example databases on mysql here : http://dev.mysql.com/doc/index-other.html
Joel Bardsley
31,249 PointsThe Database Foundations course will get you started for creating and accessing databases (in this case MySQL) on your own machine, as well as creating tables.
A more recent course for inserting and modifying data in SQL can be found here: Modifying Data with SQL
Moderator Edit: Moved Response from Comment section to an Answer.
Alexandrino Nunes
Courses Plus Student 10,985 PointsThanks Joel. Such a great help! :)
Alexandrino Nunes
Courses Plus Student 10,985 PointsThanks Ahmed. Great help as well. Well done!