Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
Data isn't static, it changes over time. Databases allow you to modify that data over time.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
[MUSIC]
0:00
At the heart of a dynamic
application is a database.
0:04
Whether the application is an e-commerce,
sports team, or social network site, or
0:08
even a productivity app on your phone,
the data needs to change over time.
0:13
For example, if you run an e-commerce
site, you'd want to search for
0:18
products, update stock counts,
create new orders or
0:21
new products in your database and
remove all discontinued products.
0:25
The site is dynamic because its
state changes all the time.
0:30
In short, there are four main operations
that you'd want to perform on data
0:34
in a database.
0:39
Firstly, you want to be able to create or
add data to a database.
0:40
Secondly, you want to read the data.
0:45
Reading would include searching and
filtering the result set.
0:48
Thirdly, you'd want to update or
edit rows of data in any of the tables.
0:52
Finally, you need to remove the data or
delete the data.
0:58
These four operations create,
read, update and
1:02
delete are shortened to the acronym CRUD.
1:05
I am Andrew,
a Treehouse teacher, developer,
1:07
and life long learner, and
welcome to this course.
1:11
In this course we're going to
focus on inserting, updating and
1:14
deleting rows of data
from our database tables.
1:17
Each of the CRUD operations has
an SQL keyword associated with it.
1:22
If you've taken the prerequisite course,
or have experience querying a database,
1:26
you should be familiar with reading from
the database using the select keyword.
1:31
We will be covering that
again in this course.
1:37
If you haven't taken the prerequisites or
1:40
are new to databases,
I'd recommend you go and take them now.
1:42
Like before, we'll be using Treehouse's
interactive SQL database environment,
1:47
SQL Playgrounds.
1:52
Be sure to launch each new
SQL Playground with each new video.
1:53
In this stage,
1:58
we're going to take a look at creating
new rows of data in our tables.
1:59
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up