-
$39.95
May 01, 2018 | ISBN 9781593278274
Buy the Paperback:
YOU MAY ALSO LIKE
Too Much Fun
Log-Linear Models, Extensions, and Applications
Quotes for All Seasons
National Parks Stickerology
Computing Legacies
Darwinizing Gaia
A Just Transition for All
Starlore of the Constellations
Houseplant
Praise
One of the best-organized travelogues we’ve seen into the SQL realm.”
—Newstips Bulletin
“Slightly more fun and more engaging [than Learning SQL from O’Reilly].”
—Python Programmer, YouTuber
“Practical SQL will take you from an absolute databases beginner towards becoming a database and SQL master. This book is one of those books that you feel like reading a novel, not a technical book. It uses an easy to follow and understand the approach that makes it easy to read for people from all backgrounds.”
—Sara A. Metwalli, Towards Data Science
“I recommend reading Practical SQL by Anthony DeBarros for a more in-depth look on how to implement regression analysis and other analytical tools using SQL.”
—Michael Grogan, Towards Data Science
Table Of Contents
Introduction
Chapter 1: Creating your first database & table
Chapter 2: Beginning Data Exploration with SELECT
Chapter 3: Understanding Data Types
Chapter 4: Importing and Exporting Data
Chapter 5: Basic Math and Stats
Chapter 6: Joining Tables in a Relational Database
Chapter 7: Table Design that Works for You
Chapter 8: Grouping and Summarizing Data
Chapter 9: Cleaning , Modifying, Deleting Data
Chapter 10: Ranks, Rates, asnd Stats
Chapter 11: Dealing with Dates
Chapter 12: Advanced Queries
Chapter 13: Full-Text Search
Chapter 14: GIS
Chapter 15: Views
Chapter 16: Working from the command line
Chapter 17: Maintenance
Appendix A: Alternative software and text editors
Appendix B: Solutions
21 Books You’ve Been Meaning to Read
Just for joining you’ll get personalized recommendations on your dashboard daily and features only for members.
Find Out More Join Now Sign In