This lecture covers the DELETE command to remove data. We have now covered Create, Read, and Update. The final core operation is Delete. The DELETE command is used… Read More »Lecture 12: Deleting Data with DELETE
This lecture covers the UPDATE command to modify existing data. So far, we have learned how to create data (`INSERT`) and read it (`SELECT`). These… Read More »Lecture 11: Updating Existing Data with UPDATE
This lecture concludes the digital address book mini-project, focusing on querying. Welcome to the second part of our mini-project. We have successfully created and populated… Read More »Lecture 10: Mini-Project! Digital Address Book
This lecture begins a mini-project to create a digital address book.It’s time to put everything we’ve learned together into a practical project. We are going… Read More »Lecture 9: Mini-Project! Digital Address Book
This lecture provides a detailed look at data types in SQLite.When we created our first table, we assigned a data type to each column, like INTEGER and TEXT.… Read More »Lecture 8: A Closer Look at Data Types