Understanding the New SQL: A Complete Guide (The Morgan Kaufmann Series in Data Management Systems) - Softcover

Melton, Jim; Simon, Alan R.

Softcover

ISBN 10: 1558602453 ISBN 13: 9781558602458

Publisher: Morgan Kaufmann, 1992

Synopsis

Understanding the New SQL Providing an introduction to SQL, this work describes practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. It includes a tutorial on basic relational database concepts. It also presents an explanation of the differences between SQL-89 and SQL-92. Full description

About this title

From the Back Cover

SQL is the way to develop, program, and use database applications. SQL-92 is a major advance over earlier versions, offering the first complete SQL language. DB programmers will have the advantage of knowing that applications written in SQL-92 will be portable to all hardware platforms for many years to come. As the editor of the new standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, the authors clearly present the power of SQL. They describe practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. Beginning with a tutorial on basic relational database concepts, subsequent chapters develop SQL and clarify the differences between SQL-89 and SQL-92. Throughout, a retail video and music store is used as an example that develops with the SQL presentation. The book is enhanced by a complete dynamic SQL example, coverage of international character sets, and a look at future generations of SQL. Whether you're a newcomer to SQL or an experienced programmer using PCs, workstations, mini- or mainframes, Understanding the New SQL is an essential resource for current and future implementation of SQL.

Synopsis

This is an effective introduction to SQL, and a comprehensive reference for years to come. As the editor of the 1992 standard, Jim Melton is an authority on the language and its new features. Using a highly readable, conversational style, he and Alan Simon clearly present the power of SQL. They describe practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design. It includes a tutorial on basic relational database concepts. It presents a clear explanation of the differences between SQL-89 and SQL-92. It provides retail video and music store as an example that develops with the SQL presentation. It offers coverage of international character sets.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 1992
• ISBN 10: 1558602453
• ISBN 13: 9781558602458
• Binding: Paperback
• Language: English
• Number of pages: 536