SQL Server Database Development Classic Examples Solved

Author: Xia Banggui et al.
Publisher:
Publish Date: 2006-01-01
Features: This book primarily introduces how to use SQL Server 2000 for the development of database management systems. The book is divided into three parts: Basics, Applications, and Advanced. The examples in each part cover applications in the field of SQL Server 2000 database management and development. The Basics section introduces fundamental knowledge of relational databases, the basic features, versions, installation, and T-SQL fundamentals of SQL Server 2000. The Applications section includes four small-scale examples: creating a credit-based course selection database, creating credit-based course selection database tables, creating a course selection record query, and creating XML queries. The Advanced section includes three larger, comprehensive examples: creating a student information management form, a credit-based course selection management system, and a book sales system. The examples in each section are highly practical, covering most operational knowledge points of SQL Server 2000 database management and development, including database management, table management, queries and views, XML queries, and ADO database access components. This book is targeted at SQL Server 2000 intermediate and advanced users with some foundational knowledge, as well as professionals involved in database management system development and computer enthusiasts for learning and use. It can also serve as supplementary teaching material for relevant social training institutions and universities/colleges. To facilitate readers' learning and operations, the source code for all examples in the book is included in the accompanying CD-ROM, for readers to use during their learning process.