Mastering PyCharm Transcripts
Chapter: Databases
Lecture: Your turn: Databases

Login or purchase this course to watch this video and the rest of the course contents.
0:01 Databases are really front and center in PyCharm.
0:05 We saw we can add existing databases to our database explorer
0:09 and use all sorts of cool tools against it
0:12 and even have those schemas work with the editor itself.
0:16 So it's your turn to play with databases in PyCharm.
0:20 Over here on github under 5-databases
0:24 you'll see there's some steps to go through here.
0:27 First thing I am going to do is open an existing project
0:29 which is database project, same folder right there
0:32 and then open this up and it will come with a folder and a SQLite file
0:36 so we're going to start by opening this SQLite database in PyCharm
0:41 so we can explore it, and one of the important things that's going to happen here
0:46 is you may configure the drivers to actually understand SQLite for later projects,
0:50 once and for all on your machine, so that's cool.
0:53 We're going to open up this existing project and explore it
0:56 we're going to write some queries against it,
0:58 to find some interesting tracks,
1:00 this is like an album store with artist, album, tracks, users and so on
1:05 and we're going to also use the diagram tools
1:08 to understand how things like track and album,
1:11 what they look like and how they are related to each other.
1:14 And finally, you're going to see the really amazing feature
1:17 of when you have SQL embedded within strings in Python files
1:20 how you get both SQL language and database schema autocompletion
1:25 which is just amazing.
1:28 Alright, so get out there and play with this example
1:30 and enjoy the database stuff.