Practical Sql : A Beginner's Guide to Storytelling with Data

Practical Sql : A Beginner's Guide to Storytelling with Data


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.

Similar Books

ISBN 10: 1449355730
ISBN 13: 9781449355739

02 Aug 2013
Mark Lutz

ISBN 10: 0134757599
ISBN 13: 9780134757599

04 Jan 2019
Martin Fowler

ISBN 10: 1593279280
ISBN 13: 9781593279288

09 May 2019
Eric Matthes

ISBN 10: 1593278780
ISBN 13: 9781593278786

11 Jan 2019
Julien Danjou

ISBN 10: 159327890X
ISBN 13: 9781593278908

21 Dec 2018
Lee Vaughan

ISBN 10: 1593279507
ISBN 13: 9781593279509

01 Jan 2019
Marijn Haverbeke

ISBN 10: 1492040347
ISBN 13: 9781492040347

01 Nov 2019
Alex Petrov

ISBN 10: 1730853935
ISBN 13: 9781730853937

05 Nov 2018
Robin Wieruch

ISBN 10: 1593279566
ISBN 13: 9781593279561

11 Jul 2019
Will Kurt

ISBN 10: 1119510775
ISBN 13: 9781119510772

09 Oct 2018
Andy Kriebel

ISBN 10: 0134997832
ISBN 13: 9780134997834

09 Jul 2018
Bjarne Stroustrup

ISBN 10: 1593279922
ISBN 13: 9781593279929

14 Nov 2019
Al Sweigart

Warning: fopen(/var/www/ failed to open stream: Permission denied in /var/www/ on line 0

Warning: fwrite() expects parameter 1 to be resource, bool given in /var/www/ on line 0

Warning: fclose() expects parameter 1 to be resource, bool given in /var/www/ on line 0