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 trialxczurymqdj
2,289 PointsWhat 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?
1 Answer
xczurymqdj
2,289 PointsI cant seem to find any sql work space in the workspace. If you could maybe tell me how to find them please?
Caleb Kemp
12,754 PointsWell, 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;
Caleb Kemp
12,754 PointsCaleb Kemp
12,754 PointsYou 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.