SQL Practical Concise Tutorial

Author: Luo Jun, He Yu
Publisher:
Publish Date: 2004-08-01
Features: This book is rich in content, clear in explanation, and highly practical. It provides typical examples and detailed operation steps for various specific uses of SQL statements, offering a thorough understanding of key concepts. This book can be considered a valuable guide for all database users. It introduces the database programming methods of the SQL-3 standard in a step-by-step manner. Chapters 1-2 cover the basics of databases and SQL-3; Chapters 3-10, with specific examples, demonstrate the practical use of various SQL statements, including how to create databases and perform various data operations; Chapters 11-13 discuss the optimization, security, and transaction processing, cursors, and stored procedures of SQL statements. In the appendix, the book lists the various data used in the database examples and common errors in SQL statements for reference and understanding. This book is suitable as a textbook for information technology-related majors in higher education institutions and can also serve as a reference for users of database operating systems supporting the SQL-3 standard. Additionally, the typical examples and various tips provided in the book make it a valuable resource for advanced database programmers.