lec 3_sql.pptVIP

Lecture 3: SQL — Database System Principles 211C0030 Database System Principles Lecture 3: SQL  Yunjun Gao (高云君) College of Computer Science Zhejiang University Spring Summer 2012Introduction to SQL SQL has been widely used in the world. Structured Query Language (SQL, 结构化查询语言), 1975, IBM. System R. called Structured English QUEry Language (SEQUEL). SQL-86: the first standard by ANSI --- American national standard institute, ISO standard. SQL-89: minor revision. SQL-92: currently supported by most commercial RDBMS. SQL-99: a major extension of SQL-92, partly supporte