Practical SQL : a beginner's guide to storytelling with data / Anthony DeBarros
Material type:
TextPublication details: San Francisco, California : No Starch Press, Inc., c2022Edition: 2nd editionDescription: xxviii, 427 pages : illustrations ; 24 cmISBN: 978-1-7185-0106-5Subject(s): SQL (COMPUTER PROGRAM LANGUAGE) | DATABASE DESIGN | COMPUTERS -- PRGRAMMING LANGUAGE -- SQL | COMPUTERS -- DATABASE MANAGEMENT -- DATA MININGLOC classification: QA 76.73 D43 2022| Item type | Current library | Home library | Collection | Shelving location | Call number | Status | Date due | Barcode |
|---|---|---|---|---|---|---|---|---|
Books
|
NU Fairview College LRC | NU Fairview College LRC | School of Engineering and Technology | General Circulation | GC QA 76.73 D43 2022 (Browse shelf(Opens below)) | Available | NUFAI000005494 |
Browsing NU Fairview College LRC shelves, Shelving location: General Circulation, Collection: School of Engineering and Technology Close shelf browser (Hides shelf browser)
|
|
|
|
|
|
|
||
| GC QA 76.73 B76 2016 Basic C++ for engineers and scientist / | GC QA 76.73 B87 2022 Java for dummies / | GC QA 76.73 C45 2017 JavaScript : absolute beginner's guide / | GC QA 76.73 D43 2022 Practical SQL : a beginner's guide to storytelling with data / | GC QA 76.73 F37 2019 Java programming | GC QA 76.73 F37 2019 Java programming | GC QA 76.73 G35 2020 Python feature engineering cookbook : over 70 recipes for creating, engineering, and transforming features to build machine learning models / |
Includes index.
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.
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.
There are no comments on this title.