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

Databases

Posted by Ray Thomas
Ray Thomas
12,478 Points

Does treehouse show how to make an SQL table natively?

I can only find where the treehouse playground has a database built into it. I want to run some of this on my own machine with my own data. Any resources known?

Thanks! :)

1 Answer

Luc de Brouwer
seal-mask
.a{fill-rule:evenodd;}techdegree
Luc de Brouwer
Full Stack JavaScript Techdegree Student 17,939 Points
Luc de Brouwer
.a{fill-rule:evenodd;}techdegree
Luc de Brouwer
Full Stack JavaScript Techdegree Student 17,939 Points

Hi Ray,

I don't think I've come across a specific Treehouse database course that shows you the process of creating the database manually. In the courses these databases are created through scripts, however, there should be plenty of resources out there that should explain how to create databases manually with hosted databases.

Usually, you have a MySQL or mssql server running that allows you to connect to it with a client, like MySQL workbench or Microsoft SQL server management. With workbench, you right-click the list of databases and create a new 'schema'. in mssql it is the same right-click, but "create the database instead".

If you're using a local development server you can also achieve the same result with PHPMyAdmin.

Here is a link for more SQL related content: https://www.w3schools.com/sql/default.asp

From the command line: https://www.a2hosting.com/kb/developer-corner/mysql/managing-mysql-databases-and-users-from-the-command-line

From the GUI: http://www.mysqltutorial.org/mysql-create-database/

Ray Thomas
Ray Thomas
12,478 Points

thanks for your help! I went to dev.MySQL.com and followed the instructions on creating a new user/password and made a database with lots of fun new tables and such. From there, the content I've covered so far here on TreeHouse seemed to really help.

Being new server side, I really don't know what I was originally asking for - which is annoying for everyone including me.

Thanks again