Python - SQL Introduction with SQLite

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

[josephnyamekeblay]

One in a million lecturer. Youre blessed to self learning computer scientist

[Angular]

Thanks Eli! This is the content that is the reason why you are a legend! I just wish that we could get more people to watch these great videos. I agree that the only way to learn to is by using it.

[societyreborn]

Eli as a non computer person, im wishing for the day the daily blob returns

[eldarmammadov]

Wow you are great!! Just needed sth more than realistic with sqlalchemy Core and flask_sqlalchemy

[andromilk]

Are you going to do your DailyBlobs somewhere else?

[usernamegoeshere]

people in the world, Eli, also don’t care about online education. soon AI will do all the dev work for us