000 04067cam a22005058i 4500
001 20236366
003 OSt
005 20220712022741.0
006 m |o d |
007 cr_|||||||||||
008 180103s2018 cau o 001 0 eng
010 _a 2018000030
020 _a9781593278458 (epub)
020 _a1593278454 (epub)
020 _z9781593278274 (paperback)
040 _aDLC
_beng
_erda
_cDLC
042 _apcc
050 1 0 _aQA76.73.S67
082 0 0 _a005.75
_223
084 _aCOM051170
_aCOM021000
_aCOM021030
_2bisacsh
092 _20
100 1 _aDeBarros, Anthony,
_eauthor.
245 1 0 _aPractical SQL :
_ba beginner's guide to storytelling with data /
_cAnthony DeBarros.
263 _a1802
264 1 _aSan Francisco :
_bNo Starch Press,
_c2018.
300 _a1 online resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bn
_2rdamedia
338 _aonline resource
_bnc
_2rdacarrier
500 _aIncludes index.
505 8 _aMachine generated contents note: 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.
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"--
_cProvided by publisher.
588 _aDescription based on print version record and CIP data provided by publisher; resource not viewed.
650 0 _aSQL (Computer program language)
650 0 _aDatabase design.
650 7 _aCOMPUTERS / Programming Languages / SQL.
_2bisacsh
650 7 _aCOMPUTERS / Database Management / General.
_2bisacsh
650 7 _aCOMPUTERS / Database Management / Data Mining.
_2bisacsh
776 0 8 _iPrint version:
_aDeBarros, Anthony, author.
_tPractical SQL
_dSan Francisco : No Starch Press, 2018
_z9781593278274
_w(DLC) 2017043947
843 _aPhotocopy
887 _2CamTech Library
906 _a7
_bcbc
_corigcop
_d1
_eecip
_f20
_gy-gencatlg
942 _2ddc
_cBK
_n0
999 _c397
_d397