1. 1 Introduction to Database System

1. 1. 1 What is a database?

1. 1.2 file system defects

1. 1.3 database management system

1. 1.4 database system.

1.2 architecture of database system

1.2. 1 Three-level schema structure of database system

1.2.2 workflow of database management system

1.2.3 design goal of database system

1.3 database model

1.3. 1 conceptual model

1.3.2 data logic model

1.4 relational model system

1.4. 1 relation and relation pattern

1.4.2 relational algebra

Exercise 1

Chapter two. Server2000 system installation and configuration

2. Characteristics of1SQL Server 2000

2.1.1SQL server 2000 client server architecture

2.1.2 Query Language of SQL Server 2000 -Interactive SQL

2.1.3 New features of SQL Server 2000

2.2 installation of SQL server 2000

2.2. Various versions of1SQL Server' 2000

hardware requirement

software requirement

2.2.4 installing SQLServer2000

2.3 SQLServer2000 server-side operation

2.3. Program group command item of1SQL Server

2.3.2 SQLServer server-side operation

2.4 configuring SQLServer2000

2.5 operation of SQL server 200o client

2.5. Functions of1SQL query analyzer

2.5.2SQL the use of SQL query analyzer

Exercise 2

Chapter 3 Database Equipment and Database

3. Storage structure of1SQL Server database

3.2 Database storage devices

3.2. 1 database equipment

Database structure

3.3 Create a user database

3.4 Management database

3.4. 1 Open the database.

View database information

3.4.3 Modify the database capacity

3.4.4 Changing the database name

Delete database

Exercise 3

Chapter 4 Data Definition

4. 1 Create a table in the database

4. 1.l Create a table using Enterprise Manager.

4. 1.2 Create a table with the CREATETABLE statement.

4.2 Basic operation and information viewing of data table

4.2. 1 Add data to the table

4.2.2 Delete the data in the table

4.2.3 Update the data in the table

4.2.4 Check the information in the table.

4.3 Modify the structure of the table

4.3. 1 Use Enterprise Manager to modify the table structure.

4.3.2 using t-SQL statement to modify the table

4.4 Delete form

4.4. 1 Delete the table with Enterprise Manager

4.4.2 using t-SQL statements to delete tables

Exercise 4

Chapter V Data Query

5. 1 Introduction

5.2 Simple query

5.3 Connection query

……

Chapter 6 Insertion, Delete and Modification of Data

Chapter 7 T-SPL language programming foundation

Chapter 8 Indexes and Views

Chapter 9 Cursors, Stored Procedures and Triggers

Chapter 10 Data Integrity and Transaction Control

Chapter 1 1 System Management

12 Chapter Database Design and Development

refer to