Databases + Python with SQLite3 - Part 2 - Foreign Keys

Показать описание

In this video, we cover creating a one-to-many relationship between two tables in a database and how we can make use of that relationship once we've done that.

Make sure to watch the first part before tackling this one:

Link to code:

#sql #python #sqlite3

00:00 - Intro
00:19 - Looking at the Tables
02:35 - Creating Tables with Foreign Keys
06:14 - Inserting into the Tables
08:16 - Querying the Tables - Using the Relationship

#python #coding #databases

The CS Classroom

Рекомендации по теме

Комментарии

Hey! I just wanted to say thanks for this tutorial, it's really priceless. It helped me fix a bug in my university project which I've been trying to fix for 3 days. I'll reference this video in my report.

karolinalencina

This was the first time I see an explanation of how to use foreign keys in sqlite3. Great Job. Thank you.

aavalos

Thank you this really helped me understand basic sql I needed for my college assignement

andrewmaksimovich

Gracias por el video, me fue de bastante utilidad, un abrazo.

Karlitosforever

Tysm for this tutorial. Im trying to learn python + databases on my own and sometimes its hard to find good and simple explanations for things. Your's is easy to understand even for me (since im spanish). Also, I would like to ask you if there is anyway to, only accesing to the patient table, get the name of the doctor.
Very nice video and thank you beforehand :)

Killerelcraftero

Thanks so much! Because I've done stupid mistake and couldn't grasp it

dmitrykrivushkin

Thank you for this video. It is best explanation to tell Foreign KEY use on Sqlite. But It would be more better If you would show DELETE function too... When Delete Doctor to Delete Patients too..

mevlutademaj

Привет, ты молодец, хороший тон начинать с самого кода 👍

sanchenso

Great video, I was just wondering how you got that purple/pink cursor thing for your video, other than that, your tutorials seem great, surprised not many people know about you

technocuber

Hello can you show how to use join functions on the tables? Thank you!

colt

hi im newbie in databases. but what if a patient have multiple doctors? i need to create a third table or is there better way?

dokerbd

A vaccine passport system ?? What’s next, Big Brother is watching you software? 😂

robertweekes

Databases + Python with SQLite3 - Part 2 - Foreign Keys

Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

SQLite Databases With Python - Full Course

Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries

Databases + Python with SQLite3

Creating SQLite Databases With Python | Python Tutorial

SQLite Backend for Beginners - Create Quick Databases with Python and SQL

Databases + Python with SQLite3 - Part 2 - Foreign Keys

SQLite Database With Python - #24

Build a Team Task Manager with Python & Flask | Role-Based Login + SQLite + Lofi Vibes

How to create Databases in Python with SQLite

How to store data with Python and SQLite3

SQLite in Python || Python Tutorial || Learn Python Programming

Create sqlite3 Database with Python

How to create a Database with sqlite3 and Python - Part 1

How To Use SQLite Database In Python For Beginners

Python SQLite Tutorial: Build a Python project with a SQLite database

Create and Query SQLite Database in Python - SQLite Python Tutorial

Master SQLite in Python in under 60 seconds! #database #code #python

python sqlite3 | SQLite database | python advanced topic

What is SQLite (DB Create and Connection) & How to Create Table in Python

Utiliser Python pour interagir avec une base de données (module sqlite3)

The Beginners Guide to SQLite with Pandas | Python | Create DB | Create tables | Insert & Update

Display Data from Sqlite3 To Tkinter Window

DATA SCIENCE SKILLS: Gentle Introduction to sqlite3. Python, SQLite and Databases