ebmgh.com

A former boss told me to spend a few hours working through the tutorials at SQLCourse.com several years ago. Funny advice to an environmental engineer? Probably not, since almost all modern engineering involves computing, and most non-trivial computer programs use databases to store and retrieve information.

SQL, or “structured query language” is a standard way of interacting with a database. These free online courses are very good, and I still find myself referring back to them now and then. Learn how to select records, make updates, and join database tables…

SQLCourse conents:

1. What is SQL?
2. Table basics
3. Selecting data
4. Creating tables
5. Inserting into a table
6. Updating records
7. Deleting records
8. Drop a table
9. Advanced Queries

SQLCourse2.com contents:

1. Start Here – Intro
2. SELECT Statement
3. Aggregate Functions
4. GROUP BY clause
5. HAVING clause
6. ORDER BY clause
7. Combining Conditions & Boolean Operators
8. IN and BETWEEN
9. Mathematical Functions
10. Table Joins, a must