SQL Application and Development Standard Tutorial

Author: Yang Zhishu
Publisher:
Publish Date: 2006-07-01
Features: This book primarily introduces the database application and development techniques of SQL, covering topics such as an overview of relational databases and SQL, the SQL environment, operations on data tables with SQL, database query knowledge, modifications of SQL data, advanced queries using the SELECT statement, joining data tables, accessing and modifying data with subqueries, functions and expressions in SQL, data integrity, using indexes, T-SQL programming, SQL procedures, SQL triggers and cursors, managing SQL transactions and concurrency control mechanisms, as well as database security knowledge. When introducing the specific content of each chapter, the book closely integrates examples with a sample database and database products such as Access, SQL Server, and Oracle, achieving a balance between theory and practice. The book highlights practical application knowledge of relational databases and SQL Server, Access, Oracle, and other relational database products, with a well-structured layout and rich examples. It is suitable as a training textbook for SQL database applications and can also serve as a reference for SQL database practitioners.