![]() Josh currently works as a Kubernetes community manager at Red Hat, Inc. He was also a database consultant for 15 years, working with PostgreSQL, MySQL, CitusDB, Redis, CouchDB, Hadoop, and Microsoft SQL Server. He is currently senior vice president for content and product development for a publishing and events firm and lives and works in the Washington, D.C., area.Ībout the Technical Reviewer Josh Berkus is a “hacker emeritus” for the PostgreSQL Project, where he served on the Core Team for 13 years. He spent more than 25 years with the Gannett company, including the Poughkeepsie Journal, USA TODAY, and Gannett Digital. shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in it.Ībout the Author Anthony DeBarros is an award-winning journalist who has combined avid interests in data analysis, coding, and storytelling for much of his career. While every precaution has been taken in the preparation of this work, neither the author nor No Starch Press, Inc. The information in this book is distributed on an “As Is” basis, without warranty. Rather than use a trademark symbol with every occurrence of a trademarked name, we are using the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. Other product and company names mentioned herein may be the trademarks of their respective owners. No Starch Press and the No Starch Press logo are registered trademarks of No Starch Press, Inc. Classification: LCC QA76.73.S67 (print) | LCC QA76.73.S (ebook) | DDC 005.75/6-dc23 LC record available at | COMPUTERS / Database Management / Data Mining. | COMPUTERS / Database Management / General. | BISAC: COMPUTERS / Programming Languages / SQL. Description: San Francisco : No Starch Press, 2018. Title: Practical SQL : a beginner's guide to storytelling with data / Anthony DeBarros. 245 8th Street, San Francisco, CA 94103 phone: 1.415.863.9900 Library of Congress Cataloging-in-Publication Data Names: DeBarros, Anthony, author. ISBN-10: 1-59327-827-6 ISBN-13: 978-1-59327-827-4 Publisher: William Pollock Production Editor: Janelle Ludowise Cover Illustration: Josh Ellingson Interior Design: Octopod Studios Developmental Editors: Liz Chadwick and Annie Choi Technical Reviewer: Josh Berkus Copyeditor: Anne Marie Walker Compositor: Janelle Ludowise Proofreader: James Fraleigh For information on distribution, translations, or bulk sales, please contact No Starch Press, Inc. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. PRACTICAL SQL A Beginner’s Guide to Storytelling with Data PostgreSQL Utilities, Tools, and Extensions Identify Key Indicators and Trends over TimeĪppendix: Additional PostgreSQL Resources Identifying and Telling the Story Behind Your Data Using PostgreSQL from the Command LineĪdditional Command Line Utilities to Expedite Tasksġ8. Saving Time with Views, Functions, and TriggersĪutomating Database Actions with Triggersġ6. ![]() Installing PostGIS and Creating a Spatial DatabaseĬreating Spatial Objects with PostGIS Functionsġ5. Matching Text Patterns with Regular Expressions Improving Performance When Updating Large TablesĬalculating Rates for Meaningful Comparisonsĭata Types and Functions for Dates and Times Using Transaction Blocks to Save or Revert Changes Importing Data on Meat, Poultry, and Egg Producers Extracting Information by Grouping and SummarizingĮxploring the Library Data Using Aggregate Functions Naming Tables, Columns, and Other IdentifiersĬontrolling Column Values with ConstraintsĨ. Simplifying JOIN Syntax with Table Aliases Using NULL to Find Rows with Missing Values ![]() Importing Census Data Describing CountiesĪdding a Default Value to a Column During ImportĪggregate Functions for Averages and SumsĦ. Transforming Values from One Type to Another with CAST Using the interval Data Type in Calculations ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |