Digital Solutions

SQLite


Why choose SQLite?

recommended for SQLite: DB Browser for SQLite

Creating SQLite DBase in two steps, using DB Browser for SQLite:
Step One - New DatabaseStep Two - Add Data


Restaurant Database

restaurant.db
  1. install DB Browser for SQLite
  2. SELECT FROM
  3. WHERE
  4. AND OR NOT
  5. <, > & LIKE
  6. ORDER BY
  7. DISTINCT, IN & BETWEEN
  8. LIMITS
  9. SUM & AVG
  10. MIN & MAX
  11. COUNT & ALIAS
  12. GROUP BY & HAVING
  13. ARITHMETIC OPERATORS
  14. SUBQUERIES
  15. ... now using Python:
  16. Connecting
  17. Displaying
  18. Interacting
  19. Inserting
  20. Creating, Updating & Deleting
  21. Case Studies from class (I)
  22. Case Studies from class (II)
orders.db to complete:
  1. JOIN (joining two tables, the default join in SQLite is an inner join)


Alchemy Database

alchemy.db
  1. installation
  2. select from where