Database Basics and Application Technology

Author: He Yujie
Publisher:
Publish Date: 2002-06-01
Features: This book provides a concise introduction to the fundamental theories of relational databases and focuses on database application technologies in specific environments. The content is divided into three parts. Part 1 introduces the basic theories of databases, including fundamental concepts of relational databases. Part 2 covers Microsoft SQL Server 2000, which is widely used in current applications. It explains how to construct and maintain databases in this environment, as well as practical database technologies such as T-SQL language, security management, database backup and recovery, data transfer, and data integrity maintenance. Part 3 introduces Microsoft Access 2000, which is a highly regarded personal computer database management system. This section explains how to create and maintain databases and tables in Access, as well as how to generate queries and reports. This book can serve as a mid-to-high-level training textbook for databases, a learning and reference book for non-computer professionals to study and use databases, and also as a reference for computer professionals studying database application technologies.