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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial