---

Anyone who does any work at all with databases needs to know something of SQL. This is a friendly and easy-to-read guide to writing queries with the all-important - in the database world - SQL language. The author writes with exceptional clarity.

---

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.

---

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. Windown Function 10. Efficiency Considerations 11. Approaching A Query 12. Common Problems 13. Appendix 1: Sample Database 14. Appendix 2: Relational Notation

---

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.

---