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.99
Feb 01, 2022 | ISBN 9781718501065

Also available from:

See All Formats (1) +
  • Feb 01, 2022 | ISBN 9781718501065

    Also available from:

  • Feb 01, 2022 | 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

Get the latest updates from Anthony DeBarros
And go from well-read to best read with book recs, deals and more in your inbox every week.
And go from well-read to best read with book recs, deals and more in your inbox every week.
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