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

Create a New Database

Tables

Memory Test

Sqlite Types

Execute Script

Sql Query in Python

Essential Features

Intro

Implementing Referential Integrity

Using the connection object

Renaming columns

Create a DataFrame

Creating a foreign key constraint

Querying metadata

Using Check Constraints

Aggregations

Wrap Up

Tutorial starts

SQLite & Pandas

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

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

Intro

Import SQLite Python module

Create/Connect a SQLite database

Create a table

Insert records

Query records

Using WITH statement

Downloading Dynamic Link Library

Add Sqlite3 to PATH

Create a database

Create a Table

Primary Key

Insert Data

Selecting Data

Fetch Inserted Data

Committing Data

Conclusion

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

Welcome

What is SQLite used for?

Establishing a Connection

Creating a table

Fetching data

Using Demo Databases

Close Connections

Using Substrings

Using Postgres with Python

Conclusion

Intro

Considering SQLite Studio

Creating the Tables

Using pandas_read_sql_query

Append vs Replace

Loading the transaction data

Discussion of modified data

Using the ON_CONFLCT clause

Fixing Error Notices

Conclusion

Welcome

A Word of Caution

Connecting to a database

Importing sqlite3

Using fetch_all()

Reading Comma-Separated Values (CSV)

Returning Query Results as DataFrames

Querying a DataFrame

Importing pandas-iosql

Why use SQLite?

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

Comparing Reading a Data Set in Python versus Sql Lite Sqlite

Create that Database

Speed of Python Improvements

Create Sqlite Db

Method Fetch Many

Fetch All

List Comprehension

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

O que vamos aprender sobre acesso a bancos de dados

Apresentação da Aula 17 e preparação para o exercício

Curso de Python também disponível no Estudonauta

Como funciona o acesso a um banco de dados

SQLite3, conexão e cursor: os conceitos fundamentais

Preparando o banco de dados no PyCharm

Criando o arquivo Python para acessar o banco

Executando consultas SQL com SELECT

Recuperando registros com fetchall()

O problema do consumo de memória com fetchall()

Como buscar registros individualmente com fetchone()

Percorrendo os resultados com o laço for

Acessando os campos das tuplas e formatando os resultados

Utilizando sqlite3.Row para acessar campos pelo nome

Boas práticas: gerenciando recursos com with

Tratamento de erros no acesso ao banco de dados

Criando uma busca de amigos pelo nome

O que é SQL Injection e como proteger as consultas

Contando os resultados encontrados com enumerate()

Resumo da aula e apresentação do Desafio 41

Desafio 41: mensagens para buscas sem resultados

Como tratar datas inválidas e vazias

Formatando datas e calculando a idade real

Recapitulando os requisitos do desafio

Encerramento e preparação para a próxima resolução

Db Browser for Sqlite

Python Code

Cursor

Multi-Line Command

Creating a Table

Primary Key

Topics and References

Sql To Insert into a Table

Interpolation

Important Points