Due to vshaunmann's inactivity, I have decided to update and keep my fork of his repo, but have it up to date with the pull requests that were never accepted.
SQL tutorial covering basic, intermediate and advanced SQL functions. GalaXQL software generates three tables of stars, planets and moons, each with 50,000 rows of data.
- SELECT ..
- SELECT .. FROM ..
- SELECT .. FROM .. WHERE .. ORDER BY .. DESC
- MAX(), MIN(), COUNT(), AVG(), SUM(), NULL
- INSERT INTO .. VALUES ..
- INSERT INTO .. SELECT ..
- Transactions, DELETE FROM .. WHERE ..
- UPDATE .. SET .. WHERE ..
- SELECT FROM table1, table2.., DISTINCT
- SELECT .. FROM (SELECT .. FROM ..)
- SELECT FROM .. JOIN ..
- CREATE VIEW, DROP VIEW
- CREATE TABLE, DROP TABLE
- Constraints
- ALTER TABLE
- SELECT .. GROUP BY .. HAVING ..
- UNION, UNION ALL, INTERSECT, EXCEPT
- Triggers
- Indexes
- Software and instruction is available at http://sol.gfxile.net/galaxql.html