Free and open-source, SQLite is a popular database among developers for smaller projects, hobby projects, and even testing and development. When used with Python, one of the most powerful programming languages, they make a powerful combination.
In this course you'll learn the basics of using SQLite with Python. You'll get started with installing Python and SQLite. The course will then get you up to speed with creating databases and tables. To help you build on your knowledge further, you’ll get comprehensive insights into working with tables, including adding, updating, and retrieving specific data using standard SQLite commands. Finally, you’ll build a basic app to help reinforce all the things that you’ve learned through the course.
By the end of this course, you’ll have hands-on experience in effectively using SQLite with Python.
What you will learn
Explore the fundamental aspects of what a database can do
Install Python, SQLite, Sublime Text, and Git Bash
Gain practical knowledge by building an app Update and delete data from a database
Discover the technique of creating basic reports with data from your database
John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.
John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.
How can I download a video package for offline viewing?
Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.
How can I extract my video file?
All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.
How can I get help and support around my video package?
If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.
Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support
Why can’t I download my video package?
In the even that you are having issues downloading your video package then please follow these instructions:
Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.