SQL Application and Development Standard Course - Tsinghua Computer Training Hall

Author: Yang Zhimei
Publisher:
Publish Date: 2006-07-01
Features: This book primarily introduces the database application and development techniques of SQL, covering topics such as relational databases and SQL overview, SQL environment, operations on data tables with SQL, database query knowledge, SQL data modification, advanced queries using the SELECT statement, joining 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, and Oracle, with a well-structured layout and rich examples. It is suitable as a training textbook for SQL database, as well as a reference for SQL database application professionals.