Selectstarsql
| Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
|---|---|---|---|---|---|---|---|---|---|---|
| Awesome Sqlite | 255 | 5 days ago | cc0-1.0 | |||||||
| A collection of awesome sqlite tools, scripts, books, etc | ||||||||||
| Mostly Free Resources For Almost Everyone | 240 | 2 years ago | 3 | unlicense | ||||||
| A list of mostly free resources for almost anyone. | ||||||||||
| Bible Database | 204 | 6 days ago | 5 | C | ||||||
| Bible databases as XML, JSON, SQL & SQLITE3 Database format for various languages. Developers can download it freely for their development works. Freely received, freely give. | ||||||||||
| Query Composer | 168 | 6 years ago | 1 | March 26, 2016 | 1 | mit | Ruby | |||
| A library for composing complex SQL queries by defining their subcomponents and the dependencies between them. | ||||||||||
| Dapper Samples | 150 | a year ago | 1 | apache-2.0 | C# | |||||
| Tutorial samples that shows how to use Dapper .NET | ||||||||||
| Effective Sql | 146 | 5 years ago | PLSQL | |||||||
| Selectstarsql | 133 | a month ago | 1 | JavaScript | ||||||
| An interactive SQL book | ||||||||||
| Oreilly_getting_started_with_sql | 125 | 4 years ago | 3 | |||||||
| Database files for the O'Reilly book "Getting Started with SQL: A hands on approach for beginners" http://goo.gl/z3zG54 | ||||||||||
| Openlibrary Search | 91 | 2 months ago | 4 | Python | ||||||
| Searching Open Library by keywords to return ISBNs | ||||||||||
| The Free Hive Book | 88 | 6 years ago | HTML | |||||||
| A free electronic book about Apache Hive. The book is geared towards SQL-knowledgeable business users with some advanced tips for devops. | ||||||||||
Select Star SQL
This is the repository for selectstarsql.com. It is an interactive book that teaches SQL by conveying a mental model for writing queries.
Development
The structure of the code is pretty standard for a Jekyll-built site. See Jekyll Directory Structure.
All the pages are stored as markdown(.md) files in the top-level directory. Jekyll takes these markdown files and converts them into html files in /_site. During the conversion, it does all sorts of cool energy-saving things like embedding them in templates with standardized header and footer elements. These templates are stored in /_layouts.
You can serve a local version by running jekyll serve.
The main technical complexity lies in the interactive sql exercises. These are implemented as a custom html tag in /scripts/main.js. Firefox doesn't support custom html elements by default, so we pulled in the custom-elements.min.js library from unpkg. (See _layouts/default.html.)
Contributing
To contribute, either email me directly at [email protected], or submit a pull request by following these steps:
- Install Jekyll and other project dependencies (
bundle install) - Fork this repo (button on the top right)
- Clone your forked repo
git clone https://github.com/MYUSERNAME/selectstarsql/ - Make your changes
- Run
jekyll serveand check your changes on your browser at your localhost address. This will probably be http://127.0.0.1. - Commit your changes, and push it to your forked repo
- Click "Create Pull-request" when looking at your forked repo on Github.
Licensing
The prose of the book is licensed by Zi Chong Kao under a Creative Commons BY-SA 4.0 License which allows sharing and adapting under the same license and with attribution. The code and datasets are released into the public domain under the Creative Commons CC0 License.
Todo
- Complete hiatus tutorial
- Clarify double quotes for SQLite
- Improve CASE WHEN explanation
