O'Reilly logo

Relational Database Design and Implementation, 3rd Edition by Jan L. Harrington

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Using SQL to Implement a Relational Design
As a complete data manipulation language, SQL contains statements that allow you to insert, modify, delete, and retrieve data. However, to a database designer, the portions of SQL that support the creation of database structural elements are of utmost importance. In this chapter you will be introduced to the SQL commands that you will use to create and maintain the tables, views, indexes, and other structure that make up a relational database.
The actual file structure of a database is implementation dependent, as is the procedure needed to create a database file. Therefore, the discussion in this chapter assumes that the necessary database files are already in place.
Note: You will see extensive ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required