|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-plsql-course/
课程评论：没有评论
《Oracle SQL PL/SQL 线上培训教程》 这是一门为 Oracle Apps 技术课程学习者准备的基础课程。 课程内容涵盖： **一、关系型数据库与 SQL 基础** * 关系型数据库管理系统 (RDBMS) 简介 * SQL 简介 * Oracle 数据类型 * SQL 分类 * DDL (数据定义语言) 和 DML (数据操作语言) 命令（含进阶内容） * 完整性约束 * SQL 函数（字符函数、数字函数、日期函数、分组函数） * 连接 (Joins)、子查询 (Sub Queries) 与子句 (Clauses) **二、数据库对象与控制** * 数据库对象（含进阶内容） * DCL (数据控制语言) 和 TCL (事务控制语言) 命令 **三、PL/SQL 编程** * PL/SQL 简介 * PL/SQL 数据类型与 PL/SQL 块 * 循环结构（WHILE 循环、嵌套循环、循环结构延续） * 条件语句 * 游标 (Cursors) * 异常处理（含进阶内容） * 过程 (Procedures) * 函数 (Functions) * 程序包 (Packages) **总结：**本课程全面教授 Oracle SQL 和 PL/SQL 的核心概念与实践技巧，为学习者打下坚实的数据库基础。
Oracle SQL PLSQL Training Course (A Prerequisite Course for Oracle Apps Technical Course Learners) Topics covered are Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, DDL and DML Commands Continued, Integrity Constraints, SQL Functions, Character Functions, Number Functions, SQL Functions Continued, Date Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages , Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages
