Python - SQL Introduction with SQLite

Eli the Computer Guy September 6, 2024
Video Thumbnail
Eli the Computer Guy Logo

Eli the Computer Guy

@elithecomputerguy

About

No channel description available.

Video Description

RSVP for Classes at - http://www.SiliconDojo.com Code and Notes at - https://github.com/SiliconDojo/Online-Classes Support Classes at - https://donorbox.org/etcg Find All Classes at - https://www.elithecomputerguy.com LinkedIn at - https://www.linkedin.com/in/eli-etherton-a15362211/ Programming is about data, the question is how to manage the data. Databases store text data and makes it easy to add, update and find data that you have stored. SQL (Structured Query Language) is the language used to interact with Relational Databases. It is used by systems such as MySQL, MariaDB, Postgres and SQLite. SQLIte is a dirt simple Relational Database that gives you the power of SQL with the administrative overhead of a text file. It is fast, easy to use, AND has near no security built in. We will learn how to add SQLite to our Python projects so that we can add the capability to store and request data easily. The class will go over: - Relational Database Basics - Basic SQLite Management - SQL Schemas - Creating Databases and Tables in SQLite - Select Statements - Insert Statements - Update Statements - Table Joins - Connecting Python Scripts to SQLite

You May Also Like

Upgrade Your Gaming Setup

AI-recommended products based on this video

Loading...
ASUS TUF Gaming GeForce RTX ™ 5070 Ti 16GB GDDR7 OC Edition Gaming Graphics Card (PCIe® 5.0, HDMI®/DP 2.1, 3.125-slot, Military-Grade Components, Protective PCB Coating, axial-tech Fans)

ASUS TUF Gaming GeForce RTX ™ 5070 Ti 16GB GDDR7 OC Edition Gaming Graphics Card (PCIe® 5.0, HDMI®/DP 2.1, 3.125-slot, Military-Grade Components, Protective PCB Coating, axial-tech Fans)

(433)
999.99
1K+ bought in past month
Loading...
ASUS TUF Gaming A16 (2024) Copilot+ PC Gaming Laptop, 16 16:10 165Hz Display, AMD Ryzen™ AI 9 HX 370, NVIDIA® GeForce RTX™ 4060, 16GB LPDDR5X, 1TB PCIe Gen 4.0 SSD, Wi-Fi 6E, Windows 11, FA608WV-DB94

ASUS TUF Gaming A16 (2024) Copilot+ PC Gaming Laptop, 16 16:10 165Hz Display, AMD Ryzen™ AI 9 HX 370, NVIDIA® GeForce RTX™ 4060, 16GB LPDDR5X, 1TB PCIe Gen 4.0 SSD, Wi-Fi 6E, Windows 11, FA608WV-DB94

(24)
1,599.00
PrimeFREE delivery Saturday, June 14
Loading...
MSI Thin 15 Gaming Laptop, 15.6" 144 Hz IPS Display, AMD Ryzen 9 8945HS, NVIDIA RTX 4060 8GB GDDR6, 32 GB DDR5, 2 TB SSD, with Windows 11 Pro, Office Pro Lifetime License, Mouse, USB C Flash Drive

MSI Thin 15 Gaming Laptop, 15.6" 144 Hz IPS Display, AMD Ryzen 9 8945HS, NVIDIA RTX 4060 8GB GDDR6, 32 GB DDR5, 2 TB SSD, with Windows 11 Pro, Office Pro Lifetime License, Mouse, USB C Flash Drive

(2,122)
1,559.99
FREE delivery Wednesday, June 11.
Loading...
Redragon RGPS-850W 80+ Gold 850 Watt ATX 3.0 & PCIe 5.0 Fully Modular Power Supply w/ 80 Plus Gold Certified, Compact 160mm Size, Smart ECO Low Noise RGB Fan, 100% Japanese Capacitors, Full Mod Cables

Redragon RGPS-850W 80+ Gold 850 Watt ATX 3.0 & PCIe 5.0 Fully Modular Power Supply w/ 80 Plus Gold Certified, Compact 160mm Size, Smart ECO Low Noise RGB Fan, 100% Japanese Capacitors, Full Mod Cables

(1,550)
114.99
PrimeFREE delivery Saturday, June 14
200+ bought in past month
Loading...
G.SKILL Ripjaws DDR4 SO-DIMM Series DDR4 RAM 32GB (2x16GB) 2400MT/s CL16-16-16-39 1.20V Unbuffered Non-ECC Notebook/Laptop Memory SODIMM (F4-2400C16D-32GRS)

G.SKILL Ripjaws DDR4 SO-DIMM Series DDR4 RAM 32GB (2x16GB) 2400MT/s CL16-16-16-39 1.20V Unbuffered Non-ECC Notebook/Laptop Memory SODIMM (F4-2400C16D-32GRS)

(2,521)
52.99
PrimeFREE delivery Saturday, June 14
Loading...
LG 32UR500K-B Ultrafine 32-inch 4K UHD (3840x2160) Computer Monitor HDR10 Built-in Speaker x2 OnScreen Control Reader Mode Flicker Safe Borderless Design HDMIx2 DisplayPort Black

LG 32UR500K-B Ultrafine 32-inch 4K UHD (3840x2160) Computer Monitor HDR10 Built-in Speaker x2 OnScreen Control Reader Mode Flicker Safe Borderless Design HDMIx2 DisplayPort Black

(95)
329.99
FREE delivery June 14 - 16
200+ bought in past month
Loading...
Lenovo V15 Laptop | 15.6" FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB PCIe SSD | HDMI | Type-C | Webcam | Wi-Fi | THUNDEROBOT Wireless Ergonomic Mouse | Windows 11 Pro | Black

Lenovo V15 Laptop | 15.6" FHD Anti-Glare Display | AMD Ryzen 7 7730U | 40GB RAM | 1TB PCIe SSD | HDMI | Type-C | Webcam | Wi-Fi | THUNDEROBOT Wireless Ergonomic Mouse | Windows 11 Pro | Black

(26)
$649.00$636.02
FREE delivery Jun 18 - 23
Loading...
Funny Cute Mouse Pad with Wrist Rest, Dumpster on Fire Ergonomic Mouse Pads Wrist Support for Desk, Mousepad for Wireless Mouse Gaming Laptop Work Home Desk Accessories Office Supplies Decor

Funny Cute Mouse Pad with Wrist Rest, Dumpster on Fire Ergonomic Mouse Pads Wrist Support for Desk, Mousepad for Wireless Mouse Gaming Laptop Work Home Desk Accessories Office Supplies Decor

(1,045)
7.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
ASUS TUF Gaming GeForce RTX ™ 5070 Ti 16GB GDDR7 OC Edition Gaming Graphics Card (PCIe® 5.0, HDMI®/DP 2.1, 3.125-slot, Military-Grade Components, Protective PCB Coating, axial-tech Fans)

ASUS TUF Gaming GeForce RTX ™ 5070 Ti 16GB GDDR7 OC Edition Gaming Graphics Card (PCIe® 5.0, HDMI®/DP 2.1, 3.125-slot, Military-Grade Components, Protective PCB Coating, axial-tech Fans)

(433)
999.99
1K+ bought in past month
Loading...
ASUS TUF Gaming A16 (2024) Copilot+ PC Gaming Laptop, 16 16:10 165Hz Display, AMD Ryzen™ AI 9 HX 370, NVIDIA® GeForce RTX™ 4060, 16GB LPDDR5X, 1TB PCIe Gen 4.0 SSD, Wi-Fi 6E, Windows 11, FA608WV-DB94

ASUS TUF Gaming A16 (2024) Copilot+ PC Gaming Laptop, 16 16:10 165Hz Display, AMD Ryzen™ AI 9 HX 370, NVIDIA® GeForce RTX™ 4060, 16GB LPDDR5X, 1TB PCIe Gen 4.0 SSD, Wi-Fi 6E, Windows 11, FA608WV-DB94

(24)
1,599.00
PrimeFREE delivery Saturday, June 14