Beginning SQL queries : from novice to professional /

Show other versions (2)

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

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Churcher, Clare (Author)
Format: Electronic eBook
Language:Inglés
Published: [United States] : Apress, 2016.
Edition:Second edition.
Series:Expert's voice in SQL.
Subjects:
SQL (Computer program language)
Querying (Computer science)
Database management.
Computer programming.
Relational databases.
Database searching.
SQL (Langage de programmation)
Bases de données > Interrogation.
Bases de données > Gestion.
Programmation (Informatique)
Bases de données relationnelles.
online searching.
computer programming.
Programming & scripting languages: general.
Data mining.
Computer programming > software development.
Algorithms & data structures.
Databases.
COMPUTERS > Programming Languages > SQL.
Computer programming
Database management
Relational databases
Databases
Handbooks and manuals
Online Access:Texto completo (Requiere registro previo con correo institucional)
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