Training:SummerSchool2016:Programme:SQLGIT

Introduction to SQL Databases and Version Control with Git

This tutorial is intended as an introduction to two powerful tools for software development: SQL databases and version control.

Relational databases are a fantastic tool for storing, organizing, and aggregating data. The majority of databases in use today utilize SQL as a language with which to interact with and manage data. During the morning session, we will cover the basics of using SQL to create and manage databases using SQLite, a lightweight and cross-platform database engine. Additionally, we will cover how to use R and Python to interact with data stored in a SQLite database.

Version control is a method of intelligently managing code for any project, enabling programmers to collaborate, keep track of changes, track down bugs, and maintain multiple versions/backups of their software. During the afternoon tutorial, we will go over the basics of version control using Git, as well as how to host and collaborate on your coding projects with online services like GitHub and Bitbucket.