SQLite is a really cool little file database that comes bundled with Python, giving you a very powerful platform to work with relational data, locally on your computer, without any need for a database server. This is particularly important for data projects involving many data sources where you need to have some persistence to the data you gathered. Because it is bundled with Python, you don't need to install anything to start using SQLite. We'll create a database, create a new table, insert some data, and then query that data and return it for display in our console. Easy! Related Videos: Getting Started with SQLite for Python You are watching this video now! How to Execute SQL from a File on SqLite Using Python https://www.youtube.com/watch?v=xkKvJVs3DR8 How to Select Data from SQLite https://www.youtube.com/watch?v=M41neF7E1go How to Output HTML from SQLite https://www.youtube.com/watch?v=mSiqZRpgrfY Migrate Data from MS Excel to SQLite and Back Again https://www.youtube.com/watch?v=CMckJ4Rgfe8 How to Use Dates in SQLite https://www.youtube.com/watch?v=DQsBxP6VkFw How to Create a Delimited Field in your SQLite Query with Python https://www.youtube.com/watch?v=a6wzSydlLGY How to Make an Interactive Map Using Python and SQLite Data https://www.youtube.com/watch?v=cFWq8wkpGJo For developers looking for a new role, check out and sign up: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering https://www.youtube.com/watch?v=GtJxGrmB8DI