Introduction to relational databases

Introduction

SQL is the way to create and access relational databases. See here for why someone working in statistics or machine learning should know about SQL.

Overview of relational databases

Documentation for databases

• Website for MySQL

• Website for SQLlite database

Introduction to SQL

The information below is a generic introduction to using SQL to create, access and update a relational database.

• Lectures on SQL from the Khan academy

• Tutorial on SQL from w3schools You can use the website to try SQL commands.

Using SQL from python

One simple way to learn SQL is to use the sqlite module in python.

• A tutorial to using SQL with python

• A short tutorial on using SQL with python

Help with debugging SQL

It is important to be able to read data from SQLlite files directly into python. However, it is useful to be able to read SQLfiles independently

• For small SQLlite files you can use this online site to read the SQLlite file.

• There is a useful command line tool which can run SQL commands.