1
00:00:00,240 --> 00:00:00,690
Okay.

2
00:00:00,690 --> 00:00:05,010
So we left off with a little cliffhanger, which was we've inserted data.

3
00:00:05,040 --> 00:00:06,900
How do we know that it actually worked?

4
00:00:06,930 --> 00:00:12,690
And the main reason I made this a separate video is that it gives me a few seconds, a separate opportunity

5
00:00:12,690 --> 00:00:19,080
to talk about one of the main dilemmas behind figuring out how to best teach this content, which is

6
00:00:19,080 --> 00:00:25,390
that pretty much everything in this course is related and interdependent, or a lot of it is.

7
00:00:25,410 --> 00:00:28,200
So here's an example I'm showing you.

8
00:00:28,220 --> 00:00:34,560
I'm talking about inserting data, but it's really not that great of a learning experience unless you

9
00:00:34,560 --> 00:00:36,420
know how to view data.

10
00:00:36,420 --> 00:00:41,730
But if I teach you to view data first without having you insert it, there's nothing to view and so

11
00:00:41,730 --> 00:00:42,090
on.

12
00:00:42,540 --> 00:00:48,510
So my approach is to try and teach things in isolation, but then kind of bridge the gap and give sneak

13
00:00:48,510 --> 00:00:49,950
previews when necessary.

14
00:00:50,940 --> 00:00:56,550
So with all of that said, I come from the future here with a SQL Command.

15
00:00:56,550 --> 00:00:59,790
You won't actually learn learn officially until the next section.

16
00:01:00,000 --> 00:01:02,190
So for now, you can just copy this.

17
00:01:02,580 --> 00:01:07,110
We're not going to talk about really what it does or how it works until the next section.

18
00:01:07,110 --> 00:01:09,630
We'll dive a lot more into this select statement.

19
00:01:09,630 --> 00:01:16,500
But to view all of our data in any given table, select star from the table name.

20
00:01:16,500 --> 00:01:19,050
So select star from Cats and that's all I'm going to say about it.

21
00:01:19,050 --> 00:01:23,400
For now, our priority is still focusing on creating and inserting data.

22
00:01:23,400 --> 00:01:26,010
This is just going to help us check that it worked.

23
00:01:26,130 --> 00:01:27,210
So let's try it.

24
00:01:27,210 --> 00:01:29,070
We should have two cats in there.

25
00:01:29,370 --> 00:01:35,460
Select Star from cats and there we go.

26
00:01:35,460 --> 00:01:36,840
We've got name and age.

27
00:01:36,840 --> 00:01:40,170
We have Blue, who is one, and Draco who is 11.

28
00:01:40,350 --> 00:01:43,680
And remember we inserted these in different orders.

29
00:01:43,770 --> 00:01:50,520
So we did name and then age for blue and then we did age followed by name for Draco.

30
00:01:51,480 --> 00:01:52,860
So that's all there is to this.

31
00:01:52,860 --> 00:01:54,000
We know that it works.

32
00:01:54,000 --> 00:01:56,340
There's a lot more to using the select command.

33
00:01:56,340 --> 00:02:02,520
Probably 30% of this course will be focused on selecting data and filtering it and sorting it and searching

34
00:02:02,520 --> 00:02:04,590
and all sorts of different ways of viewing data.

35
00:02:04,590 --> 00:02:07,380
But for now, this is a magic little shortcut.