Database Technology Basics and Applications

Author: Liu Guoxun
Publisher:
Publish Date: 2003-09-01
Features: This book is one of the "Computer Fundamentals and Applications Textbooks for Higher Education Institutions," primarily introducing database technology while striving to reflect three key characteristics: fundamental, practical, and advanced. The book is divided into 4 chapters.
Chapter 1 introduces the basic concepts of database systems, explaining various terms and the architecture of database systems in a step-by-step manner.
Chapter 2 covers the fundamental theories of relational databases, comprehensively presenting relational operation theory and relational normalization theory in an orderly progression.
Chapter 3 focuses on SQL language as the main thread, introducing the use of two software programs—Access2000 and SQLServer2000—detailed explanations of SQL statements and operations on various database objects, along with numerous examples.
Chapter 4 primarily discusses practical development techniques for database application systems, including the development steps of database application systems, accessing databases using various popular tools and programming interfaces (ODBC, ADO, VB), Data Transformation Services (DTS), data integration (Access and SQLServer), generating web pages from selected data, and accessing databases using ASP.
This book, as a textbook, provides detailed explanations of knowledge points and practical operations, making it suitable for undergraduate students of computer science and technology in higher education institutions and students of related disciplines at the junior college level. It can also serve as a reference for programmers and database administrators in enterprises and institutions.
This course is publicly offered on the Computer Fundamentals Teaching Network of South China University of Technology, and students can enroll online.