Practical SQL

A Beginner's Guide to Storytelling with Data

Bookstore > Books > Practical SQL

Practical SQL
update prices
Price$23.99 - $33.03
AuthorAnthony DeBarros
PublisherNo Starch Press
FormatPaper book / ebook
EBook Hardcover Paperback

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.

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.

4 5 10

Similar Books

Healthy SQL

Healthy SQL

Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have...
Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....
Mastering SQL Queries for SAP Business One

Mastering SQL Queries for SAP Business One

Practical SAP query examples from an SAP Business One expert. Detailed steps to create and troubleshoot SQL queries for Alerts, Approvals, Formatted Searches, and Crystal Reports. Understand the importance and benefit of keeping SQL queries simple and easy to understand. Benefit from special tips and tricks related directly to SQL queries...
SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.Step by step, Viescas guides you through creating re...
A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's uniqu...
Professional Microsoft SQL Server 2008 Programming

Professional Microsoft SQL Server 2008 Programming

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write co...