chapter  11
14 Pages

SQL for Database Query

When using a particular database management system, such as Access, we can use the query development environment to create queries. Internally, the database management system generates the query code in SQL, as seen in the following section. In principle, we do not need to write SQL code if we use a single database management system. However, when using Java or .NET to develop a Web application that is connected to databases (Oracle, DB2, Access, etc.) one must write SQL code that is embedded in the programs to querying and updating the databases. This is the major motivation for use to learn SQL in this course.