Language of SQL, The, 2nd edition

Published by Addison-Wesley Professional (26 July 2016) © 2017

  • Larry Rockoff
Products list
£20.99
Instant access
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
£20.99
Instant access
  • Available for purchase from all major ebook resellers, including InformIT.com

Title overview

A quick, clearly written introduction to the use of SQL to store and retrieve information

Table of contents

  • 1. Relational Databases and SQL
  • 2. Basic Data Retrieval
  • 3. Calculated Fields and Aliases
  • 4. Using Functions
  • 5. Sorting Data
  • 6. Selection Criteria
  • 7. Boolean Logic
  • 8. Conditional Logic
  • 9. Summarizing Data
  • 10. Subtotals and Crosstabs
  • 11. Inner Joins
  • 12. Outer Joins
  • 13. Self Joins and Views
  • 14. Subqueries
  • 15. Set Logic
  • 16. Stored Procedures and Parameters
  • 17. Modifying Data
  • 18. Maintaining Tables
  • 19. Principles of Database Design
  • 20. Strategies for Displaying Data
  • A. Getting Started with Microsoft SQL Server
  • B. Getting Started with MySQL
  • C. Getting Started with Oracle

Need help?Get in touch