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