Beginning SQL Queries

Beginning SQL Queries, 2nd Edition 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 increasingly today includes those using so-called NoSQL databases, because a strong trend in the industry is to make those databases accessible from SQL after all, at least for reporting purposes, and for analysis. Beginning SQL Queries, 2nd Edition 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.

Broad appeal Developers, web designers, database administrators, even power users working with Microsoft Access need to know something of SQL Clarity Author's previous book, Beginning Database Design, has established her as someone who writes with exceptional clarity about database topics Succinctness Beginning Queries with SQL does not waste readers' time. It covers the ground in far fewer pages than do competing books

Autorentext
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.

Zusammenfassung

Beginning SQL Queries, 2nd Edition 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 increasingly today includes those using so-called NoSQL databases, because a strong trend in the industry is to make those databases accessible from SQL after all, at least for reporting purposes, and for analysis. Beginning SQL Queries, 2nd Edition 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.

Inhalt

1. Relational Database Overview.- 2. Simple Queries on One Table.- 3. A First Look at Joins.- 4. Nested Queries.- 5. Self Joins.- 6. Multiple Relationships Between Tables.- 7. Set Operations.- 8. Aggregate Operations.- 9. Window Function.- 10. Efficiency Considerations.- 11. Approaching A Query.- 12. Common Problems.- Chapter 13: Appendix 1: Sample Database.- Chapter 14: Appendix 2: Relational Notation.