数据库基础知识西培训胶片v161.pptVIP

数据库基础知识培训胶片;数据库原理 ;目标;IN Database;DBClient (DBA);Tables;PPS Service Data Table;Rows;Columns Each column of a table stands for one attribute, which is one characteristic, feature, or fact that is true of the subject of the table.;Operations on Tables;Database Objects;What is a View?;Why Use Views?;What are Constraints?;What is an Index?;How Are Indexes Created?;Data Types;总结;SQL语言基础 ;目标;SQL Statements;基础SELECT 语句语法; ; ; ; ; ;字符串和日期值;比较条件;其它的比较条件; ; ; ; ;逻辑条件; ; ; ;数据操作语句;INSERT 语句语法;向表中插入新的数据行; ;带子查询的INSERT 语句. 字段的数据类型必须匹配.;UPDATE 语句语法;UPDATE employees SET department_id = 70 WHERE empl