Skip to Content
Information Modeling and Relational Databases, 2nd Edition
book

Information Modeling and Relational Databases, 2nd Edition

by Terry Halpin, Tony Morgan
July 2010
Intermediate to advanced content levelIntermediate to advanced
976 pages
30h 19m
English
Morgan Kaufmann
Content preview from Information Modeling and Relational Databases, 2nd Edition

13. Other Database Features

13.1SQL: The Bigger Picture
13.2SQL: Defining Tables
  • Creating Tables

  • Maintaining Referential Integrity

  • Changing Table Definitions

13.3SQL: Views
13.4SQL: Triggers
13.5SQL: Routines
  • User Defined Functions (UDFs)

  • Stored Procedures

13.6More Database Objects
  • Sequences

  • Indexes

  • Cursors

13.7Transactions and Concurrency
13.8Security and Metadata
13.9Exploiting XML
  • SQL7XML

  • Using XQuery

13.10Summary
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Information Modeling and Relational Databases, 3rd Edition

Information Modeling and Relational Databases, 3rd Edition

Terry Halpin, Tony Morgan
Database Modeling and Design, 5th Edition

Database Modeling and Design, 5th Edition

Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

Publisher Resources

ISBN: 9780123735683