SQL Server Database Development Classic Examples Solved

Author: Xia Banggui Liu Fanxin
Publisher:
Publishing Time: Not available
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 basics of SQL Server 2000.
The Applications section includes four small-scale examples: creating a credit-based course selection database, creating a credit-based course selection database table, creating a course selection record query, and creating an XML query.
The Advanced section includes three larger, more 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, data table management, queries and views, XML queries, and ADO database access components.
This book is targeted at SQL Server 2000 intermediate to advanced users with some foundational knowledge, 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 vocational colleges.
To facilitate learning and practice, the source code for all the examples in the book is included on the accompanying CD-ROM, for readers to use during their studies.