Skip to Main Content (Press Enter) Toggle side nav
Practical SQL, 2nd Edition by Anthony DeBarros

Practical SQL, 2nd Edition

Best Seller
Practical SQL, 2nd Edition by Anthony DeBarros
Paperback $39.95
Jun 22, 2021 | ISBN 9781718501065

Also available from:

See All Formats (1) +
  • Jun 22, 2021 | ISBN 9781718501065

    Also available from:

  • Jun 22, 2021 | ISBN 9781718501072

    Available from:

*This title is not eligible for purchase to earn points nor for redemption with your code in the Reader Rewards program

Product Details

Table Of Contents

Introduction

1. Setting up pgAdmin
2. Creating Your First Database and Table
3. Beginning Data Exploration with SELECT
4. Understanding Data Types
5. Importing and Exporting Data
6. Basic Math and Stats
7. Joining Tables in a Relational Database
8. Table Design that Works for You
9. Extracting Information by Grouping and Summarizing
10. Inspecting and Modifying Data
11. Statistical Functions in SQL
12. Working with Dates and Times
13. Advanced Query Techniques
14. Mining Text to Find Meaningful Data
15. Analyzing Spatial Data with PostGIS
16. Working with JSON Data
17. Saving Time with Views, Functions, and Triggers
18. Using PostgreSQL from the Command Line
19. Maintaining Your Database
20. Identifying and Telling the Story Behind Your Data

Appendix A. Additional Resources

Be the first to know!
More from Anthony DeBarros and book picks sent right to your inbox
More from Anthony DeBarros and book picks sent right to your inbox
By clicking SIGN UP, I acknowledge that I have read and agree to Penguin Random House’s Privacy Policy and Terms of Use.
Dismiss
Thanks!
Something awesome is on its way.
Back to Top