MARC details
| 000 -LEADER |
|---|
| fixed length control field |
02218nam a22002777a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
NU |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20250108113345.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
250108b ph ||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
978-1-7185-0106-5 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
NUFAIRVIEW |
| Transcribing agency |
NUFAIRVIEW |
| 050 ## - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
QA 76.73 D43 2022 |
| 100 ## - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
DeBarros, Anthony |
| Relator term |
author |
| 245 ## - TITLE STATEMENT |
|---|
| Title |
Practical SQL : |
| Remainder of title |
a beginner's guide to storytelling with data / |
| Statement of responsibility, etc. |
Anthony DeBarros |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
2nd edition |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. |
|---|
| Place of publication, distribution, etc. |
San Francisco, California : |
| Name of publisher, distributor, etc. |
No Starch Press, Inc., |
| Date of publication, distribution, etc. |
c2022. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxviii, 427 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
24 cm. |
| 365 ## - TRADE PRICE |
|---|
| Price amount |
2239 |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc. note |
Includes index. |
| 505 ## - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Chapter 1 : Setting up your coding environment -- Chapter 2 : Creating your first database and table -- Chapter 3 : Beginning data exploration with SELECT -- Chapter 4 : Understanding data types -- Chapter 5 : Importing and exporting data -- Chapter 6 : Basic math and stats with SQL -- Chapter 7 : Joining tables in relational database -- Chapter 8 : Table design that works for you -- Chapter 9 : Extracting information by grouping and summarizing -- Chapter 10 : Inspecting and modifying data -- Chapter 11 : Statistical functions in SQL -- Chapter 12 : Working with dates and times -- Chapter 13 : Advanced query techniques -- Chapter 14 : Mining text to find meaningful data -- Chapter 15 : Analyzing spatial data with PostGIS -- Chapter 16 : Working with JSON data -- Chapter 17 : Saving time with views, functions, and triggers -- Chapter18 : Using PostgreSQL from the command line -- Chapter 19 : Maintaining your database -- Chapter20 : Telling your data's story -- Appendix -- Index. |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
This second edition has been revised to reflect the latest in SQL code and practices. These updates include more thorough instructions to set up your system, a new chapter on working with the popular and portable JSON data format, improved examples using the latest data techniques, and new syntax and techniques for handling data. -- back cover. |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (COMPUTER PROGRAM LANGUAGE) |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
DATABASE DESIGN |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
COMPUTERS -- PRGRAMMING LANGUAGE -- SQL |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
COMPUTERS -- DATABASE MANAGEMENT -- DATA MINING. |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
|
| Koha item type |
Books |
| Suppress in OPAC |
No |
