#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.
0:03 I've got mine open already.
0:04 Control + O will actually open up our open dialogue,
0:09 and there is our address book database.
0:12 So let's open that up.
0:15 You can get a bit of information here,
0:17 although this isn't the most detailed view,
0:19 but straight away, you can see
0:21 there's one table within this database,
0:23 with the name of details,
0:25 and it's got these three columns.
0:28 So let's actually go to browse data.
0:31 This looks more like what you sort of want to see
0:33 when you visualize your database.
0:36 There's the table name, there's our name column,
0:39 address column, and our phone number column.
0:42 In the next video, I'm going to show you
0:45 how to set this up automatically.