From Novice to Professional
Buch, Englisch, 234 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 4946 g
ISBN: 978-1-4842-1954-6
Verlag: Apress
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.
Zielgruppe
Research
Autoren/Hrsg.
Fachgebiete
Weitere Infos & Material
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.