

Buy anything from 5,000+ international stores. One checkout price. No surprise fees. Join 2M+ shoppers on Desertcart.
Desertcart purchases this item on your behalf and handles shipping, customs, and support to British Virgin Islands.
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. Youโll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. Youโll learn how to: - Create databases and related tables using your own data - Define the right data types for your information - Aggregate, sort, and filter data to find patterns - Use basic math and advanced statistical functions - Identify errors in data and clean them up - Import and export data using delimited text files - Write queries for geographic information systems (GIS) - Create advanced queries and automate tasks Learning SQL doesnโt have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases. This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL. Review: Great resource for data practitioners - I'm a huge fan of books by No Starch Press. The texts are usually well written and every book I've read so far gives excellent examples that are broken down point by point with great explanations. I already have some basic SQL skills but decided to pick up this book anyway to round out my knowledge. Practical SQL definitely follows in the footsteps of other No Starch programming books. The written explanations provide the reader with great explanations of the SQL language and the code examples provide a lot of insight with point by point breakdown when necessary. One unique thing about this book compared to other SQL books is that the author has a research and journalism background. A lot of SQL books and tutorials I've come across focus on business databases. For those of us who aren't formally part of the business or technology fields and more oriented in the social sciences, this book is a tremendous resource. The author's problem-solving processes and example datasets (often real world examples) are great for social scientists that deal with real-world messy data. Review: Great book for anyone willing to learn SQL in any application. - The practicality of the SQL codes and the prompt willingness of Anthony himself to answer your questions are humbling and inspiring. This book has prepared me to know about relational databases in dept. It addresses all applications/browsers, ensuring you have the information you need for any operating system is available. The detailed update on the types of data, prepares you to understand data types and why they are used. Mining texts with data, data visualizations, and the use of PostgreSQL and MacBook and its connectivity to public servers like AWS is pretty cool. I will like to see more questions in future editions at the end of the chapter "Try it yourself". This will give students more practice opportunities. I wholeheartedly recommend this book and will readily buy it again.




| Best Sellers Rank | #919,433 in Books ( See Top 100 in Books ) #139 in SQL #345 in Data Mining (Books) #684 in Database Storage & Design |
| Customer Reviews | 4.7 out of 5 stars 275 Reviews |
S**O
Great resource for data practitioners
I'm a huge fan of books by No Starch Press. The texts are usually well written and every book I've read so far gives excellent examples that are broken down point by point with great explanations. I already have some basic SQL skills but decided to pick up this book anyway to round out my knowledge. Practical SQL definitely follows in the footsteps of other No Starch programming books. The written explanations provide the reader with great explanations of the SQL language and the code examples provide a lot of insight with point by point breakdown when necessary. One unique thing about this book compared to other SQL books is that the author has a research and journalism background. A lot of SQL books and tutorials I've come across focus on business databases. For those of us who aren't formally part of the business or technology fields and more oriented in the social sciences, this book is a tremendous resource. The author's problem-solving processes and example datasets (often real world examples) are great for social scientists that deal with real-world messy data.
J**N
Great book for anyone willing to learn SQL in any application.
The practicality of the SQL codes and the prompt willingness of Anthony himself to answer your questions are humbling and inspiring. This book has prepared me to know about relational databases in dept. It addresses all applications/browsers, ensuring you have the information you need for any operating system is available. The detailed update on the types of data, prepares you to understand data types and why they are used. Mining texts with data, data visualizations, and the use of PostgreSQL and MacBook and its connectivity to public servers like AWS is pretty cool. I will like to see more questions in future editions at the end of the chapter "Try it yourself". This will give students more practice opportunities. I wholeheartedly recommend this book and will readily buy it again.
J**Y
Buy again
Excellent
B**.
A Remarkable Introduction to SQL
I really enjoyed this book during my thorough reading of it. As the title suggests, the book is primarily tailored to those who want to use SQL for data analysis and statistical examination (probably stemming from the author's background in data-based investigative journalism), however, about 90 percent of its contents are still directly relevant and applicable to the general SQL requirements of back-end development and database administration, so it is still a fantastic and very relevant read for those who are seeking a general introduction to SQL and relational databases for purposes other than data exploration and analysis. The book is sometimes (though rarely) shallow in its explanations on certain topics which lead to the 4 star rating, but in general, it is a great text with practical and down-to-earth examples, exercises, and instruction that I would recommend to anyone.
J**S
DeBarros Told a GREAT SQL story!
very effective book. Took this beginner from ZERO to ... TBD
P**T
Good concise info on PostgreSQL
I bought this book because I have had good luck with No Starch books before, and I heard that this was basically tailored to PostgreSQL. I set up and installed the software based on the instruction in the book and uploaded some CSVs to create a couple of DBs. I still gotta keep reading through the book and working out on things!
J**N
Great book overall
I think itโs great for getting started with learning SQL. Though I wish the author explained the code snippets better in the book rather than always referring to his GitHub account all the time. Otherwise itโs a great book Update: Finally finished the book and I love it. Knowing basic sql actually got me a new job as a data analyst for a marketing firm.
C**S
This is a great introduction
This book teaches you SQL using PostgreSQL. Though it doesn't dedicate alot of material to Postgres itself it does add a few chapters at the end for the software. The main thing is to learn SQL and Postgres can come later in a different book.
A**R
Allying theory and practice
The main concepts of SQL are clearly explained and their repeated use throughout the book is good for long-term memorization and mastery. Besides, they โare put in a real-world perspective and their relevance is demonstrated when they are used to exploit real-world data like the US Census of 2010. The book is easy to follow, and rich in content.
T**R
Content is amazing Print is worst
The book and its content are great. I highly recommend reading this. Especially if you want to begin your journey of learning SQL. The print is the worst. The pages are shifted towards right. Paragraphs are almost faded. It's not a good experience reading the book. This is a cheap print copy of the book.
M**A
Great starter SQL book
From zero to hero in a few weeks. I had absolutely zero knowledge in SQL but after reading few chapters and playing with database I was able to graps main concepts very fast. Recommended
L**O
A good text book
Excellent text book
I**R
a
a
Trustpilot
2 weeks ago
2 months ago