21st Century Computer School: SQL Practical Tutorial

Author: Feng Bo
Publisher:
Publish Date: 2006-07-01
Features: SQL (Structured Query Language) is a powerful language and the core of relational database management systems. Mastering and flexibly applying SQL is a fundamental skill for database beginners and data application developers. The book is divided into 14 chapters, covering topics such as the functions and features of SQL, SQL expressions and built-in functions, creating and deleting databases, tables, and indexes, adding and modifying data, data querying, data integrity, transaction processing, the use of views, SQL triggers and cursors, SQL security, and optimizing SQL statements to improve performance. The content includes the main knowledge points of SQL and is implemented using both SQL Server 2000 and Oracle 10g. The book is well-structured, concise in language, and rich in content. It is not only suitable as a textbook for students of higher vocational and technical colleges in relevant fields to systematically learn various aspects of SQL but also serves as a reference for SQL programmers to consult anytime during learning and work.