Practical SQL: a beginner's guide to storytelling with data
"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. The book focuses on using SQL to find the story your data tells, with the popular open-source databa...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
San Francisco
no starch press
[2018]
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis Inhaltsverzeichnis |
| Zusammenfassung: | "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. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. You'll learn how to: -Create databases and related tables using your own data -Define the right data types for your information -Aggregate, sort, and filter data to find patterns -Use basic math and advanced statistical functions -Identify errors in data and clean them up -Import and export data using delimited text files -Write queries for geographic information systems (GIS) -Create advanced queries and automate tasks Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL"... |
| Beschreibung: | XXXIII, 351 Seiten |
| ISBN: | 9781593278274 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV044917315 | ||
| 003 | DE-604 | ||
| 005 | 20180514 | ||
| 007 | t | ||
| 008 | 180424s2018 xxu |||| 00||| eng d | ||
| 010 | |a 017043947 | ||
| 020 | |a 9781593278274 |c pbk |9 978-1-59327-827-4 | ||
| 035 | |a (OCoLC)1021873562 | ||
| 035 | |a (DE-599)BVBBV044917315 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-473 | ||
| 050 | 0 | |a QA76.73.S67 | |
| 082 | 0 | |a 005.75/6 |2 23 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a DeBarros, Anthony |e Verfasser |0 (DE-588)115852692X |4 aut | |
| 245 | 1 | 0 | |a Practical SQL |b a beginner's guide to storytelling with data |c by Anthony DeBarros |
| 264 | 1 | |a San Francisco |b no starch press |c [2018] | |
| 264 | 4 | |c © 2018 | |
| 300 | |a XXXIII, 351 Seiten | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 520 | |a "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. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. You'll learn how to: -Create databases and related tables using your own data -Define the right data types for your information -Aggregate, sort, and filter data to find patterns -Use basic math and advanced statistical functions -Identify errors in data and clean them up -Import and export data using delimited text files -Write queries for geographic information systems (GIS) -Create advanced queries and automate tasks Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL"... | ||
| 650 | 4 | |a COMPUTERS / Programming Languages / SQL / bisacsh | |
| 650 | 4 | |a COMPUTERS / Database Management / General / bisacsh | |
| 650 | 4 | |a COMPUTERS / Database Management / Data Mining / bisacsh | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Database design | |
| 650 | 4 | |a COMPUTERS / Programming Languages / SQL | |
| 650 | 4 | |a COMPUTERS / Database Management / General | |
| 650 | 4 | |a COMPUTERS / Database Management / Data Mining | |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe, NOOK Ebook |z 978-1-59327-845-8 |
| 856 | 4 | 2 | |m LoC Fremddatenuebernahme |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000003&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-030310694 | ||
Datensatz im Suchindex
| _version_ | 1804178483802275840 |
|---|---|
| adam_text | PRACTICAL SQL
/ DEBARROS, ANTHONYYYEAUTHOR
: 2018
TABLE OF CONTENTS / INHALTSVERZEICHNIS
INTRODUCTION
CHAPTER 1: CREATING YOUR FIRST DATABASE & TABLE
CHAPTER 2: BEGINNING DATA EXPLORATION WITH SELECT
CHAPTER 3: UNDERSTANDING DATA TYPES
CHAPTER 4: IMPORTING AND EXPORTING DATA
CHAPTER 5: BASIC MATH AND STATS
CHAPTER 6: JOINING TABLES IN A RELATIONAL DATABASE
CHAPTER 7: TABLE DESIGN THAT WORKS FOR YOU
CHAPTER 8: GROUPING AND SUMMARIZING DATA
CHAPTER 9: CLEANING , MODIFYING, DELETING DATA
CHAPTER 10: RANKS, RATES, ASND STATS
CHAPTER 11: DEALING WITH DATES
CHAPTER 12: ADVANCED QUERIES
CHAPTER 13: FULL-TEXT SEARCH
CHAPTER 14: GIS
CHAPTER 15: VIEWS
CHAPTER 16: WORKING FROM THE COMMAND LINE
CHAPTER 17: MAINTENANCE
APPENDIX A: ALTERNATIVE SOFTWARE AND TEXT EDITORS
APPENDIX B: SOLUTIONS
DIESES SCHRIFTSTUECK WURDE MASCHINELL ERZEUGT.
BRIEF CONTENTS
Foreword by Sarah Frostenson.........................................................xvii
Acknowledgments.......................................................................xxi
Introduction........................................................................xxiii
Chapter 1: Creating Your First Database and Table................................... 1
Chapter 2: Beginning Data Exploration with SELECT................................... 11
Chapter 3: Understanding Data Types....................................................23
Chapter 4: Importing and Exporting Data................................................39
Chapter 5: Basic Math and Stats with SQL............................................55
Chapter 6: Joining Tables in a Relational Database..................................73
Chapter 7: Table Design That Works for You..........................................93
Chapter 8: Extracting Information by Grouping and Summarizing ...................... 113
Chapter 9: Inspecting and Modifying Data............................................. 129
Chapter 10: Statistical Functions in SQL............................................. 155
Chapter 11: Working with Dates and Times............................................ 171
Chapter 12: Advanced Query Techniques................................................ 191
Chapter 13: Mining Text to Find Meaningful Data.....................................211
Chapter 14: Analyzing Spatial Data with PostGIS.....................................241
Chapter 15: Saving Time with Views, Functions, and Triggers.........................267
Chapter 16: Using PostgreSQL from the Command Line..................................291
Chapter 17: Maintaining Your Database.................................................313
Chapter 18: Identifying and Telling the Story Behind Your Data......................325
Appendix: Additional PostgreSQL Resources.............................................333
Index
337
CONTENTS IN DETAIL
FOREWORD by Sarah Frostenson xvii
ACKNOWLEDGMENTS xxi
INTRODUCTION
• ••
XXIII
What Is SQL?...................................................................xxiv
Why Use SQL?...................................................................xxiv
About This Book.................................................................xxv
Using the Book s Code Examples................................................xxvii
Using PostgreSQL.............................................................xxviii
Installing PostgreSQL...............................................xxviii
Working with pgAdmin..................................................xxxi
Alternatives to pgAdmin.............................................xxxiii
Wrapping Up..................................................................xxxiii
1
CREATING YOUR FIRST DATABASE AND TABLE 1
Creating a Database................................................................3
Executing SQL in pgAdmin..................................................3
Connecting to the Analysis Database.......................................5
Creating a Table...................................................................5
The CREATE TABLE Statement................................................6
Making the teachers Table.................................................7
Inserting Rows into a Table........................................................8
The INSERT Statement......................................................8
Viewing the Data..........................................................9
When Code Goes Bad.................................................................9
Formatting SQL for Readability.................................................... 10
Wrapping Up...................................................................... 10
Try It Yourself................................................................... 10
2
BEGINNING DATA EXPLORATION WITH SELECT 11
Basic SELECT Syntax........................................................ 12
Querying a Subset of Columns....................................... 13
Using DISTINCT to Find Unique Values............................... 14
Sorting Data with ORDER BY................................................. 15
Filtering Rows with WHERE.................................................. 17
Using LIKE and ILIKE with WHERE.................................... 19
Combining Operators with AND and OR.................................20
Putting It All Together.....................................................21
Wrapping Up.................................................................21
Try It Yourself.............................................................22
3
UNDERSTANDING DATA TYPES 23
Characters......................................................................24
Numbers.........................................................................26
Integers...............................................................27
Auto-Incrementing Integers.............................................27
Decimal Numbers........................................................28
Choosing Your Number Data Type...........................................31
Dates and Times.................................................................32
Using the Interval Data Type in Calculations....................................34
Miscellaneous Types.............................................................35
Transforming Values from One Type to Another with CAST..........................35
CAST Shortcut Notation..........................................................36
Wrapping Up.....................................................................36
Try It Yourself.................................................................37
4
IMPORTING AND EXPORTING DATA 39
Working with Delimited Text Files...............................................40
Quoting Columns that Contain Delimiters................................41
Handling Header Rows...................................................41
Using COPY to Import Data.......................................................42
Importing Census Data Describing Counties.......................................43
Creating the us_counties_2010 Table....................................44
Census Columns and Data Types..........................................45
Performing the Census Import with COPY.................................47
Importing a Subset of Columns with COPY.........................................49
Adding a Default Value to a Column During Import................................50
Using COPY to Export Data.......................................................51
Exporting All Data.....................................................51
Exporting Particular Columns...........................................52
Exporting Query Results................................................52
Importing and Exporting Through pgAdmin.........................................52
Wrapping Up.....................................................................53
Try It Yourself.................................................................54
5
BASIC MATH AND STATS WITH SQL 55
Math Operators..................................................................56
Math and Data Types....................................................56
Adding, Subtracting, and Multiplying...................................57
Division and Modulo....................................................57
Exponents, Roots, and Factorials.......................................58
Minding the Order of Operations........................................59
Doing Math Across Census Table Columns..........................................60
Adding and Subtracting Columns.........................................60
Finding Percentages of the Whole.......................................62
Tracking Percent Change................................................63
Aggregate Functions for Averages and Sums.......................................64
X Contents in Detail
Finding the Median....................................................................65
Finding the Median with Percentile Functions.................................66
Median and Percentiles with Census Data......................................67
Finding other Quantiles with Percentile Functions............................67
Creating a median)) Function.................................................69
Finding the Mode......................................................................70
Wrapping Up...........................................................................71
Try It Yourself.......................................................................71
6
JOINING TABLES IN A RELATIONAL DATABASE 73
Linking Tables Using JOIN.............................................................74
Relating Tables with Key Columns......................................................74
Querying Multiple Tables Using JOIN...................................................77
JOIN Types............................................................................78
JOIN.........................................................................80
LEFT JOIN and RIGHT JOIN.....................................................80
FULL OUTER JOIN..............................................................82
CROSS JOIN...................................................................82
Using NULL to Find Rows with Missing Values...........................................83
Three Types of Table Relationships....................................................84
One-to-One Relationship......................................................84
One-to-Many Relationship.....................................................84
Many-to-Many Relationship....................................................85
Selecting Specific Columns in a Join..................................................85
Simplifying JOIN Syntax with Table Aliases............................................86
Joining Multiple Tables...............................................................87
Performing Math on Joined Table Columns...............................................88
Wrapping Up...........................................................................90
Try It Yourself.......................................................................91
7
TABLE DESIGN THAT WORKS FOR YOU 93
Naming Tables, Columns, and Other Identifiers.........................................94
Using Quotes Around Identifiers to Enable Mixed Case.........................94
Pitfalls with Quoting Identifiers............................................95
Guidelines for Naming Identifiers............................................96
Controlling Column Values with Constraints............................................96
Primary Keys: Natural vs. Surrogate..........................................97
Foreign Keys............................................................... 102
Automatically Deleting Related Records with CASCADE........................ 104
The CHECK Constraint....................................................... 104
The UNIQUE Constraint...................................................... 105
The NOT NULL Constraint.................................................... 106
Removing Constraints or Adding Them Later.................................. 107
Speeding Up Queries with Indexes.................................................... 108
B-Tree: PostgreSQL s Default Index......................................... 108
Considerations When Using Indexes.......................................... Ill
Wrapping Up......................................................................... Ill
Try It Yourself..................................................................... 112
•
Contents in Detail XI
8
EXTRACTING INFORMATION BY
GROUPING AND SUMMARIZING 113
Creating the Library Survey Tables........................................... 114
Creating the 2014 Library Data Table................................. 114
Creating the 2009 Library Data Table................................. 116
Exploring the Library Data Using Aggregate Functions......................... 117
Counting Rows and Values Using count)).............................. 117
Finding Maximum and Minimum Values Using max() and min()............ 119
Aggregating Data Using GROUP BY..................................... 120
Wrapping Up................................................................... 128
Try It Yourself............................................................... 128
9
INSPECTING AND MODIFYING DATA 129
Importing Data on Meat, Poultry, and Egg Producers........................... 130
Interviewing the Data Set..................................................... 131
Checking for Missing Values.......................................... 132
Checking for Inconsistent Data Values................................ 134
Checking for Malformed Values Using length))......................... 135
Modifying Tables, Columns, and Data.......................................... 136
Modifying Tables with ALTER TABLE................................... 137
Modifying Values with UPDATE......................................... 138
Creating Backup Tables............................................... 139
Restoring Missing Column Values...................................... 140
Updating Values for Consistency...................................... 142
Repairing ZIP Codes Using Concatenation.............................. 143
Updating Values Across Tables........................................ 145
Deleting Unnecessary Data..................................................... 147
Deleting Rows from a Table........................................... 147
Deleting a Column from a Table...................................... 148
Deleting a Table from a Database.................................... 148
Using Transaction Blocks to Save or Revert Changes........................... 149
Improving Performance When Updating Large Tables............................. 151
Wrapping Up................................................................... 152
Try It Yourself............................................................... 152
10
STATISTICAL FUNCTIONS IN SQL 155
Creating a Census Stats Table................................................. 156
Measuring Correlation with corr(Y, X)................................ 157
Checking Additional Correlations..................................... 159
Predicting Values with Regression Analysis........................... 160
Finding the Effect of an Independent Variable with r-squared........ 163
Creating Rankings with SQL.................................................... 164
Ranking with rank)) and dense_rank()................................. 164
Ranking Within Subgroups with PARTITION BY........................... 165
Calculating Rates for Meaningful Comparisons.................................. 167
XII Contents in Detail
Wrapping Up...................................................................... 169
Try It Yourself.................................................................. 169
11
WORKING WITH DATES AND TIMES 171
Data Types and Functions for Dates and Times.................................... 172
Manipulating Dates and Times..................................................... 172
Extracting the Components of a timestamp Value.......................... 173
Creating Datetime Values from timestamp Components...................... 174
Retrieving the Current Date and Time.................................... 175
Working with Time Zones.......................................................... 177
Finding Your Time Zone Setting.......................................... 177
Setting the Time Zone................................................... 178
Calculations with Dates and Times................................................ 180
Finding Patterns in New York City Taxi Data............................. 180
Finding Patterns in Amtrak Data......................................... 186
Wrapping Up...................................................................... 189
Try It Yourself.................................................................. 190
12
ADVANCED QUERY TECHNIQUES 191
Using Subqueries................................................................. 192
Filtering with Subqueries in a WHERE Clause............................. 192
Creating Derived Tables with Subqueries................................. 194
Joining Derived Tables.................................................. 195
Generating Columns with Subqueries...................................... 197
Subquery Expressions.................................................... 198
Common Table Expressions..........................................................200
Cross Tabulations.................................................................203
Installing the crosstab!) Function.......................................203
Tabulating Survey Results................................................203
Tabulating City Temperature Readings.....................................205
Reclassifying Values with CASE....................................................207
Using CASE in a Common Table Expression...........................................209
Wrapping Up.......................................................................210
Try It Yourself...................................................................210
13
MINING TEXT TO FIND MEANINGFUL DATA 211
Formatting Text Using String Functions............................................212
Case Formatting..........................................................212
Character Information....................................................212
Removing Characters......................................................213
Extracting and Replacing Characters......................................213
Matching Text Patterns with Regular Expressions...................................214
Regular Expression Notation..............................................214
Turning Text to Data with Regular Expression Functions...................216
Using Regular Expressions with WHERE.....................................228
Additional Regular Expression Functions..................................230
M*
Contents in Detail XIII
Full Text Search in PostgreSQL.................................................231
Text Search Data Types................................................231
Creating a Table for Full Text Search.................................233
Searching Speech Text...................................................234
Ranking Query Matches by Relevance......................................237
Wrapping Up....................................................................239
Try It Yourself................................................................239
14
ANALYZING SPATIAL DATA WITH POSTGIS 241
Installing PostGIS and Creating a Spatial Database.............................242
The Building Blocks of Spatial Data............................................243
Two-Dimensional Geometries.....................................................243
Well-Known Text Formats.................................................244
A Note on Coordinate Systems..........................................245
Spatial Reference System Identifier...................................246
PostGIS Data Types.............................................................247
Creating Spatial Objects with PostGIS Functions................................247
Creating a Geometry Type from Well-Known Text.........................247
Creating a Geography Type from Well-Known Text........................248
Point Functions.......................................................249
LineString Functions..................................................249
Polygon Functions.....................................................250
Analyzing Farmers Markets Data................................................250
Creating and Filling a Geography Column...............................251
Adding a GiST Index...................................................252
Finding Geographies Within a Given Distance...........................253
Finding the Distance Between Geographies..............................254
Working with Census Shapefiles.................................................256
Contents of a Shapefile...............................................256
Loading Shapefiles via the GUI Tool...................................257
Exploring the Census 2010 Counties Shapefile..........................259
Performing Spatial Joins.......................................................262
Exploring Roads and Waterways Data....................................262
Joining the Census Roads and Water Tables.............................263
Finding the Location Where Objects Intersect..........................264
Wrapping Up......................................................................265
Try It Yourself..................................................................265
15
SAVING TIME WITH VIEWS, FUNCTIONS, AND TRIGGERS 267
Using Views to Simplify Queries..................................................268
Creating and Querying Views.............................................269
Inserting, Updating, and Deleting Data Using a View...................271
Programming Your Own Functions...................................................275
Creating the percent_change() Function..................................276
Using the percent_change() Function.....................................277
Updating Data with a Function...........................................278
Using the Python Language in a Function.................................281
XIV Contents in Detail
Automating Database Actions with Triggers....................................282
Logging Grade Updates to a Table....................................282
Automatically Classifying Temperatures..............................286
Wrapping Up..................................................................289
Try It Yourself..............................................................289
16
USING POSTGRESQL FROM THE COMMAND LINE 291
Setting Up the Command Line for psql.........................................292
Windows psql Setup..................................................292
macOS psql Setup....................................................296
Linux psql Setup....................................................299
Working with psql............................................................299
Launching psql and Connecting to a Database.........................299
Getting Help........................................................300
Changing the User and Database Connection...........................300
Running SQL Queries on psql.........................................301
Navigating and Formatting Results...................................303
Meta-Commands for Database Information..............................306
Importing, Exporting, and Using Files...............................307
Additional Command Line Utilities to Expedite Tasks..........................310
Adding a Database with createdb.....................................310
Loading Shapefiles with shp2pgsql...................................311
Wrapping Up..................................................................311
Try It Yourself..............................................................312
17
MAINTAINING YOUR DATABASE 313
Recovering Unused Space with VACUUM..........................................314
Tracking Table Size.................................................314
Monitoring the autovacuum Process...................................316
Running VACUUM Manually.............................................318
Reducing Table Size with VACUUM FULL................................318
Changing Server Settings.....................................................318
Locating and Editing postgresql.conf................................319
Reloading Settings with pg ctl......................................321
Backing Up and Restoring Your Database.......................................321
Using pg_dump to Back Up a Database or Table........................321
Restoring a Database Backup with pg_restore.........................322
Additional Backup and Restore Options...............................323
Wrapping Up..................................................................323
Try It Yourself..............................................................323
18
IDENTIFYING AND TELLING THE STORY BEHIND YOUR DATA 325
Start with a Question........................................................326
Document Your Process........................................................326
Gather Your Data.............................................................326
No Data? Build Your Own Database.............................................327
Contents in Detail XV
Assess the Data s Origins.................................................328
Interview the Data with Queries...........................................328
Consult the Data s Owner..................................................328
Identify Key Indicators and Trends over Time..............................329
Ask Why...................................................................331
Communicate Your Findings.................................................331
Wrapping Up...............................................................332
Try It Yourself...........................................................332
APPENDIX
ADDITIONAL POSTGRESQL RESOURCES 333
PostgreSQL Development Environments.......................................333
PostgreSQL Utilities, Tools, and Extensions...............................334
PostgreSQL News...........................................................335
Documentation.............................................................335
INDEX 337
xvi
Contents in Detail
|
| any_adam_object | 1 |
| author | DeBarros, Anthony |
| author_GND | (DE-588)115852692X |
| author_facet | DeBarros, Anthony |
| author_role | aut |
| author_sort | DeBarros, Anthony |
| author_variant | a d ad |
| building | Verbundindex |
| bvnumber | BV044917315 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.S67 |
| callnumber-search | QA76.73.S67 |
| callnumber-sort | QA 276.73 S67 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)1021873562 (DE-599)BVBBV044917315 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03667nam a2200505 c 4500</leader><controlfield tag="001">BV044917315</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20180514 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">180424s2018 xxu |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">017043947</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781593278274</subfield><subfield code="c">pbk</subfield><subfield code="9">978-1-59327-827-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1021873562</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV044917315</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.73.S67</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">23</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">DeBarros, Anthony</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)115852692X</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Practical SQL</subfield><subfield code="b">a beginner's guide to storytelling with data</subfield><subfield code="c">by Anthony DeBarros</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">San Francisco</subfield><subfield code="b">no starch press</subfield><subfield code="c">[2018]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2018</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXIII, 351 Seiten</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"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. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. You'll learn how to: -Create databases and related tables using your own data -Define the right data types for your information -Aggregate, sort, and filter data to find patterns -Use basic math and advanced statistical functions -Identify errors in data and clean them up -Import and export data using delimited text files -Write queries for geographic information systems (GIS) -Create advanced queries and automate tasks Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL"...</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Programming Languages / SQL / bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Database Management / General / bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Database Management / Data Mining / bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Programming Languages / SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Database Management / General</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">COMPUTERS / Database Management / Data Mining</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe, NOOK Ebook</subfield><subfield code="z">978-1-59327-845-8</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">LoC Fremddatenuebernahme</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000003&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-030310694</subfield></datafield></record></collection> |
| id | DE-604.BV044917315 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T08:04:42Z |
| institution | BVB |
| isbn | 9781593278274 |
| language | English |
| lccn | 017043947 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-030310694 |
| oclc_num | 1021873562 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | XXXIII, 351 Seiten |
| publishDate | 2018 |
| publishDateSearch | 2018 |
| publishDateSort | 2018 |
| publisher | no starch press |
| record_format | marc |
| spelling | DeBarros, Anthony Verfasser (DE-588)115852692X aut Practical SQL a beginner's guide to storytelling with data by Anthony DeBarros San Francisco no starch press [2018] © 2018 XXXIII, 351 Seiten txt rdacontent n rdamedia nc rdacarrier "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. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. You'll learn how to: -Create databases and related tables using your own data -Define the right data types for your information -Aggregate, sort, and filter data to find patterns -Use basic math and advanced statistical functions -Identify errors in data and clean them up -Import and export data using delimited text files -Write queries for geographic information systems (GIS) -Create advanced queries and automate tasks Learning SQL doesn't have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL"... COMPUTERS / Programming Languages / SQL / bisacsh COMPUTERS / Database Management / General / bisacsh COMPUTERS / Database Management / Data Mining / bisacsh SQL (Computer program language) Database design COMPUTERS / Programming Languages / SQL COMPUTERS / Database Management / General COMPUTERS / Database Management / Data Mining SQL (DE-588)4134010-3 gnd rswk-swf SQL (DE-588)4134010-3 s DE-604 Erscheint auch als Online-Ausgabe, NOOK Ebook 978-1-59327-845-8 LoC Fremddatenuebernahme application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis Digitalisierung UB Bamberg - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000003&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | DeBarros, Anthony Practical SQL a beginner's guide to storytelling with data COMPUTERS / Programming Languages / SQL / bisacsh COMPUTERS / Database Management / General / bisacsh COMPUTERS / Database Management / Data Mining / bisacsh SQL (Computer program language) Database design COMPUTERS / Programming Languages / SQL COMPUTERS / Database Management / General COMPUTERS / Database Management / Data Mining SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4134010-3 |
| title | Practical SQL a beginner's guide to storytelling with data |
| title_auth | Practical SQL a beginner's guide to storytelling with data |
| title_exact_search | Practical SQL a beginner's guide to storytelling with data |
| title_full | Practical SQL a beginner's guide to storytelling with data by Anthony DeBarros |
| title_fullStr | Practical SQL a beginner's guide to storytelling with data by Anthony DeBarros |
| title_full_unstemmed | Practical SQL a beginner's guide to storytelling with data by Anthony DeBarros |
| title_short | Practical SQL |
| title_sort | practical sql a beginner s guide to storytelling with data |
| title_sub | a beginner's guide to storytelling with data |
| topic | COMPUTERS / Programming Languages / SQL / bisacsh COMPUTERS / Database Management / General / bisacsh COMPUTERS / Database Management / Data Mining / bisacsh SQL (Computer program language) Database design COMPUTERS / Programming Languages / SQL COMPUTERS / Database Management / General COMPUTERS / Database Management / Data Mining SQL (DE-588)4134010-3 gnd |
| topic_facet | COMPUTERS / Programming Languages / SQL / bisacsh COMPUTERS / Database Management / General / bisacsh COMPUTERS / Database Management / Data Mining / bisacsh SQL (Computer program language) Database design COMPUTERS / Programming Languages / SQL COMPUTERS / Database Management / General COMPUTERS / Database Management / Data Mining SQL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=030310694&sequence=000003&line_number=0002&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT debarrosanthony practicalsqlabeginnersguidetostorytellingwithdata |
Es ist kein Print-Exemplar vorhanden.
Inhaltsverzeichnis