- Tools We'll be Using 3:57
- Your First SQL Statement 4:01
- Selecting All Information From a Table 5 objectives
- Retrieving Specific Columns of Information 2:53
- Retrieving Specific Columns of Information 5 objectives
- Categorizing Your Output with 'AS' 4:33
- Categorizing Your Output with 'AS' 4 objectives
- Review & Practice with SQL Playgrounds 1:50
- Getting Data From a Database Review 8 questions
Preview
Video Player
00:00
00:00
Tools We'll be Using
3:57In 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.
[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