Database Principles and Applications

Author: Yu Xiaochuan
Publisher:
Publish Date: 2005-09-01
Features: This book introduces the basic principles of databases and the applications of Access and SQL Server 2000. The content includes: fundamentals of databases, basic theories of relational databases, database design, database protection, relational database management systems (Access, SQL Server), T-SQL language, database operations, table operations, queries, views, stored procedures, triggers, and the application programming interfaces provided in Access and SQL Server. This book combines theory with practice, explaining both the fundamental principles and methods of databases, primarily based on relational models, as well as the design and implementation of databases through examples and the applications of Access and SQL Server 2000. The content is presented in a step-by-step manner, from simple to complex, and is highly practical. This textbook can be used as a teaching material for the "Database Principles and Applications" course in vocational and technical colleges, and can also serve as a reference for database application development personnel and technical professionals working in computer and information fields.