Mathew K Analytics

Learn SQLite with free notebooks

7 free video lessons that use SQLite, each with a downloadable Jupyter notebook and, where needed, the dataset. Learn SQLite by working through real examples.

SQL Fundamentals for Data Analysts | Data Analytics #1612 min
Lesson 16

SQL Fundamentals for Data Analysts | Data Analytics #16

📊 Dataset · 📓 Notebook · SQLite · pandas
SQL Joins & Aggregations Explained | Data Analytics #1712 min
Lesson 17

SQL Joins & Aggregations Explained | Data Analytics #17

📓 Notebook · SQLite · pandas
Python + SQL: Real Analyst Queries | Data Analytics #1812 min
Lesson 18

Python + SQL: Real Analyst Queries | Data Analytics #18

📓 Notebook · SQLite · pandas
SQL for Python Users with sqlite326 min
Lesson 11

SQL for Python Users with sqlite3

📊 Dataset · 📓 Notebook · SQLite · pandas
How to Import and Export Data in Pandas: CSV, Excel, JSON, and SQL Explained17 min
Lesson 7

How to Import and Export Data in Pandas: CSV, Excel, JSON, and SQL Explained

📓 Notebook · pandas · NumPy · SQLite
Introduction to SQL for Supply Chain Analysts23 min
Lesson 12

Introduction to SQL for Supply Chain Analysts

📓 Notebook · pandas · SQLite
Comparing SQL and Pandas for Effective Financial Reporting and Data Analysis31 min
Lesson 14

Comparing SQL and Pandas for Effective Financial Reporting and Data Analysis

📓 Notebook · pandas · NumPy · SQLite