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

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

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

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

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

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

Comparing Reading a Data Set in Python versus Sql Lite Sqlite

Create that Database

Speed of Python Improvements

Create Sqlite Db

Intro

Create a simple database

Create a Cursor

Inspecting the database

Testing the query

Running the query

SQL Injection

Querying the database with a password

Prepared statements

Conclusion

Tutorial starts

SQLite & Pandas

Introduction

A look at SQLite

Create a Database

Create a Table

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

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

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

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

Introduction

Creating Accounting database

Creating Employees table

Fetching data from employees table

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?