Join Mark Niemann-Ross for an in-depth discussion in this video Overview of solution, part of Database Clinic: SQLite.
- [Man] This problem is presented as four steps.…Create, read, update, and delete,…each with a distinct task to illustrate that operation.…In keeping with that CRUD structure,…I'll present my solution in four corresponding parts.…Create.…I've created a Python script called CREATE_shakespeare.py.…Read, not surprisingly, is read Shakespeare.…
Update is update Shakespeare,…and delete is delete Shakespeare.…Each one of these Python scripts will illustrate…one step of the solution.…I've also included an example written in R that I'll review…after I review the Python scripts.…All of these files are located in the exercise files folder.…We've also been asked to time each operation…and generate a report on how long it takes.…SQLite doesn't have timing functions built in,…so I'll rely on external tools.…
The time library for Python, and the tictoc package in R.…When we finish this exercise,…there are some insights we'll gain.…First of all, the CRUD,…create, read, update, delete,…support in SQLite is pretty simple.…But timing operations is a bit tricky,…
- 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.