APPENDIX

The Basics of SQL

Structured Query Language, or SQL, is the ISO-ANSI standard data definition language and data manipulation language for relational database management systems (DBMSs). Individual relational database systems use slightly different dialects of SQL syntax and naming rules, and these differences can be seen by consulting the SQL user guides for those systems. In this text, where we explore each step of the logical and design portion of the database life cycle, many examples of database table creation and manipulation make use of SQL syntax.

The basic use of SQL can be learned quickly and easily through reading this appendix. The more advanced features, such as statistical analysis and presentation of data, require more ...

Get Database Modeling and Design, 5th 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.