Product description ※Please note that product information is not in full comprehensive meaning because of the machine translation.
The popular SQL standard introduction has been revised! Let's learn more about how to write SQL and how to use it in applications! Programming Learning Series 『 Database Operations starting with SQL 0 』 is an introduction to the basics and tips of SQL by an author who is a professional database (DB) engineer. From the DB / table structure, you can learn the basics of database operations with SQL, such as the syntax to retrieve and update data, commonly used functions, table joins, etc. From the DB / table structure, you can learn about the basics of database operations with SQL, such as the syntax to retrieve and update data, the WHERE clause, the GROUPBY clause, the HAVING clause, and subqueries, etc. The key features for working with SQL, such as the WHERE clause, the GROUPBY clause, the HAVING clause, and subqueries, etc., and the parts that are difficult for beginners to understand, are explained with a wealth of illustrations and sample programs. The second edition is based on the between various DBs (Oracle, SQLServer, DB2, PostgreSQL, and MySQL) based on the SQL standard, as well as the points that beginners easily get hooked on and basic know-how. In addition to the explanation and sample code corresponding to SQL of the latest DB, a new chapter explaining how to execute SQL from an application program (using PostgreSQL as an example) is added. It follows not only how to write SQL but also how to use it in applications. This book is recommended for those who want to create an application that deals with databases, but do not know what to learn from, want to be able to write SQL properly, and want to acquire a foundation that can be used in the field.