CRUD operations—create, read, update, and delete—are the most common database tasks. In this video, instructors are challenged to create database entries for each line of a Shakespearean play, update their formatting, delete stage directions, and then read that information back.
- The next task involves basic data manipulation.…CRUD is an acronym that stands…for create, read, update, and delete.…These are all basic operations…that can be performed with most databases.…Create refers to the creation of a new table or record.…Sequel refers to this as either create to create a table…or insert to create new records inside a table.…Read means to retrieve information…from a database.…
Sequel uses the select command.…Update is a change to an existing record or table.…Sequel uses the update command.…Finally delete refers to removing a record from a table.…Sequel uses the delete command.…This challenge will demonstrate how to perform…CRUD operations on a range of databases.…There are several tasks that our instructor will perform.…I've provided them with the text of Shakespeare's…Midsummer Night's Dream plus a list of characters…in the play.…
Using those two data sets, the instructor will have…to accomplish the following tasks.…The first three tasks will execute concurrently.…For each line in the text,…
- Strengths and weaknesses of SQLite
- Creating a database
- Joining data sets
- Calculations with SQLite and Python
- Searching a database
- Subqueries and queries in SQLite
- CRUD operations in SQLite with R
Skill Level Intermediate
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.