Join Mark Niemann-Ross for an in-depth discussion in this video Update records in SQLite with Python, part of Database Clinic: SQLite.
- [Instructor] After creating a database…with all the lines from Midsummer Night's Dream,…I'm being asked to update every line…so that the character names appear in uppercase.…For example, let's take a look at the database.…Line seven is spoken by Theseus…and you can see the name Hippolyta is in lowercase.…When our script completes,…all of these character names should be in uppercase.…
Let's take a look at the Python script that does that.…I'm now looking at Python IDLE…and I'm going to open the script that makes that change.…I navigate to my exercise files chapter five…and I'm going to use the UPDATE_shakespeare Python script.…I'll run this code and then we'll come back and take a look…and see what it actually does.…To run it, I go Python Run Module…and it doesn't take much time for it to complete that task.…
Let's go back to the DB Browser for SQLite.…We'll update and you can see that now in line seven,…Hippolyta is in uppercase…so our script actually does what it sets out to do.…Let's take a look and see how that actually works.…
- 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.