PostgreSQL 11.2 中文文档

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. * A tutorial on basic relational database concepts. * A clear explanation of the differences between SQL-89 and SQL-92. * A retail video and music store as an example that develops with the SQL presentation. * Coverage of international character sets. "...clearly describes practical methods of using SQL to solve problems, advanced SQL query expressions, dynamic SQL, transaction models, and database design...written by an authority on the language at its new features." "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."--Jacket Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. With fresh new problems and a new lab manual, students get more opportunities to practice the fundamentals of design and implementation. More real-world examples serve as engaging, practical illustrations of database concepts. The Fifth Edition maintains its coverage of the most popular database topics, including SQL, security, data mining, and contains a new chapter on web script programming for databases 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. This edition combines clear explanations of database theory and design with up-to-date coverage of models and real systems. It features excellent examples and access to Addison Wesley's database Web site that includes further teaching, tutorials and many useful student resources