Cover Image

Beginning SQL Queries From Novice to Professional /

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

Full description

Main Author: Churcher, Clare. (Author, http://id.loc.gov/vocabulary/relators/aut)
Corporate Author: SpringerLink (Online service)
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2016.
Edition:2nd ed. 2016.
Subjects:
Database management.
Programming languages (Electronic computers).
Data mining.
Computer programming.
Data structures (Computer science).
Database Management.
Programming Languages, Compilers, Interpreters.
Data Mining and Knowledge Discovery.
Programming Techniques.
Data Structures.
Online Access:https://doi.org/10.1007/978-1-4842-1955-3
Table of Contents:
  • 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.

Similar Items