Unlearning SQL by Steven F. Lott

6 Oct, 2024
added by Steven Lott

This book shows you how to translate essential SQL concepts into the Python language so they can be applied outside the database environment. A database includes features for access controls, persistence, and concurrent updates, none of which may be needed for an extract-transform-load pipeline. This helps restate the SQL design concepts into Python applications that are faster and simpler because they don't rely on a database.

The ideas also apply to data analytic problems where the SQL GROUP-BY is a helpful design pattern. This book provides concrete examples of expressing the concept in Python instead of SQL.

Related Technologies:

Related Resources

Check what other resources can help you on the Python developer's path.

The Quick Python Book, Fourth Edition is the definitive guide to the Python language, written by Python authority and former Chair of the Python Software Foundation Board or Directors Naomi Ceder. With the personal touch of a skilled teacher, Naomi beautifully balances details of the language with the insights and advice you need to handle any task. You’ll learn skills you can turn to doing almost anything with Python—from analyzing data, to writing scripts, and even developing software. Plus, quick-check questions, end-of-chapter labs, and a final case study all help consolidate your knowledge.

A project-based approach to learning Python programming for intermediate users. Intriguing projects teach you how to tackle challenging problems with code.

Dead Simple Python
Book Paid

Dead Simple Python is a thorough introduction to every feature of the Python language for programmers who are impatient to write production code. Instead of revisiting elementary computer science topics, you’ll dive deep into idiomatic Python patterns so you can write professional Python programs in no time.

Add a Python-related resource!

Do you have a useful resource for other Python developers? List them here!