13. SQL with SQLite

• Reference Book: Beaulieu, A. (2020). Learning SQL: Generate, manipulate, and retrieve data.

• Data Source: Kartoun, Uri (2018): A 100-patient database. figshare. Dataset. https://doi.org/10.6084/m9.figshare.7040039.v1

• 13.1. Creating Tables
• 13.2. SQL Query Primer
• 13.3. Filtering
• 13.4. Sets
• 13.5. Grouping and Aggregates
• 13.6. Subqueries
• 13.7. Conditionals
• 13.8. Analytic Functions
• 13.9. Normalization
• 13.10. Normalization Old
• 13.11. Python and SQLite3
• 13.12. India Export Database
• 13.13. Steps to normalizing India export database
• 13.14. Soccer Database
• 13.15. Tables