Databases

Ray Thomas
Ray Thomas
10,561 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
Luc de Brouwer
Full Stack JavaScript Techdegree Student 17,301 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
10,561 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