Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed SQL Basics!
You have completed SQL Basics!
Preview
In this video, we'll look at some different tools that you may use in a professional setting and what you'll use while learning here; SQL Playgrounds.
Different Database Tools
- Mode Analytics used for businesses to get insights from their database.
- pgAdmin for PostgreSQL
- phpMyAdmin and MySQL Workbench for MySQL
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
Throughout this course you'll be using
Treehouse's interactive database
0:04
environment, SQL Playground to
write SQL programming code.
0:09
You can press the launch SQL button
at the beginning of each video to
0:13
launch an interactive SQL environment.
0:17
You can use the Playground to run the code
that I'll be talking about in the video.
0:20
Now, don't worry if this looks
slightly different from what
0:23
you have on your screen.
0:27
That just means you've
probably got a newer version
0:29
of SQL Playground with all the latest and
greatest features.
0:31
Each Playground will have a number of
pre-populated coding areas listed here
0:36
at the top left.
0:40
[SOUND] As I discuss
the SQL programming code,
0:41
feel free to hit the Run button
to run the SQL programming code.
0:45
Don't worry if you don't understand
what this means right now.
0:50
I'll be explaining this in
detail in the next video.
0:53
Just realize that when you run any of your
code, you write in this section here,
0:56
this SQL Playground will show
the results here, in the lower section.
1:01
Since this is a playground, feel free to
play around with any of the code you want.
1:07
If you made a mistake and want to go
back to the original SQL code hit Reset.
1:14
Feel free to pause any of the videos at
any point as you use the SQL Playground.
1:21
It's also normal to re-watch videos
to help you cement what you learn.
1:26
If you want to try something out for
yourself, click on New Query, and
1:31
it will open up a fresh coding area.
1:35
You can start something new
of your own from scratch.
1:38
You can add as many
coding areas as you like.
1:42
However, when you close SQL Playground,
none of your code will be saved.
1:46
If you open up SQL Playground
again from the video page,
1:50
it will reset to the initial state.
1:53
If you want to save something,
copy and paste it into a safer place.
1:56
To explore the database structure,
click Database Schema.
2:00
This will show you all the tables
with their names, number of rows,
2:05
their columns, and the date types.
2:12
Finally, we have a list of tables.
2:19
Clicking on a table will give you
an overview of that particular table,
2:23
its columns, data types, and its content.
2:28
When you're writing SQL code in one
of the coding areas, you can press on
2:38
the icon on the right of the table name
to show the columns in that table.
2:42
This is nice because you don't want
to click away when writing your code.
2:48
You can hover your mouse over the column
name, and it shows the data type.
2:53
Now this is the environment
you'll be laying to use SQL.
2:58
But let me show you a couple
of quick examples of
3:01
other places that you could write
SQL in your professional career.
3:03
Many companies use third party services
like Mode Analytics to generate reports.
3:08
See how this area where you
can write the SQL code and
3:13
the results are shown at the bottom.
3:16
If you're a PHP developer, you may
come across a tool called phpMyAdmin.
3:21
See there's an area for a SQL code,
and then you get the results.
3:26
And there are countless other tools.
3:31
They are all variants on the same theme.
3:34
Some have more features than others.
3:36
But they all have the same requirement,
a knowledge of SQL.
3:38
I've included some other
examples in the teacher notes.
3:44
Remember, every coding video will have
its own dedicated SQL Playground.
3:47
So when moving from video to video,
remember to open up a new SQL Playground.
3:52
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up