Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Computer Science

pinky
pinky
2,289 Points

What are you able to do , build, practice with just SQL basic ?

What am I able to do with SQL basic? What am I able to Build with just using SQL basic? Where and how can I practice SQL basic?

Caleb Kemp
Caleb Kemp
12,714 Points

You can build tables and practice querying to get particular results, joining tables etc. Here is a course that really covers most of those things. And if you open the workspace for this course, it has a SQL workspace just like you were looking for.

1 Answer

pinky
pinky
2,289 Points

I cant seem to find any sql work space in the workspace. If you could maybe tell me how to find them please?

Caleb Kemp
Caleb Kemp
12,714 Points

Well, it sounds like you found the workspace called "SQL Playground". To actually practice your SQL, hit the "+ New Query" button, and it will bring up a text area to write SQL queries. It will have "-- enter a query" written at the top. After you're finished writing your query, click "run". There is already a lot of data in the tables which you can run queries against. However, if you feel the need, it will let you create your own tables with the "CREATE TABLE" command. This is what the command would look like to create an empty table called PERSON, with the fields "Person_ID" and "FirstName"

CREATE TABLE Persons (
    PersonID int,
    FirstName varchar(255)
);

That should let you run just about any query you want. Happy practicing

P.S. Here is a simple query you can run just to see it's working (it will show all the student table data)

SELECT * FROM STUDENTS;