×
Time can be your best friend and your worst enemy depending on whether you use it or waste it.
--Your friends at LectureNotes
Close

Notes on SQL

  • Other
  • 38 Views
  • 3 Offline Downloads
  • Uploaded 5 months ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

Chapter 3: SQL Database System Concepts, 5th Ed. ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use

Text from page-2

Chapter 3: SQL Data Definition Basic Query Structure Set Operations Aggregate Functions Null Values Nested Subqueries Complex Queries Views Modification of the Database Joined Relations** Database System Concepts, 5th Ed., June 2006 3.2 ©Silberschatz, Korth and Sudarshan

Text from page-3

History IBM Sequel language developed as part of System R project at the IBM San Jose Research Laboratory Renamed Structured Query Language (SQL) ANSI and ISO standard SQL: SQL-86 SQL-89 SQL-92 SQL:1999 (language name became Y2K compliant!) SQL:2003 Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features. Not all examples here may work on your particular system. Database System Concepts, 5th Ed., June 2006 3.3 ©Silberschatz, Korth and Sudarshan

Text from page-4

Data Definition Language Allows the specification of: The schema for each relation, including attribute types. Integrity constraints Authorization information for each relation. Non-standard SQL extensions also allow specification of The set of indices to be maintained for each relations. The physical storage structure of each relation on disk. Database System Concepts, 5th Ed., June 2006 3.4 ©Silberschatz, Korth and Sudarshan

Suggested Materials

Lecture Notes