Practical SQL
A Beginner's Guide to Storytelling with Data
| Price | $27.16 - $29.84
|
| Rating |  |
| Author | Anthony DeBarros |
| Publisher | No Starch Press |
| Published | 2018 |
| Pages | 392 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1593278276 |
| ISBN-13 | 9781593278274 |
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.
Chapter 1:
→ https://itbook.store/files/9781593278274/chapter1.pdf
Source Code:
→ https://itbook.store/files/9781593278274/sourcecode.zip
- Anthony DeBarros (2 books)
5 5 306
Similar Books
by Anthony DeBarros
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. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use the open-sourc...
Price: $30.94 | Publisher: No Starch Press | Release: 2022
SQL Queries for Mere Mortals, 4th Edition 
by John L. Viescas
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...
Price: $18.13 | Publisher: Addison-Wesley | Release: 2018
Professional SQL Server 2008 Internals and Troubleshooting
by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort
When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...
Price: $5.49 | Publisher: Wrox | Release: 2010
Sams Teach Yourself SQL in 24 Hours, 5th Edition
by Ryan Stephens, Ron Plew, Arie D. Jones
In just 24 sessions of one hour or less, you'll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you'll learn hands-on through practical examples. Each lesson builds on what you...
Price: $6.69 | Publisher: SAMS Publishing | Release: 2011
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition
by Ben Forta
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.This handy pocket guide starts with ...
Price: $17.59 | Publisher: SAMS Publishing | Release: 2017
Programming Microsoft SQL Server 2012
by Leonard Lobel, Andrew Brust
Take your database programming skills to a new level - and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server develop...
Price: $21.95 | Publisher: Microsoft Press | Release: 2012
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
by Itzik Ben-Gan
Optimize your queries - and obtain simple and elegant solutions to a variety of problems - using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you're a database administrator or developer, ...
Price: $26.72 | Publisher: Microsoft Press | Release: 2012
by Robert Pearl
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 intere...
Price: $42.95 | Publisher: Apress | Release: 2015