1
00:00:00,000 --> 00:00:06,000
[SOUND] Hi, I'm Alina.

2
00:00:06,000 --> 00:00:08,380
I'm happy that you've
chosen to join me today.

3
00:00:08,380 --> 00:00:13,390
In this course, we'll delve into the full
spectrum of database interactions.

4
00:00:13,390 --> 00:00:16,640
At the heart of a dynamic
application is a database.

5
00:00:16,640 --> 00:00:20,620
Whether the application is
an e-commerce or social network or

6
00:00:20,620 --> 00:00:24,990
even a to-do app on your phone,
the data needs to change over time.

7
00:00:24,990 --> 00:00:29,530
For example, if you run an e-commerce
site, you'd want to search the products,

8
00:00:29,530 --> 00:00:32,010
update stock counts, create new orders or

9
00:00:32,010 --> 00:00:36,270
new products in your database, and
remove all discontinued products.

10
00:00:36,270 --> 00:00:39,380
The site is dynamic because
the state changes all the time.

11
00:00:40,460 --> 00:00:44,830
CRUD is an acronym that refers to the four
main operations that you'd want to perform

12
00:00:44,830 --> 00:00:46,770
on data in a database.

13
00:00:46,770 --> 00:00:51,190
First, you want to be able to create or
add data to a database.

14
00:00:51,190 --> 00:00:53,680
Second, you want to read the data.

15
00:00:53,680 --> 00:00:56,280
Reading would include searching and
filtering the results.

16
00:00:57,380 --> 00:01:01,590
Third, you'd want to update or
edit rows of data in any of the tables.

17
00:01:02,610 --> 00:01:06,510
Finally, you need a way to delete
the data or remove the data.

18
00:01:06,510 --> 00:01:10,100
These four operations,
create, read, update, and

19
00:01:10,100 --> 00:01:12,730
delete are shortened to the acronym CRUD.

20
00:01:13,970 --> 00:01:17,680
In this course, we're going to
focus on creating, updating, and

21
00:01:17,680 --> 00:01:20,760
deleting rows of data
from our database tables.

22
00:01:20,760 --> 00:01:25,010
Each of the CRUD operations has
a SQL keyword associated with it.

23
00:01:25,010 --> 00:01:26,880
If you have experience
querying a database,

24
00:01:26,880 --> 00:01:31,780
you should be familiar with reading from
the database using the select keyword.

25
00:01:31,780 --> 00:01:35,410
We'll also use select again to
create reports for our data.

26
00:01:35,410 --> 00:01:37,640
If you haven't taken the prerequisite and

27
00:01:37,640 --> 00:01:40,630
are new to databases, I'd recommend
that you go and take them now.

28
00:01:41,950 --> 00:01:46,680
We'll use Treehouse workspaces, so you can
choose launch workspaces to follow along.

29
00:01:46,680 --> 00:01:50,200
Alternatively, you can download
the project files as well and

30
00:01:50,200 --> 00:01:52,670
work on your own machine if you prefer.

31
00:01:52,670 --> 00:01:54,660
Next, we'll take a look
at the finished project.