Python - SQL Introduction with SQLite

Published: 06 September 2024
on channel: Eli the Computer Guy
5,982
319

RSVP for Classes at - http://www.SiliconDojo.com
Code and Notes at - https://github.com/SiliconDojo/Online...

Support Classes at - https://donorbox.org/etcg
Find All Classes at - https://www.elithecomputerguy.com
LinkedIn at -   / 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


Watch video Python - SQL Introduction with SQLite online without registration, duration hours minute second in high quality. This video was added by user Eli the Computer Guy 06 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,982 once and liked it 319 people.