APPENDIX B

image

SQL

SQL is an industry-wide, standard set of relational commands that allows users to both define and manipulate data in a database. SQL has been adopted as the common interface for relational data definition and data manipulation functions on all major relational DBMS (Database Management Systems).

This chapter will introduce the reader to SQL and show how SQL commands can be used within a Java application.

After finishing this chapter, you will understand:

  • The most commonly used SQL commands and their syntax
  • The major SQL components

After finishing this chapter, you will be able to:

  • Create schemas, tables, views, and indexes

Get Beginning Java with WebSphere now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.