October 5, 2011

New SQL Course

Capstone today releases Course 301, "Introduction to SQL,", an excellent grounding in the Structured Query Language. This is a "serious introduction:" we start from scratch, but cover a lot of ground in three days, and author Tia Rayl has made sure that students are aware of important subtleties and pitfalls in SQL92 and SQL99 syntax and usage.

The course is three days in duration and supports the following database products:

  • Derby 10.6, bundled with the lab software
  • Oracle 9i, 10g, and 11g, as installed separately

Course 301 also makes an excellent companion to Course 168, our JDBC course, and to JPA material in various parts of our Java EE curriculum. Course 168 has been updated to version 6.0.1, in order to synch perfectly with the schema used in Course 301. Both courses are available immediately.