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
learning databases from scratch. This lecture explains how to set up SQLite. It’s time to get practical. In this lecture, we’ll get SQLite ready to… Read More »Setting Up Our Environment | Lecture 3
What is a Database? The Power of Tables on learning databases from scratch. This lecture introduces what a database is and the concept of relational… Read More »What is a Database? Power of Tables | Lecture 2
Lecture 1 of a 60-part series on learning databases from scratch. This lecture introduces the fundamental concept of data. What is Data? Welcome to the… Read More »What is Database And Organizing Data? | Lecture 1