Normal view MARC view ISBD view

Practical SQL : a beginner's guide to storytelling with data / Anthony DeBarros

By: DeBarros, Anthony [author]Material type: Text

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

Contents:

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.

Summary: 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.

Tags from this library: No tags from this library for this title. Log in to add tags.

Average rating: 0.0 (0 votes)

Holdings ( 1 )
Title notes ( 3 )
Comments ( 0 )

Holdings
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

Includes 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.

to post a comment.