This lecture covers the ORDER BY clause for sorting query results. When you use a `SELECT` statement, the database returns the rows in whatever order… Read More »Lecture 13: Sorting Your Results with ORDER BY
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
Lecture 7, This lecture covers the WHERE clause for filtering data.So far, we can select all data or specific columns from our table. But the… Read More »Filtering Your Data with the WHERE Clause
You’ve created a table and inserted data into it. Now it’s time to learn the most fundamental command for retrieving that data: SELECT. The SELECT statement is used… Read More »Viewing Your Data with SELECT | Lecture 6
We have a beautifully structured, but completely empty, Friends table. Let’s change that by adding our first rows of data.This lecture covers the INSERT INTO… Read More »Putting Data into Your Table | Lecture 5
Learning databases from scratch. This lecture covers the CREATE TABLE command in SQL. We have our environment set up, and now it’s time to build… Read More »Creating Your First Table | Lecture 4