数据库基本知识点培训胶片.pptVIP

数据库基础知识培训胶片;数据库原理 ;目标;IN Database;Definition of a Relational Database;Relational Database Management System;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.;The Relational Model;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 employee_id = 113; 1 row updated.; ;DELETE 语句语法;通过WHERE条件指定删除的行. 省略 WHERE 条件，所有的行都将被删??.; ;数据库事务;数据库事务;控制事务;UPDATE... SAVEPOINT update_done; Savepoint created. INSERT... ROLLBACK TO update_done; Rollback complete.;自动的 commit 发生在 : DDL 语句执行;COMMIT; Commit complete.; ;总结;练习;数据库函数;目标;SQL Functions;字符型函数;Function;使用大小写处理函数;CONCAT(Hello, World) SUBSTR(HelloWorld,1,5) LENGTH(HelloWorld) INSTR(HelloWorld, W) LPAD(salary,10,*) RPAD(salary, 10, *) TRIM(H FROM HelloWorld);SELECT employee_id, CONCAT(first_name, last_name) NAME, job_id, LENGTH (last_name), INSTR(last_name, a) Contains a? FROM employees WHERE SUBSTR(job_id, 4) = REP;;日期函数;MONTHS_BETWEEN (01-SEP-95,11-JAN-94);转换函数;使用 TO_CHAR 函数转换日期;YYYY;使用 TO_NUMBER 和 TO_DATE 函数 ;总结;练习;使用 TO_NUMBER 和 TO_DATE 函数