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
Video Player
00:00
00:00
00:00
- 2x 2x
- 1.75x 1.75x
- 1.5x 1.5x
- 1.25x 1.25x
- 1.1x 1.1x
- 1x 1x
- 0.75x 0.75x
- 0.5x 0.5x
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 up-
Jorge Rehlaender
16,422 Points1 Answer
-
PLUS
Vane Charles
Courses Plus Student 18,605 Points2 Answers
View all discussions for this video
Related 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