SQLalchemy Tutorial
Check out dentropys-sqlalchemy-tutorial
When you are done check out SQL for Data Scientists in 100 Queries
Questions
- Keywords
- Datatypes
- Restrictions
- Variable (Procedural SQL)
- Cursors
- Ref
- Trigger
Cursors
To Learn
- I need to learn how to back up a SQL Database
- I need to learn how to manage permissions in a SQL database
- I need to learn how to do database migrations
- I need to learn how to recover a SQL database form a backup
- I need to learn how to shard a SQL database
- I need to learn how to cluser a SQL database
Search String in Column
Select from_user, txt_body
from Messages
where txt_body
like '%id %' AND msg_type == "text"
sql - How to search for a substring in SQLite? - Stack Overflow
TODO
- Skipping Explit Forin Key's cause SQLite
- In SQL Alchemy we want Forein Key's
- I don't know how to use forein keys really