Introduction to CRUD2:04 with Andrew Chalkley
Data isn't static, it changes over time. Databases allow you to modify that data over time.
Four Main Data Operations
[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 up