SQL Practical Tutorial - 21st Century Computer School

Author: Feng Bo, Feng Hao, Xu Ying / Country: Mainland China
Publisher:
Publish Date: 2006-07-01
Features: This book introduces all aspects of the SQL language, not only including basic content such as the structure of SQL, the functions and features of SQL, and the basic syntax of SQL, but also advanced applications such as the creation and deletion of databases, SQL queries, SQL transaction processing, the use of SQL views, the use of SQL triggers and cursors, etc. For the explanation of knowledge points, a large number of practical examples are provided, allowing readers to learn and practice simultaneously, making it easier for them to quickly and comprehensively master the use of SQL and its techniques. SQL (Structured Query Language) is a powerful language and the core of relational database management systems. Proficiency in and flexible application of 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, the creation and deletion of databases, tables, and indexes, adding and modifying data, data queries, data integrity, transaction processing, the use of views, the use of SQL triggers and cursors, SQL security, and optimizing SQL statements to improve performance. The content covers 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 in higher vocational and technical colleges majoring in related fields to systematically learn various aspects of SQL but also as a reference for SQL programmers to consult anytime during their studies and work.
SQL (Structured Query Language) is a powerful language and the core of relational database management systems. Proficiency in and flexible application of 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, the creation and deletion of databases, tables, and indexes, adding and modifying data, data queries, data integrity, transaction processing, the use of views, the use of SQL triggers and cursors, SQL security, and optimizing SQL statements to improve performance. The content covers 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 in higher vocational and technical colleges majoring in related fields to systematically learn various aspects of SQL but also as a reference for SQL programmers to consult anytime during their studies and work.