{"repo":"anthonydb/practical-sql-2","free":true,"listed":false,"github":"https://github.com/anthonydb/practical-sql-2","clone":"git clone https://github.com/anthonydb/practical-sql-2.git","description":"Code and Data for the Second Edition of \"Practical SQL\" by Anthony DeBarros, published by No Starch Press.","language":"PLpgSQL","stars":750,"topics":["sql","postgresql","data-analysis"],"license":null,"category":"databases-storage","readme_excerpt":"Practical SQL, 2nd Edition A Beginner's Guide to Storytelling with Data Practical SQL, 2nd Edition is a beginner-friendly guide to the database programming language SQL. Author Anthony DeBarros starts with beginner SQL concepts such as queries, data types, and basic math and aggregation, and then works through intermediate and advanced topics including statistics, cleaning data, GIS, and automating tasks. Along the way, you'll use real-world data from the U.S. Census and other government agencies and learn the fundamentals of good database design. This is a book not only about SQL but about best practices for using it for thorough, accurate data analysis. A Note About Editions If you're reading the first edition of the book, published in 2018, please use the code and data in the first edition repository. If the cover of your copy does not say, \"2nd Edition,\" then you're using the first edition. Important Updates to pgAdmin In the book, we write SQL queries and manage our PostgreSQL databases with pgAdmin, a free and open source graphical user interface. pgAdmin is under continuous development, and its current interface may differ from the screenshots and instructions in the book. Please check the book FAQ for updates. Who Is This Book For? Practical SQL is ideal for beginners as well as those who know some SQL and want to go deeper. Which Database Does The Book Use? We use PostgreSQL, which is free and open source. PostgreSQL is used by some of the world's largest companies. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/anthonydb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/anthonydb/practical-sql-2/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}