{"id":63535,"date":"2022-04-10T09:01:03","date_gmt":"2022-04-10T09:01:03","guid":{"rendered":"https:\/\/www.cryptocabaret.com\/?p=63535"},"modified":"2022-04-10T09:01:03","modified_gmt":"2022-04-10T09:01:03","slug":"new-book-teaches-readers-how-to-tell-data-stories-with-postgresql","status":"publish","type":"post","link":"https:\/\/www.cryptocabaret.com\/?p=63535","title":{"rendered":"New book teaches readers how to tell data stories with PostgreSQL"},"content":{"rendered":"<p><span class=\"field field--name-title field--type-string field--label-hidden\">New book teaches readers how to tell data stories with PostgreSQL<\/span><br \/>\n<span class=\"field field--name-uid field--type-entity-reference field--label-hidden\"><a title=\"View user profile.\" href=\"https:\/\/opensource.com\/users\/holmja\" class=\"username\">Joshua Allen Holm<\/a><\/span><br \/>\n<span class=\"field field--name-created field--type-created field--label-hidden\">Sun, 04\/10\/2022 &#8211; 03:00<\/span><\/p>\n<div data-drupal-selector=\"rate-node-69866\" class=\"rate-widget-thumbs-up\">\n<div class=\"rate-thumbs-up-btn-up rate-thumbs-up-btn-up vote-pending\">Up<\/div>\n<div class=\"rate-score\"><a href=\"https:\/\/opensource.com\/user\/register?absolute=1\">Register<\/a> or <a href=\"https:\/\/opensource.com\/user\/login?current=\/rss.xml&amp;absolute=1\">Login<\/a> to like.<\/div>\n<\/div>\n<div class=\"clearfix text-formatted field field--name-body field--type-text-with-summary field--label-hidden field__item\">\n<p>SQL databases can be daunting but can also be very fun if you know how to use them. The information contained in a database can provide many insights to someone who knows how to properly query and manipulate the data. <a href=\"https:\/\/nostarch.com\/practical-sql-2nd-edition\" rel=\"noopener\" target=\"_blank\">Practical SQL, 2nd Edition: A Beginner&#8217;s Guide to Storytelling with Data<\/a> by Anthony DeBarros teaches readers how to do just that.<\/p>\n<\/p>\n<div class=\"embedded-resource-list callout-float-right\">\n<div class=\"field field--name-title field--type-string field--label-hidden field__item\">More great content<\/div>\n<div class=\"field field--name-links field--type-link field--label-hidden field__items\">\n<div class=\"field__item\"><a href=\"https:\/\/www.redhat.com\/en\/services\/training\/rh024-red-hat-linux-technical-overview?intcmp=7016000000127cYAAQ\">Free online course: RHEL technical overview<\/a><\/div>\n<div class=\"field__item\"><a href=\"https:\/\/developers.redhat.com\/cheat-sheets\/advanced-linux-commands\/?intcmp=7016000000127cYAAQ\">Learn advanced Linux commands<\/a><\/div>\n<div class=\"field__item\"><a href=\"https:\/\/opensource.com\/downloads\/cheat-sheets?intcmp=7016000000127cYAAQ\">Download cheat sheets<\/a><\/div>\n<div class=\"field__item\"><a href=\"https:\/\/opensource.com\/tags\/linux?intcmp=7016000000127cYAAQ\">Find an open source alternative<\/a><\/div>\n<div class=\"field__item\"><a href=\"https:\/\/opensource.com\/resources?intcmp=7016000000127cYAAQ\">Explore open source resources<\/a><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<h2>The content<\/h2>\n<p>DeBarros, currently a data editor at the <em>Wall Street Journal<\/em>, pulls from his practical experience in journalism to teach readers how to tell stories with data. The book consists of an introduction, 20 chapters, and several appendices. The introduction sets the tone for the book, explaining what the book is about and who it is for, and the 20 chapters teach lessons about various database topics. Chapter 1 is the traditional &#8220;how to set up your environment&#8221; chapter and covers how to install PostgreSQL on Windows, macOS, or Linux (specifically, Ubuntu). The following chapters cover the basics of working with SQL databases, like creating databases and tables, performing basic queries, understanding data types, importing and exporting data, and basic math and stats functions. The chapters then progress to more complex topics like joining tables and extracting, inspecting, and modifying data. By the time the reader reaches the book&#8217;s midpoint, they should have a solid understanding of how databases work.<\/p>\n<p>The chapters in the second half of the book, starting with chapter 11, explore advanced topics.<\/p>\n<ul>\n<li>Chapter 11 covers statistical functions.<\/li>\n<li>Chapter 12 explains how to work with dates and time.<\/li>\n<li>Chapter 13 teaches advanced query techniques.<\/li>\n<li>Chapter 14 explores text mining features.<\/li>\n<li>Chapter 15 looks at analyzing spatial data using PostGIS.<\/li>\n<li>Chapter 16 explains how to work with JSON data.<\/li>\n<li>Chapter 17 shows how to use views, functions, and triggers.<\/li>\n<li>Chapter 18 discusses using PostgreSQL from the command line.<\/li>\n<li>Chapter 19 covers database maintenance.<\/li>\n<\/ul>\n<p>The final chapter, Chapter 20: Telling Your Data&#8217;s Story, shifts away from the practical aspects of chapters one through 19 toward providing advice about telling stories using data. Again, Debarros pulls from his experience as a journalist to offer lessons about the whys, hows, and best practices of doing data journalism or data storytelling. If chapters one through 19 are the tools in the toolbox, chapter 20 is a sample blueprint that will inspire the reader to create their own project.<\/p>\n<h2>The exercises<\/h2>\n<p>There are SQL files and other supplemental resources for the exercises in each chapter in the book&#8217;s <a href=\"https:\/\/github.com\/anthonydb\/practical-sql-2\/\" rel=\"noopener\" target=\"_blank\">GitHub Repository<\/a>, except for chapter 20, which has no activities. The repository also contains a file with solutions for each of the &#8220;try it yourself&#8221; end-of-chapter exercises.<\/p>\n<p>The exercises throughout the book are all very interesting. While the earliest chapters are understandably basic (there are only so many ways to teach <code>CREATE DATABASE<\/code> and <code>CREATE TABLE<\/code>), they provide an excellent foundation for the more advanced topics later in the book. The advanced exercises use real-world data to give verisimilitude to the learning experience. The database of choice for <em>Practical SQL, 2nd Edition<\/em> is PostgreSQL, but the book makes some mentions of different databases when things might work differently. However, it is very much a PostgreSQL book, so that is something to keep in mind.<\/p>\n<h2>Final thoughts<\/h2>\n<p><em>Practical SQL, 2nd Edition<\/em> is a well-written and informative book that can help someone begin to master SQL. Even more importantly, it is an extremely enjoyable book that will keep the reader engaged with interesting, thought-provoking exercises. Anyone interested in learning the ins and outs of PostgreSQL should consider picking up this book. The book&#8217;s only drawback is that it is a PostgreSQL book, not a database-agnostic book, so anyone trying to learn MySQL, MariaDB, or some other SQL-based database might want to choose a book that focuses on that particular database. The overall &#8220;Guide to Storytelling with Data&#8221; lessons are something a moderately experienced MySQL, MariaDB, etc. can apply to their database of choice, but this book is not the ideal first book for learning a non-PostgreSQL database. That one caveat emptor aside, I highly recommend <em>Practical SQL, 2nd Edition<\/em> to anyone wanting to learn PostgreSQL and how to tell stories with data.<\/p>\n<\/div>\n<div class=\"clearfix text-formatted field field--name-field-article-subhead field--type-text-long field--label-hidden field__item\">\n<p>Practical SQL, 2nd Edition: A Beginner&#8217;s Guide to Storytelling with Data by Anthony DeBarros offers an informative and enjoyable way to learn SQL.<\/p>\n<\/div>\n<div class=\"field field--name-field-lead-image field--type-entity-reference field--label-hidden field__item\">\n<article class=\"media media--type-image media--view-mode-caption\">\n<div class=\"field field--name-field-media-image field--type-image field--label-hidden field__item\">  <img decoding=\"async\" src=\"https:\/\/www.cryptocabaret.com\/wp-content\/uploads\/2022\/04\/brain_data.png\" width=\"520\" height=\"292\" alt=\"Getting started with SQL\" title=\"Getting started with SQL\" loading=\"lazy\"><\/div>\n<div class=\"field field--name-field-caption field--type-text-long field--label-hidden caption field__item\"><span class=\"caption__byline\">Image by: <\/span><\/p>\n<p>Opensource.com<\/p>\n<\/div>\n<\/article>\n<\/div>\n<div class=\"field field--name-field-tags field--type-entity-reference field--label-hidden field__items\">\n<div class=\"field__item\"><a href=\"https:\/\/opensource.com\/tags\/databases\" hreflang=\"en\">Databases<\/a><\/div>\n<\/p><\/div>\n<div class=\"hidden field field--name-field-listicle-title field--type-string field--label-hidden field__item\">What to read next<\/div>\n<div class=\"field field--name-field-default-license field--type-list-string field--label-hidden field__item\"><a rel=\"license\" href=\"http:\/\/creativecommons.org\/licenses\/by-sa\/4.0\/\"><br \/>\n        <img decoding=\"async\" alt=\"Creative Commons License\" src=\"https:\/\/www.cryptocabaret.com\/wp-content\/uploads\/2022\/04\/cc-by-sa--14.png\" title=\"This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.\"><\/a>This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.<\/div>\n<section class=\"field field--name-field-comments field--type-comment field--label-hidden comment-wrapper\">\n<div class=\"comments__count\">\n<div class=\"login\"><a href=\"https:\/\/opensource.com\/user\/register?absolute=1\">Register<\/a> or <a href=\"https:\/\/opensource.com\/user\/login?current=\/rss.xml&amp;absolute=1\">Login<\/a> to post a comment.<\/div>\n<\/p><\/div>\n<\/section>\n<p class=\"wpematico_credit\"><small>Powered by <a href=\"http:\/\/www.wpematico.com\" target=\"_blank\" rel=\"noopener\">WPeMatico<\/a><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>New book teaches readers how to tell data stories with PostgreSQL Joshua Allen Holm Sun, 04\/10\/2022 &#8211; 03:00 Up Register or Login to like. SQL databases can be daunting but can also be very fun if you know how to use them. The information contained in a database can provide many insights to someone who [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":63536,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[307],"tags":[],"class_list":["post-63535","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-open-source"],"_links":{"self":[{"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/posts\/63535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=63535"}],"version-history":[{"count":0,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/posts\/63535\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=\/wp\/v2\/media\/63536"}],"wp:attachment":[{"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=63535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=63535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cryptocabaret.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=63535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}