Intro

Importing SqLite

Setting up a connection

Opening a.sql file

Running a single SQL statement

Close connection

Running the script with a different file name

Specifying the location of the sqlite file

Re-running the script

Conclusion

Intro

Import SQLite Python module

Create/Connect a SQLite database

Create a table

Insert records

Query records

Using WITH statement

Brief Introductory Talk (skippable)

Connecting Python with a new database

Sqlite Datatypes

DB Browser (Database "Interface" - optional!)

Create Tables

Insert Values into a Table

Querying the Database (SELECT statement)

fetchall() and fetchone() / multiple rows

Iterating over the cursor

Inserting Python variables into a SQL table

Flexible inputs

Using a constructor (OOP) to fill tables (bad practice see description)

Up Next / Thanks for watching :-)

Build a basic console application

Download and install DB Browser for SQLite3

Designing the database

Import SQLite3 and connect to the database

Adding rows to the database with CREATE

Changing rows in a database with UPDATE

Deleting a row from a database with DELETE

Reading rows from a database with SELECT

Welcome

Downloading SQLite Studio

Permanent Connections

Viewing Columns

Refreshing a database

Editing a Table

Exporting a table

Database Management

Toolbar

Conclusion

Query and Create a Sql a Database in Python

Create a Connection

Database Cursor

SQLite is an awesome little database that comes bundled with Python

Getting started with SQLite

Importing sqlite3

Setting up a try-except block

Creating a table

Closing the database connection

Inserting data into SQLite

Inserting data into a table

Selecting data from a table

Conclusion

Importing sqlite3 model

Connecting to the database

Creating a cursor

Inserting data

Inserting values into a table

Running the script

Installing sqlite3

Browsing a database

Printing data

Conclusion

Intro to SQLite Database

Create and Connect to a SQLite Database

DB Browser for SQLite

Query All Table Names In A Database

Query Results From Table

Query Using Pandas

Create New Table in SQLite

Save Values Into SQLite Database

Update And Revise Data

Delete Records

Delete Entire Table

Introduction

A look at SQLite

Create a Database

Create a Table

What is SQLite?

Create a Connection Object

Creating a Table

Iterating Through Query Results

Autocommit

String Formatting

Inserting a Second Employee

Making your SQLite code more Pythonic

Inserting data into the database

Conclusion

Video Intro

Video Setup

Method 1

Method 2

What Is Sqlite Database

Interact with an Sqlite Database in Our Python Scripts

Constraints

Execute the Sql Command To Create the Database Table

Inserting a Single Row

To Insert Multiple Rows

Fetch the Database Table Rows

Update a Table Row

Delete Sqlite Table Rows

Example To Demonstrate Transactions

Edit the System Environment Variables

Create a Database

Create a Table

What Is A Database

Install Python

Install Git Bash Terminal

Connect to Database in Python

Create A Table

Insert One Record Into Table

Insert Many Records Into Table

Query and Fetchall

Format Your Results

Primary Key

Use The Where Clause

Update Records

Delete Records

Order Results

And/Or

Limiting Results

Delete (Drop) A Table And Backups

Unit 18 Our App - Show All Function

Unit 19 Our App - Add A Record Function

Unit 20 Our App - Delete a Record Function

Unit 21 Our App - Add Many Records Function

Unit 22 Our App - Where Clause Function

Introduction

What is SQLite

Why use SQLite with Python?

Open Anaconda to navigate Jupyter Notebook (link in description to download anaconda)

Launch Jupyter Notebook from Anaconda

How to retitle or rename your workbook in Jupyter Notebook

How to title text using markdown in Jupyter Notebook (Header)

Step 1: Install & Import Required Libraries

Step 2: Create a New SQLite Database and Table

Step 3: Insert Sample Data into the SQL Table that was created in step 2.

Step 4: Run SQL Queries inside Jupyter Notebook

Step 5: Perform Data Analysis Using SQL Queries

Step 6: Visualization SQL Query Results Using Python

the output of the bar graph for SQL query results

Step 7: Close the SQL connection in Jupyter Notebook.

Closing and overview of everything we learned

Importing sqlite3 library

Making a connection

Creating a Cursor

Creating a table

Inserting Data

Inserting a new row

Inserting a third row

Commit and Close Connection

Running the code

Conclusion