3.1编程基础知识 3.2常用函数 3.3常量和变量 3.4运算符 3.5常用的系统存储过程 3.6流控语句

7.1 Transact-SQL程序设计 7.2 存储过程 7.3 触发器 7.4 备份和还原

Chapter 4: SQL Background Basic Structure Set Operations Aggregate Functions Null Values Nested Subqueries Derived Relations Views Modification of the Database Joined Relations

第一节SQL概述 第二节数据定义功能 第三节数据操纵功能 第四节数据查询功能

一、PL/SQL概述 二、PL/SQL基础 三、控制结构 四、游标 五、异常处理 六、存储子程序 七、包 八、触发器

▪ Accessing SQL From a Programming Language ▪ Functions and Procedures ▪ Triggers ▪ Recursive Queries ▪ Advanced Aggregation Features

Accessing SQL From a Programming Language Functions and Procedural Constructs Triggers Recursive Queries Advanced Aggregation Features OLAP

Join Expressions Views Transactions Integrity Constraints SQL Data Types and Schemas Authorization

Overview of The SQL Query Language Data Definition Basic Query Structure Additional Basic Operations Set Operations Null Values Aggregate Functions Nested Subqueries Modification of the Database

第一章数据库技术基础 1.1、数据库基础知识 1.2、关系数据库 1.3、数据库设计