#100DaysOfCode in Python Transcripts
Chapter: Days 79-81: Basic Database Access with SQLite3
Lecture: Analysing the DB with SQLite DB Browser
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
So we'll bring up the program here. I've got mine open already. Control + O will actually open up our open dialogue,
0:10
and there is our address book database. So let's open that up. You can get a bit of information here, although this isn't the most detailed view,
0:20
but straight away, you can see there's one table within this database, with the name of details, and it's got these three columns.
0:29
So let's actually go to browse data. This looks more like what you sort of want to see when you visualize your database.
0:37
There's the table name, there's our name column, address column, and our phone number column. In the next video, I'm going to show you
0:46
how to set this up automatically.