|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/plsql-by-example/
课程评论：没有评论
课程名称：PL/SQL示例 - 从初学者到高级PL/SQL 课程概述：在短短四周内学习成为PL/SQL开发者。本课程快速、便捷且高效，可以将你从零基础的PL/SQL写作技能提升到能够编写有效程序以处理数据。PL/SQL是Oracle的SQL过程语言扩展，一个PL/SQL程序既可以包含SQL语句，也可以包含过程语句。在PL/SQL程序中，SQL语句用于访问存储在数据库中的数据集，而过程语句则用于处理单个数据并控制程序的执行流程。 在本课程中，参与者将学习： - 描述PL/SQL的特性和语法 - 设计高效执行的PL/SQL匿名块 - 使用Oracle提供的PL/SQL包生成屏幕输出 - 创建和调试存储过程和函数 - 设计PL/SQL包以分组相关构造 - 使用PL/SQL编程构造并有条件地控制代码流程 - 创建重载的包子程序以实现更大的灵活性 - 通过异常处理运行时错误 - 使用记录编写可管理的代码 - 使用集合存储和处理数据 - 通过隐式和显式游标处理数据 使用软件：Oracle Database 11g、SQL Developer
Learn to become a PL/SQL developer in just four weeks. This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data. PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow. In this course participants will learn Describe the features and syntax of PL/SQLDesign PL/SQL anonymous blocks that execute efficientlyUse the Oracle supplied PL/SQL packages to generate screen outputCreate and debug Stored Procedures and FunctionsDesign PL/SQL packages to group related constructsUse PL/SQL programming constructs and conditionally control code flow Create overloaded package subprograms for more flexibilityHandle runtime errors using ExceptionsWriting manageable code using RecordsStoring and processing data using CollectionsProcessing data using Implicit and Explicit Cursors Softwares used Oracle Database 11gSQL Developer
