Tutorials
Ajuda do DR7
 Arquivos: Introdução
 Descrições das Tabelas
 Navegador Schema
 Glossário
 Algoritmos
 Introdução a SQL
 Guia Formulário Busca
 Limites de Busca
 Como Fazer
     - Busca
     - Gráfico
 Perguntas Frequentes
 API
 sdssQA
 Download
 Sites do SkyServer
 Página de Tráfego
 Navegadores Web
 Contatar Help Desk (em inglês)
Busca
 Back
 1. Introdução
 2. Um Query Simples
 Exercício
 3. Usualmente Buscada
 4. Mais Exemplos
 Exercício
 5. Multiple Tables
 Practice
 6. Aggregate Fcns.
 7. Group By
 8. Order By
 Practice
 9. Views
 10. Functions
 Practice
 11. Conclusion

Congratulations!

You've worked hard to get here, but you've done it - you've finished SkyServer's SQL tutorial. You now know enough to search SkyServer's massive database for just the data you need. Happy searching!

Just for fun, here are a few challenge questions. With everything you now know, you should be able to write SQL queries to answer these questions. If you figure them out, E-mail the queries to us, and we just might put them up on these pages!

Challenge 1. What percentage of galaxies have spectral redshifts measured? What percentage have photometric redshifts taken? What are the advantages of using photometric redshift? Try to compare photometric and spectral redshift; how accurate are photometric redshifts?

Challenge 2. What are the limits in ra and dec of stripes 42 and 43, two of the SDSS's diagonal stripes?

Challenge 3. Look at colors and spectra of stars, and find stars consistent with white dwarfs. Create a list of white dwarfs in the SDSS database.

Challenge 4. What are the largest galaxies in the SDSS, in terms of size?
HINT: Look at surface brightness and ellipticity.

Challenge 5. Find all objects with spectra classified as unknown.

Challenge 6. Find the broad absorption line (BAL) quasars in the SDSS database. At what redshifts are most BAL quasars found?

Challenge 7. Find variable stars in the SDSS (stars imaged more than once whose magnitudes changed by more than 0.1 between observations). How variable are the stars?


Formato HTML XML CSV

Digite o seu query SQL na caixa de texto. A busca é limitada em 90 segundos e 1000 linhas.