search close
search
0
cart
close
You have no products in your basket yet
left
Tech Categories
Best Sellers
New Releases
Books
Videos
Audiobooks
Articles
Newsletters
Free Learning
right
Introduction to SQLite Databases for Python Programming [Video]

Introduction to SQLite Databases for Python Programming: Learn to use SQLite databases with Python through a hands-on approach [Video]

By John Elder
$183.99
Video May 2019 1 hours 27 minutes 1st Edition
Video
$183.99
Subscription
$15.99 Monthly
Video
$183.99
Subscription
$15.99 Monthly

What do you get with a video?

Feature icon Download this video in MP4 format
Feature icon Access this title in our online reader with advanced features
Feature icon DRM FREE - Read whenever, wherever and however you want
Buy Now

Product Details

Publication date : May 29, 2019
Length 1 hours 27 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781838982867
Category :
Data
Languages :
Python (Intermediate)
Concepts :
Database Programming
Tools :
SQLite (Beginner)
toc View table of contents

Key benefits

  • Learn how to use SQLite databases with Python
  • Create databases and tables
  • Insert, sort, and extract specific data

Description

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

What do you get with a video?

Feature icon Download this video in MP4 format
Feature icon Access this title in our online reader with advanced features
Feature icon DRM FREE - Read whenever, wherever and however you want
Buy Now

Product Details

Publication date : May 29, 2019
Length 1 hours 27 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781838982867
Category :
Data
Languages :
Python (Intermediate)
Concepts :
Database Programming
Tools :
SQLite (Beginner)

Table of Contents

3 Chapters
Installation Packt Packt
Introduction
Install Python
Install Sublime Text and Git Bash Terminal
Using SQLite With Python Packt Packt
Create SQLite Connection
Create A Database Table
Insert One Record into The Table
Insert Many Records into The Table
Query and Fetchall
Format Results
Primary Key ID
Where Clause
Update Records
Delete Records
Order Results By
And / Or
Limiting Results
Drop Table
Build A Simple Database App with Python Packt Packt
Our App - Show All Function
Our App - Add A Record Function
Our App - Delete a Record Function
Our App - Add Many Records Function
Our App - Where Clause Function

Recommendations for you

left arrow
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
May 2023 456
Ebook
€22.99 €32.99
€41.99
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Feb 2022 774
Ebook
€21.99 €31.99
€38.99
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Jul 2020 822
Ebook
€23.99 €34.99
€43.99
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Jun 2022 712
Ebook
€20.98 €29.99
€37.99
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Nov 2022 330
Ebook
€19.99 €28.99
€35.99
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Aug 2023 462
Ebook
€20.98 €29.99
€37.99
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
Feb 2023 250
Ebook
€32.99 €47.99
€59.99
€35.99
Et al.: Because not all research deserves a Nobel Prize
Et al.: Because not all research deserves a Nobel Prize
Aug 2023 230
Ebook
€7.99 €11.99
€14.99
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Dec 2019 772
Ebook
€21.99 €31.99
€38.99
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
May 2023 324
Ebook
€20.98 €29.99
€37.99
right arrow

Customer reviews

filter Filter
Top Reviews
Rating distribution
star-icon star-icon star-icon star-icon star-icon 0
(0 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 0%
1 star 0%

Filter reviews by

No reviews found

People who bought this also bought

left arrow
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Sep 2022 584
Ebook
€22.99 €32.99
€41.99
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Dec 2021 540
Ebook
€17.99 €25.99
€32.99
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Nov 2021 288
Ebook
€22.99 €32.99
€41.99
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Sep 2022 480
Ebook
€17.99 €25.99
€31.99
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Dec 2021 578
Ebook
€19.99 €28.99
€37.99
right arrow

Authors (1)

Profile John Elder
Linkedin
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.
Read more
See other products by John Elder
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Packt Packt
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Packt Packt

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? Packt Packt

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.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Packt Packt

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.