Sybase Concise Tutorials

The first lecture on Sybase basic knowledge

First, customer/server architecture

Second, the basic process of accessing Sybase server

Three, Sybase product overview

Iv. main contents of Sybase SQL Server

V. Sybase installation and Configuration

The second part is about database equipment and storage space management

First, Sybase database equipment and storage space management overview

Second, Sybase's equipment (Device)

Iii. creating and using segments in Sybase

The third part is about database and transaction log

First, create Sybase user database

Ii. Changing the Sybase database

Third, the transaction log

Database Security and User management

Overview of database Security Management

Ii. Understanding Sybase Database Roles

Three, Sybase server account management

Iv. Database User Management

Five, Sybase user's rights management

The backup and recovery of database

Database backup and recovery is an important way for SQL Server to secure data, and to prevent accidents, database administrators must regularly and regularly make backups of the database. Once the system fails, the data can be recovered in a timely manner.

I. Basic CONCEPTS

1. Transaction processing and its log

SQL Server uses transactions to track all database changes. A transaction is a unit of work for SQL Server. A transaction contains one or more t_sql statements that succeed or fail as a whole. Each database has its own transaction log, the system table syslogs, and the transaction log automatically records every transaction issued by each user, and it eats up enough information for each transaction to ensure that the data can be recovered.

2. Checkpoint (CheckPoint)

When does the server update data?

--at checkpoints. When a checkpoint is issued by the server: (1) The data is updated, (2) The mark that performs the checkpoint is recorded in the log.

Checkpoints can write all dirty pages to a database device, and dirty pages refers to pages that have been modified in memory, but not modified on disk, since the last checkpoint. The automatic checkpoint mechanism of SQL Server guarantees that the data pages of the completed transaction modifications are regularly written to the database device from an in-memory buffer.

Second, Sybase's backup

Iii. Sybase Database Recovery

Iv. developing strategies for backup and recovery

Due to the special role of the transaction log in restoring the database, you should back up the database and its transaction log regularly, and the transaction log should be backed up more frequently. For example, the database is backed up once a week and the transaction log is backed up every day.

About databases and T-SQL languages

First, what is the relationship model

II. Overview of Sybase SQL language

Iii. Sybase data types

Four, Sybase data definition language

Sybase's data manipulation language

Vi. Sybase predefined functions

Vii. Data-Control language

Used to control the security of data, such as permission control statements Grant and revoke.

The seventh is about database programming basics

One, batch processing study

Second, Sybase Process Control

Iii. Sybase's stored procedures

Four, what is a trigger

V. What is a cursor

Vi. What is a transaction: maintaining data consistency and recovery