Database Principles and SQL Server 2005 Application Tutorial

Author: Cheng Yunzhi
Publisher:
Publish Date: 2006-08-01
Features: This book comprehensively covers the principles of databases and the application of SQL Server 2005. Chapters 1-4 discuss the fundamental theories of databases, including an overview of databases, data models, relational databases, and database design. Chapters 5-13 focus on the use of the database management system SQL Server 2005, covering topics such as the basics of SQL Server 2005, T-SQL language, databases and tables, database queries, views, indexes, and cursors, stored procedures and triggers, database backup and restore, import/export, system security management, transactions, batches, and locks. Chapters 14 and 15 present practical examples of database applications, introducing methods for database development using VB.NET and C#.NET. Finally, the book provides experiments and appendices. This book combines theory with practice, explaining both the fundamental principles and methods of relational databases and the design and implementation methods of databases in conjunction with the application of SQL Server 2005. It is suitable as a textbook for database and database application courses in undergraduate, junior college, vocational colleges, and software vocational colleges. It can also serve as an introductory textbook for beginners learning databases and a technical reference for database application system developers.