Database Clinic: SQLite

Introduction

• Welcome
• The Database Clinic series
• What you should know
• Use the exercise files

1. SQLite in Five Minutes

• A brief overview of SQLite
• Strengths of SQLite
• Weaknesses of SQLite

2. Create a Database

• Database creation
• Overview of solution
• SQLite import with Firefox
• SQLite import with DB Browser for SQLite
• SQLite import with SQLite3 command line tool

3. Join Two Datasets

• Join datasets
• Overview of solution
• Import the accidents data using Python
• Import the vehicles data using Python
• Import Excel files using Python
• Calculations with SQLite and Python
• Code review for R

4. Search a Database

• Search a database
• Overview of solution
• Correct information, wrong format
• Subqueries and queries in SQLite

5. Create, Read, Update, and Delete Operations

• CRUD operations
• Overview of solution
• Create records in SQLite with Python
• Update records in SQLite with Python
• Delete records in SQLite with Python
• Read records in SQLite with Python
• CRUD operations in SQLite with R

6. Averages and Calculations

• Calculations
• Overview of solution
• Create a demographic split table
• Create a forecast
• Insights on this problem

Conclusion

• Next steps