#100DaysOfCode in Python Transcripts
Chapter: Days 79-81: Basic Database Access with SQLite3
Lecture: Your 3 day overview
0:00 All right, here's how we're going to break down
0:02 these 3 Days on SQLite3 Databases.
0:05 So to start off with you're going
0:07 to install SQLite db browser.
0:11 All right watch the video on that, get it done.
0:13 Then you're going to create your first database,
0:16 or your first sqlite three database, anyway.
0:19 And that's going to quickly be followed by
0:21 a script that generates a database for you.
0:25 So I'm going to demonstrate that for you,
0:26 and it's actually quite useful so, enjoy that one.
0:30 For Day 2, what I'd like you to start doing
0:33 is inserting data into the address book.
0:37 Okay this is the address book database
0:40 that you were going to create in Day 1.
0:42 So Day 2 is, so Day 1 is going to be create the database
0:47 Day 2 is going to be insert data into the database, okay?
0:52 And it's then going to quickly be followed up with
0:56 extracting that data, so pulling the data out with select.
1:01 Okay, all that's explained in the videos.
1:04 Now, Day three, what you're going to do is
1:09 apply everything you've learned into your own project.
1:14 Okay, so by the end of Day 2 you'll have created
1:17 the address book and you'd be able to pull data out
1:20 and insert data into it as you wish.
1:23 So now, try and replicate that
1:25 with something else you can think of.
1:26 Okay copy as much as you want.
1:28 Remember the purpose here is to just practice
1:31 with the code and once you have that down
1:33 if you still have time for Day three,
1:35 figure out how to edit the data in the database, okay.
1:41 So a quick one here is we are inserting
1:44 and extracting the data, we're not editing it.
1:48 Okay we don't cover that in the video,
1:51 so that's a nice little stretch goal for you.
1:52 So do your googling and play around with it
1:55 and see if you can edit the data,
1:57 that's your challenge for Day three.
1:59 And that's it, so those are really
2:01 the basics of sqlite three, move on to the first video
2:05 and enjoy the next couple of Days.