Maria A. Nieto-Santisteban

23-September-05

SQL Directory Content: Set of examples in SQL to create, update and query relational databases.

SDSS (Sloan Digital Sky Survey)
 | 
 SQLServer 
  |
   - spTestQueries.sql contains the stored procedure that executes and benchmark
	37 queries with those questions that SDSS astronomers consider the most 
	common questions. You can learn a lot from the queries included in spTestQueries

	You may execute it using MyBestDR3 
	
	MyBestDR3 database
	http://www.skyserver.org/myskyserver/

	in Query Analyzer type

	USE MySkyServerDR3
	EXEC spTestQueries

  |
   - SDSS_Queries.sql contains all the queries included in the SQL course that run with SDSS data


SPOCS (Spectroscopic Properties of Cool Stars)
 |
  - data: set of description & data files that populate the SPOCS database 

 |
  - mySQL: set of SQL scripts to create and query the SPOC database using MySQL.
     |
      - HowTo.txt contains instructions about running SQL commands on both Windows and Linux/Mac 
        platforms.

 |
  - SQLServer: set of SQL scripts to create and query the SPOC database using Microsoft SQL Server