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

Computer Science

Posted by xczurymqdj
xczurymqdj
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,755 Points
Caleb Kemp
Caleb Kemp
12,755 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

xczurymqdj
xczurymqdj
2,289 Points
xczurymqdj
xczurymqdj
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,755 Points
Caleb Kemp
Caleb Kemp
12,755 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;