Churcher Beginning SQL Queries

From Novice to Professional
2. Auflage 2016
ISBN: 978-1-4842-1955-3
Verlag: APRESS
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 234 Seiten, eBook

Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important — in the database world — SQL language. Anyone who does any work at all with databases needs to know something of SQL, and that is evidenced by the strong sales of such books as Learning SQL (O'Reilly) and SQL Queries for Mere Mortals (Pearson). Beginning Queries with SQL is written by the author of Beginning Database Design, an author who is garnering great reviews on Amazon due to the clarity and succinctness of her writing.

Zielgruppe

Research

Autoren/Hrsg.

Churcher, Clare

Inhaltsverzeichnis

1. Relational Database Overview2. Simple Queries on One Table3. A First Look at Joins4. Nested Queries5. Self Joins6. Multiple Relationships Between Tables7. Set Operations8. Aggregate Operations9. Windown Function10. Efficiency Considerations11. Approaching A Query12. Common Problems13. Appendix 1: Sample Database14. Appendix 2: Relational Notation

Über Autor(innen)

Clare Churcher (B.Sc. (Hons), Ph.D.(physics)) has designed several databases for a variety of large and small projects. She is a currently a Senior Lecturer and Development Manager for Applied IT at Tai Poutini Polytechnic.   She spent two years as a Business Analyst for a large international software development company, and prior to that nearly two decades as a senior faculty member of the Applied Computing Group at Lincoln University where her teaching included Analysis and Design, Database, and Programming papers. In 2006 she won a Lincoln University Excellence in Teaching Award.  She has supervised over 70 undergraduate projects designing databases for small projects.