1
00:00:00,000 --> 00:00:04,597
[MUSIC]

2
00:00:04,597 --> 00:00:08,280
At the heart of a dynamic
application is a database.

3
00:00:08,280 --> 00:00:13,400
Whether the application is an e-commerce,
sports team, or social network site, or

4
00:00:13,400 --> 00:00:18,280
even a productivity app on your phone,
the data needs to change over time.

5
00:00:18,280 --> 00:00:21,840
For example, if you run an e-commerce
site, you'd want to search for

6
00:00:21,840 --> 00:00:25,500
products, update stock counts,
create new orders or

7
00:00:25,500 --> 00:00:30,540
new products in your database and
remove all discontinued products.

8
00:00:30,540 --> 00:00:34,560
The site is dynamic because its
state changes all the time.

9
00:00:34,560 --> 00:00:39,060
In short, there are four main operations
that you'd want to perform on data

10
00:00:39,060 --> 00:00:40,620
in a database.

11
00:00:40,620 --> 00:00:45,600
Firstly, you want to be able to create or
add data to a database.

12
00:00:45,600 --> 00:00:48,680
Secondly, you want to read the data.

13
00:00:48,680 --> 00:00:52,520
Reading would include searching and
filtering the result set.

14
00:00:52,520 --> 00:00:58,040
Thirdly, you'd want to update or
edit rows of data in any of the tables.

15
00:00:58,040 --> 00:01:02,210
Finally, you need to remove the data or
delete the data.

16
00:01:02,210 --> 00:01:05,240
These four operations create,
read, update and

17
00:01:05,240 --> 00:01:07,890
delete are shortened to the acronym CRUD.

18
00:01:07,890 --> 00:01:11,480
I am Andrew,
a Treehouse teacher, developer,

19
00:01:11,480 --> 00:01:14,370
and life long learner, and
welcome to this course.

20
00:01:14,370 --> 00:01:17,940
In this course we're going to
focus on inserting, updating and

21
00:01:17,940 --> 00:01:21,000
deleting rows of data
from our database tables.

22
00:01:22,170 --> 00:01:26,720
Each of the CRUD operations has
an SQL keyword associated with it.

23
00:01:26,720 --> 00:01:31,700
If you've taken the prerequisite course,
or have experience querying a database,

24
00:01:31,700 --> 00:01:37,040
you should be familiar with reading from
the database using the select keyword.

25
00:01:37,040 --> 00:01:40,020
We will be covering that
again in this course.

26
00:01:40,020 --> 00:01:42,650
If you haven't taken the prerequisites or

27
00:01:42,650 --> 00:01:47,120
are new to databases,
I'd recommend you go and take them now.

28
00:01:47,120 --> 00:01:52,120
Like before, we'll be using Treehouse's
interactive SQL database environment,

29
00:01:52,120 --> 00:01:53,830
SQL Playgrounds.

30
00:01:53,830 --> 00:01:58,420
Be sure to launch each new
SQL Playground with each new video.

31
00:01:58,420 --> 00:01:59,460
In this stage,

32
00:01:59,460 --> 00:02:03,990
we're going to take a look at creating
new rows of data in our tables.