This is the textbook used for the introductory CS course (CS61A) at UC Berkeley. The course material is available at http://cs61a.org/fa18 (The course uses Python 3, Scheme, and SQL).

There are some neat projects (students build a Scheme interpreter and implement game logic as part of the projects)

Previous Hacker News Discussions (from which I’ve copied my comment)

https://news.ycombinator.com/item?id=11465234 https://news.ycombinator.com/item?id=3491142 https://news.ycombinator.com/item?id=3141996