- HomePage
- Program
- Dates
- Supporters
- SOC
- Presenters
- Registration
- Participants
- Location & Travel
- Accommodation
- Software
- Feedback
SQL tutorial
There are three options for this tutorial session.
Option 1
Investigate some existing astronomy databases that are available online. The SDSS database, which has lots of tutorial examples, and the OpenSkyQuery site which has a range of different databases you can query, and also some sample queries.
Resouces for this session:
- The SDSS database
- The SDSS SQL tutorial
- A good place to start is The SDSS sample queries
- The SDSS Schema browser lets you explore the structure of the SDSS database.
- Open Sky Query
- GALEX SQL form
Option 2
If you want to see more of the nuts and bolts of using SQL, and got MySQL installed successfully on your laptop, you can try our tutorial. This tutorial uses some sample data from the O'Reilly book Learning SQL that you can download here.
Resources for this session:
Option 3
If you are more interested in setting up a database you can do our MySQL tutorial. This takes you through setting up a few simple databases. You could build on this in the project session on Friday to set up a database of your own astronomy data.
Resources for this session: