Select Star SQL

Unclassified recommendation

This free and interactive guide is fun and very well done. Def worth a look if you want to add SQL to your kit bag.

Resultado de imagen de ISAAC FABER Isaac Faber Ph.D. (Chief Data Scientist at U.S. Army AI Task Force)


Chapter 1 examines Napoleon Beazley’s argument against capital punishment. We learn the structure of a SQL query and row operations on a table.

Chapter 2 estimates how many executed inmates may have been innocent. The technical theme is aggregating the entire table.

Chapter 3 studies counties with unusually high numbers of executions. We generalize Chapter 2 by applying aggregations on groups of rows.

Chapter 4 explores extended periods when no executions have occurred. Its theme is extending the table using joins.

Chapter 5 provides closing remarks and a collection of miscellaneous user-added challenge questions.


photo of kao

Zi Chong Kao. Software engineer based in the San Francisco Bay Area. He works at Stripe helping businesses issue credit cards. Some of his formative experiences were at: The Chinese High School, Singapore, Delta Wing, Officer Cadet School, The University of Chicago, Quora’s data science team and The Recurse CenterI. He has created Select Star SQL, an interactive book for learning SQL and Socratic Regression, a geometric guide to linear regression. (Source:

🔘 Book page:

📌 For your review and personal analysis, copy and paste the address of the book page in your browser. The educational and research community will also thank you for evaluating this information (above) and for making rational and timely personal comments. Using appropriate language at all times. Special attention must be paid to the technical, ethical and labor implications of Artificial Intelligence (AI). It will affect us all. And it is everyone’s responsibility.


Prose for is licensed by Zi Chong Kao under a Creative Commons BY-SA 4.0 License.

Thank you very much for this work to Zi Chong Kao and for recommending it to @isaacfab00, via @States_AI_IA #sql #ai #ia #artificialintelligence #ebook #thebibleai #free #openscience #openaccess #thanks

Click to rate this post
[Total: 0 Average: 0]