Learning SQL
by Alan Beaulieu · first published 2005
4mentions
3recommended by
4HN commenters
2014–2024first – last mentioned
75% recommend25% critical
Updated for the latest database management systems, this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations, annotated examples, and exercises to let you practice the skills you learn.
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
Wonderful list! The C-Store papers are particularly fine reading. For people who looked at this wanting to get going with using database systems (as opposed to creating them), I'd recommend: Learning SQL by Alan Beaulieu SQL Performance Explained by Markus Winand SQL Cookbook by Anthony Molinaro The three of these will take you up to a pretty useful level of SQL knowledge/understanding. The…
on “Readings in Databases” ↗I'll vouch for this plug! I've spent quite a bit of time learning SQL (and Postgres specific stuff), and this was one of my favorite resources. I can also recommend Learning SQL by Alan Beaulieu, which was recommended in some HN comment. After looking into various books,…
on “SQLite Release 3.25.0 adds support for window functions” ↗Recently, somebody shared resources to start learning deep learning [0]. It includes learning SQL. These are some recommendations: 1. Book "Head First SQL: Your Brain on SQL - A Learner's Guide" by Lynn Beighley 2. Book "Learning SQL: Generate, Manipulate, and Retrieve Data" by Alan Beaulieu 3.…
on “Ask HN: How to Learn SQL?” ↗> I could see it being used in a tool for new devs or those who've focused on a JS stack and need some help with SQL Or they could buy a book like Learning SQL. Or spend a weekend on Youtube.
on “Show HN: We open sourced our entire text-to-SQL product” ↗