Practical SQL, 2nd Edition

Debarros, Anthony

No Starch Press,US（2022/01発売）

No Starch Press,US（2022/01発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 464 p.
• 言語 ENG
• 商品コード 9781718501065
• DDC分類 005.756

Full Description

Second edition of the best-selling Practical SQL. An approachable guide to programming in SQL (Structured Query Language) that will teach even beginning programmers how to build powerful databases and analyze data to find meaningful information.

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