Beginning SQL Queries From Novice to Professional /

• Κύριος συγγραφέας: Churcher, Clare (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress : Imprint: Apress, 2016.
• Έκδοση: 2nd ed. 2016.
• Θέματα: Computer science.; Computer programming.; Programming languages (Electronic computers).; Data structures (Computer science).; Database management.; Data mining.; Computer Science.; Database Management.; Programming Languages, Compilers, Interpreters.; Data Mining and Knowledge Discovery.; Programming Techniques.; Data Structures.

Get started on mastering the one language binding the entire database industry. That language is SQL, and how it works is must-have knowledge for anyone involved with relational databases, and surprisingly also for anyone involved with NoSQL databases. SQL is universally used in querying and reporti...

Πίνακας περιεχομένων:

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