Database Design Technology (SQL Server)

Author: Sun Hui
Publisher: Beijing Hope Electronic Press
Publish Date: 2002-09-01
Features: "Database Design Technology SQL Server" is a teaching material resulting from the key research project of the "Nineth Five-Year Plan" of the National Education Science. It reflects the brand-new teaching and learning philosophy of vocational and technical colleges, as well as the mainstream technologies and skills in the current IT field. It is part of the "Modern Vocational and Technical College Information Technology Textbooks" series. The book consists of 11 chapters, covering topics such as: fundamentals of databases, relational database theory, an overview of SQL Server 7.0, databases and database operations, tables, queries, other database objects, programming with Transact-SQL, database security and permission management, backup and recovery, applications provided by SQL Server 7.0, and answers to exercises. The book focuses on cultivating students' abilities in relational database design, operation, and management. Based on the introduction of database principles and relational database theory, it provides detailed explanations of SQL Server 7.0 operations with specific examples. The content is innovative, features exemplary cases, and covers a broad range of knowledge, emphasizing practical application and hands-on learning. Each chapter includes numerous relevant exercises with accompanying answers to help readers apply and reinforce theoretical knowledge. This book serves not only as a textbook for vocational and technical colleges and various higher education institutions in the field of databases but also as a valuable reference for professionals and enthusiasts who use SQL Server for database applications and development.