https://selectstarsql.com/

To see the ‘Table of associated records‘ go the bottom, Pag. 2 ( 👩‍🎓 🖥 For free online version, on the image).


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)

Chapters

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.


Author

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: kaomorphism.com).


🔘 Book page: selectstarsql.com

📌 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.


Reference

Prose for SelectStarSql.com 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 https://kaomorphism.com/ and for recommending it to @isaacfab00, via @States_AI_IA #sql #ai #ia #artificialintelligence #ebook #thebibleai #free #openscience #openaccess #thanks