#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.