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

数据库基础知识培训胶片;数据库原理 ;目标;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 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语句;总结;练习;数据库函数;目标;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);转换函数;Using the TO_CHAR Function with Dates;YYYY;使用 TO_CHAR 函数转换日期;使用 TO_NUMBER 和 TO_DATE 函数 ;总结;练习;问题和解答;3F7IaLdPgSjVnYq$t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E6H9KcOfRiUmXp!sv)z0C3F7IaMdPgSkVnYq$t*x-A1D5G8JbNeQiTlWo#r%u(y+B3E6H9LcOfRjUmXp!sw)z0C4F7IaMdPhSkVnZq$t*x-A2D5G8KbNeQiTlXo#r%v(y+B3E6I9LcOgRjUmYp!tw)z1C4F7JaMePhSkWnZq$u*x-A2D5H8KbNfQiTlXo#s%v(y0B3E6I9LdOgRjVmYp!tw-z1C4G7JaMePhTkWnZr$u*x+A2E5H8KcNfQiUlXp#s%v)y0B3F6IaLdOgSjVmYq!tw-z1D4G7JbMePhTkWoZr$u(x+A2E5H9KcNfRiUlXp#sv)y0C3F6IaLdPgSjVnYq!t*w-A1D4G8JbMeQhTlWoZr%u(x+B2E5H9KcOfRiUmXp#sv)z0C3F7IaLdPgSkVnYq$t*w-A1D5G8JbNeQhTlWo#r%u(y+B2E6H9LcOfRjUmXp!sw)z0C4F7IaMdPgSkVnZq$t*x-A1D5G8KbNeQiTlWo#r%v(y+B3E6H9LcOgRjUmYp!sw)z1C4F7JaMdPhSkWnZq$u*x-A