Skip to content

Databases

Jump to bottom
Leon du Toit edited this page Mar 1, 2014 · 3 revisions

Relational - what it means to you

SQL

PostgreSQL

Tables, views and schemas

select and friends

Indexes

Functions

Other open source DBs

Want to add to the wiki?

Contents

Introduction

Getting started

Python

R

Javascript and d3

Language choices

Software fundamentals

Productivity tips

Command line

Version control

Code conventions and style

Documentation

Testing

Error handling

Configuration

Logging

Package management

Package development

Working with data

Delimited data

JSON data

Databases

REST APIs

Dates

Tabular data manipulation

Anonymisation

Visualisation

Exploration versus presentation

Important choices

Aspects of exploration

Tools for exploration

Aspects for presentation

Tools for presentation

Tools

Big data wat?

The cloud

Analytics systems

Programming resources

Helpful websites

Good books and articles

Clone this wiki locally