Join Mark Niemann-Ross for an in-depth discussion in this video CRUD operations in SQLite with R, part of Database Clinic: SQLite.
- [Instructor] SQLite has the ability to work with…multiple programming languages.…As an example, I've provided an R program that…accomplishes all four of the tasks.…I used the python code I wrote for the previous examples,…and translated it into R.…You'll see many of the same concepts in a lot of the…identical SQL queries as used in the previous examples.…I'm using RStudio to look at look at this code.…
And to open it, what I'm going to do is navigate…to the exercise files folder chapter five…and I'm going to use Shakespeare.R.…It's essential that you set this as your…working directory.…Now we'll look at this code in just a minute,…but first I want to run it.…To run code in Rstudio, I hit Command A…for command all and then I click on the Run icon.…
This will run the complete file, you'll notice that it's…built an SQLite database…and it's done.…That was pretty quick, but we can go back and confirm…that it did actually print out…all of the lines of the play.…If we want to, we can switch to DB Browser for SQLite…and open that database.…
- 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.