MARC details
| 000 -LEADER |
|---|
| fixed length control field |
02962cam a2200397 i 4500 |
| 001 - CONTROL NUMBER |
|---|
| control field |
1293235107 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
OCoLC |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20250904210745.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
220408t20222022caua 001 0 eng d |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER |
|---|
| LC control number |
2022288073 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781718501065 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
1718501064 |
| 022 ## - INTERNATIONAL STANDARD SERIAL NUMBER |
|---|
| International Standard Serial Number |
9781718501065 |
| 035 ## - SYSTEM CONTROL NUMBER |
|---|
| System control number |
(OCoLC)1293235107 |
| Canceled/invalid control number |
(OCoLC)1198218752 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
SDG |
| Language of cataloging |
eng |
| Description conventions |
rda |
| Transcribing agency |
DLC |
| Modifying agency |
OCLCO |
| -- |
UAP |
| -- |
HF9 |
| -- |
OCL |
| -- |
OMB |
| -- |
LLX |
| 042 ## - AUTHENTICATION CODE |
|---|
| Authentication code |
lccopycat |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
QA76.73.S67 |
| Item number |
D44 2022 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER |
|---|
| Classification number |
005.756 DEB 2022 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
DeBarros, Anthony, |
| Relator term |
author |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Practical SQL : |
| Remainder of title |
a beginner's guide to storytelling with data / |
| Statement of responsibility, etc. |
by Anthony DeBarros |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
2nd edition |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Place of production, publication, distribution, manufacture |
San Francisco : |
| Name of producer, publisher, distributor, manufacturer |
No Starch Press, |
| Date of production, publication, distribution, manufacture, or copyright notice |
[2022] |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Date of production, publication, distribution, manufacture, or copyright notice |
©2022 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxviii, 427 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
24 cm |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Content type code |
txt |
| Source |
rdacontent |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
still image |
| Content type code |
sti |
| Source |
rdacontent |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
unmediated |
| Media type code |
n |
| Source |
rdamedia |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
volume |
| Carrier type code |
nc |
| Source |
rdacarrier |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index |
| 505 0# - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Introduction -- Setting up your coding environment -- Creating your first database and table -- Beginning data exploration with SELECT -- Understanding data types -- Importing and exporting data -- Basic math and stats with SQL -- Joining tables in a relational database -- Table design that works for you -- Extracting information by grouping and summarizing -- Inspecting and modifying data -- Statistical functions in SQL -- Working with dates and times -- Advanced query techniques -- Mining text to find meaningful data -- Analyzing spatial data with PostGIS -- Working with JSON data -- Saving time with views, functions, and triggers -- Using PostgreSQL from the command line -- Maintaining your database -- Telling your data's story -- Appendix A. Additional PostgreSQL resources |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc. |
"Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-source database PostgreSQL and its companion pgAdmin interface, and the concepts you learn will apply to most database management systems, including MySQL, Oracle, SQLite, and others. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from real-world datasets such as US Census demographics, New York City taxi rides, and earthquakes from US Geological Survey. Each chapter includes exercises and examples that teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently"-- |
| Assigning source |
Provided by publisher |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
SQL (Computer program language) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Database design |
| 655 #7 - INDEX TERM--GENRE/FORM |
|---|
| Genre/form data or focus term |
Handbooks and manuals. |
| Source of term |
lcgft |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Koha item type |
Book |
| Suppress in OPAC |
No |
