1
00:00:00,300 --> 00:00:01,830
Hey, welcome to the next section.

2
00:00:02,070 --> 00:00:04,790
So let's recap what we just saw in the last section.

3
00:00:04,800 --> 00:00:11,130
We basically saw how to make databases and then how to create tables which are currently empty to represented

4
00:00:11,130 --> 00:00:12,690
by this box here.

5
00:00:12,690 --> 00:00:14,430
Let's say this is a cat's table.

6
00:00:14,430 --> 00:00:15,180
It's empty.

7
00:00:15,180 --> 00:00:16,500
It has no data in it.

8
00:00:16,500 --> 00:00:21,990
But in this section, I'm going to show you the tools to insert data into the cat's table.

9
00:00:21,990 --> 00:00:22,770
Thank you, Blue.

10
00:00:22,770 --> 00:00:23,940
That was perfect.

11
00:00:24,390 --> 00:00:26,160
So we'll see how to do that.

12
00:00:26,160 --> 00:00:32,520
It's a insert command, so we'll see that and get lots of practice, lots of exercises, inserting data

13
00:00:32,520 --> 00:00:33,450
into tables.

14
00:00:33,450 --> 00:00:38,220
And then the other thing we're going to see in this section, it's not the primary focus, but it's

15
00:00:38,220 --> 00:00:42,150
important is selecting data back out.

16
00:00:42,150 --> 00:00:44,640
And I won't remove Blue from the box just yet.

17
00:00:44,760 --> 00:00:45,960
She's very paranoid.

18
00:00:45,960 --> 00:00:47,310
She loves this box.

19
00:00:47,430 --> 00:00:52,680
But the idea is, rather than deleting things, that's for another time, another section.

20
00:00:52,680 --> 00:00:54,360
How can we retrieve it out?

21
00:00:54,360 --> 00:00:56,160
How can we read it or search?

22
00:00:56,160 --> 00:01:02,910
So let's say insert, I don't know, ten cats into a box and they all have different birthdays and breeds

23
00:01:02,910 --> 00:01:03,630
and names.

24
00:01:03,630 --> 00:01:11,790
I want to be able to run code like select or retrieve the last five cats added or retrieve the names

25
00:01:11,790 --> 00:01:19,020
of the Russian blue cats or retrieve the names of the the last, I don't know, the oldest cat in your

26
00:01:19,020 --> 00:01:19,590
database.

27
00:01:19,590 --> 00:01:20,730
Something like that.

28
00:01:21,210 --> 00:01:21,380
Wow.

29
00:01:21,420 --> 00:01:22,770
She's having a lot of fun in there.

30
00:01:22,770 --> 00:01:27,810
So that will be the goal in this section is to show you those two commands, inserting data and then

31
00:01:27,810 --> 00:01:29,490
retrieving it back out.

32
00:01:29,560 --> 00:01:30,780
I'm just going to leave her in there.

33
00:01:30,780 --> 00:01:32,730
I can't can't stand to take her out.

34
00:01:33,180 --> 00:01:33,570
All right.

35
00:01:33,570 --> 00:01:34,620
Well, end it there.

36
00:01:34,620 --> 00:01:36,180
Blue's enjoying her box.

37
00:01:36,180 --> 00:01:39,420
I'm enjoying whatever this is.