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 ...
Get Relational Database Design and Implementation, 3rd Edition 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.
